Hello,
I just upgraded my h2 jdbc driver from h2-1.4.197.jar to h2-1.4.199.jar
and ran into an odd exception. My query is simple:
select date,description,amount from transaction offset 0 limit 50
Here's the error:
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement
"SELECT DATE,DESCRIPTION,AMOUNT FROM TRANSACTION OFFSET 0 LIMIT[*] 50 ";
SQL statement:
select date,description,amount from transaction offset 0 limit 50
[42000-199]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:451)
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.message.DbException.getSyntaxError(DbException.java:229)
at org.h2.command.Parser.getSyntaxError(Parser.java:989)
at org.h2.command.Parser.prepareCommand(Parser.java:686)
I'm not sure what's wrong or whether this is a known issue. Downgrading to
h2-1.4.197.jar for now.
Thanks,
Peter
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/2bbcdf0b-8e3d-4bd8-932d-40169d78f54d%40googlegroups.com.
