|
Hi Henner, Thanks a lot, it is the right place (DataSourceJDBC.open). I hope it will help me. >What's happen if the timeout is over? Do we get an exception? Yes, there is an exception when timeout is over. I don't know the exact class of the exception. The exception message on MS SQL 2000 is: "[Microsoft][SQLServer 2000 Driver for JDBC]Execution timeout expired."Thanks, Pavel Where do you change the source?Right place is in the DataSourceJDBC.open method for a test. If this helps we should think about a more general way. What's happen if the timeout is over? Do we get an exception? Regards, Henner-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of pvseznam Sent: Tuesday, November 22, 2005 2:55 PM To: [email protected] Subject: [dbforms] Query Timeout Hi all, I use MS SQL 2000. It happens sometimes that the query from dbforms is hanging for whatever reason and it is blocking a table used in the query, too. In pure Java, I set "Statement stmt = conn.createStatement(); stmt.setQueryTimeout(TIMEOUT);" and it finishes unsuccessful query. I tried to change dbforms sources to set query timeout but it was not probably at the right place because it doesn't work. Would it be possible to specify query timeout in dbforms? Or another suggestion? Thanks for any idea, Pavel ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms |
- [dbforms] Query Timeout pvseznam
- RE: [dbforms] Query Timeout Henner Kollmann
- Re: [dbforms] Query Timeout pvseznam
