Vennila
By default, ScriptTool does a Statement.setQueryTimeout (300) at start up.
You can up this using the command
c set timeout 30000;
or whatever.
> What is the use of timerCheck
> property in .prp file
This is the interval after which the timer thread wakes up and checks to see
if any transactions are taking too long (as defined by setQueryTimeout). The
default, 5000, causes the thread to wake up every 5 seconds. So, if you set
a timeout of 60s, say, then an exception will occur somewhere between 60 and
65s.
Regards
Pete
--
Peter Hearty peter.hearty@lutris.com
Lutris Technologies (UK) http://www.lutris.com
----- Original Message -----
From: "Vennila Irudhayaraj" <vennila@rss.dl.nec.com>
To: <instantdb@enhydra.org>
Sent: Tuesday, September 19, 2000 5:33 PM
Subject: InstantDB: SQLException: taking too long
> Hi,
>
> When i try to export the database fields to a file using ScriptTool, it
> complains that SQLException : Query is taking too long. I tried using
> both the idbDriver and RJDriver.
> Can anybody give me suggestions on this. What is the use of timerCheck
> property in .prp file
>
> Thanks,
>
> Vennila
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|