How to set TimeOut
"Stasa Jerinic" <[email protected]> Tue, 18 Dec 2007 11:16:35 +0100
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <97DBE7A56589F54FB4C11FB1991CEFCB37DF56@srv_exch1.dato.localhost> |
Hi, I wan't that my SQL questions after 60 seconds cancels, if after then no result set is returned. I can set the timeout in code, like: Statement statement= session.connection().createStatement(); statement.setQueryTimeout(60); Is there generally possibility to set the timeout like in MySQL configuration (my.cnf) or in hibernate (I'm using hibernate for developing my application). Greetings, Stasa Jerinic - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - dato Denkwerkzeuge :: Corneliusgasse 4 :: A-1060 Wien T +43 (0)1 581 29 70 :: F +43 (0)1 581 29 80 [email protected] - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - www.dato.at www.nutritional-software.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -