We normally use DB2 as production database. In the code we have for
example the following statement:
SELECT * FROM TABLE_NAME FETCH FIRST 50 ROWS ONLY
When using an embedded file-persistent H2 database with MODE=DB2
(jdbc:h2:D:\tmp\mydb;MODE=DB2;), then we don't have any problems, but
when we use an embedded in-memory H2 database
(jdbc:h2:mem:MODE=DB2;DB_CLOSE_DELAY=-1), then the execution fails
with :
org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement
SELECT * FROM TEST_TABLE FETCH[*] FIRST 50 ROWS ONLY ;
[42000-116]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.message.Message.getSQLException(Message.java:116)
at org.h2.message.Message.getSQLException(Message.java:75)
at org.h2.message.Message.getSyntaxError(Message.java:128)
at org.h2.command.Parser.getSyntaxError(Parser.java:469)
at org.h2.command.Parser.prepareCommand(Parser.java:250)
at org.h2.engine.Session.prepareLocal(Session.java:409)
at org.h2.engine.Session.prepareCommand(Session.java:370)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
1049)
at org.h2.jdbc.JdbcPreparedStatement.<init>
(JdbcPreparedStatement.java:74)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:
233)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
