You are right, it works well in 1.1.108 version.
Thanks!
On Mar 17, 8:42 pm, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> I believe this was fixed in version 1.1.106 (2009-01-04).
> Seehttp://www.h2database.com/html/changelog.html
> "Statement.setQueryTimeout did not work correctly for some
> statements.". You are using version 1.0.79 (exception code is
> [...-79]).
>
> Regards,
> Thomas
>
> On Tue, Mar 17, 2009 at 3:04 PM, Max Sidnin <[email protected]> wrote:
>
> > Hello,
>
> > I have user defined function that returns ResultSet (like table) and
> > it works well.
> > It is used in SQL like:
> > --> "SELECT * FROM MY_FUNCTION(205320, 218402, false, true);"
> > Values in brackets are correct parameters.
>
> > When I've add the parameter "QUERY_TIMEOUT" to the current session
> > --> "SET QUERY_TIMEOUT 60000;"
> > I got the next exception immediately, without any timeout:
>
> > Caused by: org.h2.jdbc.JdbcSQLException: Statement was canceled or the
> > session timed out; SQL statement:
> > (SELECT * FROM MY_FUNCTION(205320, 218402, false, true)) [90051-79]
> > at org.h2.message.Message.getSQLException(Message.java:103)
> > at org.h2.message.Message.getSQLException(Message.java:114)
> > at org.h2.message.Message.getSQLException(Message.java:77)
> > at org.h2.message.Message.getSQLException(Message.java:149)
> > at org.h2.engine.Session.checkCanceled(Session.java:728)
> > at org.h2.command.Prepared.checkCanceled(Prepared.java:265)
> > at org.h2.command.dml.Select.queryFlat(Select.java:480)
> > at org.h2.command.dml.Select.queryWithoutCache(Select.java:547)
> > at org.h2.command.dml.Query.query(Query.java:233)
> > at org.h2.command.CommandContainer.query(CommandContainer.java:79)
> > at org.h2.command.Command.executeQueryLocal(Command.java:140)
> > at org.h2.command.Command.executeQuery(Command.java:121)
> > at org.h2.jdbc.JdbcPreparedStatement.executeQuery
> > (JdbcPreparedStatement.java:96)
>
> > Question: does parameter "QUERY_TIMEOUT" support user defined
> > functions?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
