Hi,
We're using H2 (version 1.2.143) in a Grails project with connection
string
"jdbc:h2:file:mydb;MVCC=TRUE;DEFAULT_LOCK_TIMEOUT=3000;AUTO_SERVER=TRUE;CACHE_SIZE=262144"
When using a pooled datasource, the following stacktrace occurs
regularly when performing a criteria query over a view:
13:55:08,168 ERROR [GrailsExceptionResolver] - General error:
"java.lang.NullPointerException" [50000-143]
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.NullPointerException" [50000-143]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:186)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:139)
at java.lang.Thread.run(Thread.java:637)
Caused by: java.lang.NullPointerException
at org.h2.index.IndexCursor.get(IndexCursor.java:209)
at org.h2.table.TableFilter.getValue(TableFilter.java:824)
at
org.h2.expression.ExpressionColumn.updateAggregate(ExpressionColumn.java:
133)
at org.h2.expression.Comparison.updateAggregate(Comparison.java:411)
at
org.h2.expression.ConditionAndOr.updateAggregate(ConditionAndOr.java:
242)
at org.h2.command.dml.Select.updateAggregate(Select.java:1106)
at org.h2.expression.Subquery.updateAggregate(Subquery.java:92)
at org.h2.expression.Alias.updateAggregate(Alias.java:76)
at org.h2.command.dml.Select.queryGroup(Select.java:336)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:575)
at org.h2.command.dml.Query.query(Query.java:241)
at org.h2.index.ViewIndex.find(ViewIndex.java:231)
at org.h2.index.IndexCursor.find(IndexCursor.java:138)
at org.h2.table.TableFilter.next(TableFilter.java:309)
at org.h2.table.TableFilter.next(TableFilter.java:379)
at org.h2.table.TableFilter.next(TableFilter.java:379)
at org.h2.table.TableFilter.next(TableFilter.java:379)
at org.h2.command.dml.Select.queryFlat(Select.java:493)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:580)
at org.h2.command.dml.Query.query(Query.java:241)
at org.h2.index.ViewIndex.find(ViewIndex.java:231)
at org.h2.index.IndexCursor.find(IndexCursor.java:138)
at org.h2.table.TableFilter.next(TableFilter.java:309)
at org.h2.command.dml.Select.queryFlat(Select.java:493)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:580)
at org.h2.command.dml.Query.query(Query.java:241)
at org.h2.command.CommandContainer.query(CommandContainer.java:80)
at org.h2.command.Command.executeQuery(Command.java:132)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:278)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
This doesn't happen the first time the query runs after the
application starts, but every time afterwards. Also, when not using a
pooled connection, this problem doesn't seem to appear, so we are
currently assuming it might have something to do with Hibernate
session management in Grails. However, the NullPointerException
doesn't give us any hints on where to start and there is no related
Hibernate exception.
The AUTO_SERVER feature is used, because there are actually two
separate web applications running, sharing the same database and it's
not predictable which application starts first.
I'd appreciate any hints for a workaround or solution,
Chris
--
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.
