Hi,
> Query timeouts: statement.setQueryTimeout(15/*seconds*/); is not working
> and will prevent the query from being executed (at least for me).
> I use version 1.1.103 (2008-11-07) and there is only this one version
> in the classpath, I double checked.
> If I set timeouts to 15 (seconds, I tried 15000 as well guessing it
> could be milliseconds) I get this exception cause:
> "Caused by: org.h2.jdbc.JdbcSQLException: Statement was canceled or
> the session timed out [90051-103]"
I can't reproduce it. My test case is:
Class.forName("org.h2.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:h2:~/test", "sa", "sa");
Statement stat = conn.createStatement();
stat.setQueryTimeout(15);
ResultSet rs = stat.executeQuery(
"select 'Hello' from dual");
rs.next();
System.out.println(rs.getString(1));
conn.close();
Maybe your query takes longer than 15? In that case the exception
would be the expected behavior ('If the limit is exceeded, an
SQLException is thrown.')
> I can not give you a simpler and "cleaner" query, but this
> one is generated from out parser and the offending order by is
> commented out...
Thanks for the query! Unfortunately it is very hard for me to
reproduce the problem because I don't have the CREATE TABLE
statements. Could you send them please? The easiest way to get them is
running SCRIPT NO DATA TO 'db.sql' and then post the file db.sql (it
doesn't contain any data).
> With version 1.1.103 and removing "flexive" and having flexiveTest and
> flexiveConfiguration the command line you print in the webfrontend is
I didn't test with LOB files. Now I can reproduce the problem... I
will correct it for the next release of course (end of this week).
Regards,
Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
