Setting from TimeOut
"Stasa Jerinic" <[email protected]> Thu, 27 Dec 2007 15:01:57 +0100
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <97DBE7A56589F54FB4C11FB1991CEFCB37DF97@srv_exch1.dato.localhost> |
Hi, I need, that my SQL-statement after a time limit (for example 60 seconds) cancel the executing of the query, if until there I don't get the result. There is the way to write in java: Statement statement= session.connection().createStatement(); statement.setQueryTimeout(60); But is there way to set it global in MySQL (my.cnf) or in Hibernate, because I'm using Hibernate for my program. 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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -