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 > ------------------------------------------------------- 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
