[Lazarus] SQLTransaction won't start

[Petr Hlozek]

Unfortunately this problem is only when I try to run the app in
Lazarus and put breakpoit somewhere. When I run it directly in
terminal, it always will connect to database, I can run queries, get
results but transaction is still not active like it was in the
example.



2014-03-15 13:14 GMT+01:00 Marc Santhoff <M.Santhoff at web.de>:
> On Sa, 2014-03-15 at 07:23 +0100, Petr Hlozek wrote:
>> I wanted to find out where is the problem and started with breakpoint
>> on db := TMySQL55Connection.Create. It went fine until it reached
>> db.Open line. After I hit F8 on this line, it hangs. Next time it
>> hangs on tr.StartTransaction with this error:
>>
>> The GDB command:
>> "ptype tr.StartTransaction"
>> did not return any result.
>
> So this looks like your tarnsaction cannot connect to the database burt
> you're getting no error message but a hang.
>
> You could
> - check that anything inbetween your program and the database is
> actually working. Using another client program may help to narrow down
> the target
> - turn on logging for mysql temporarily (the log fills up fast) and
> check if mysql sees the connection attempt
> - instead of stepping over the first erroneous line step into and look
> what happens in detail
>
> HTH,
> Marc
>