RE: Exception after my program sleep for 2 hours.

>I have a java program that uses Torque and it is working fine with
>one  exception. My program might need to sleep for 2 hours, using
>Thread.sleep() but  after it wake up again, torque always throws an
>exception when I try to call doSelect(). Is there  anyway to avoid
>this?.  This program don't do any  connection handling at all.

The exception indicates that this is a mysql problem. please search the net
for this mysql problem.

> In an
>other program, i want to have all my queries running within a
>transaction. So i do a Connection connection=Transaction.begin(); but
>is there any way to specify that this connection should be used as
>default for this thread, so that I don't have to pass the connection
>to all the methods that might need it.

I'm afraid this is not possible at the moment.

    Thomas