Setting from TimeOut

View: New views
1 Messages — Rating Filter:   Alert me  

Setting from TimeOut

by Stasa Jerinic :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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
stasa.jerinic@...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - -
www.dato.at
www.nutritional-software.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - -