Thank you both for the responses. Upgrading to 2.1.212 did resolve the issue.
On Saturday, April 9, 2022 at 6:55:42 PM UTC-5 [email protected] wrote: > I wonder, if you hit this bug > <https://github.com/h2database/h2database/issues/3414> > It was fixed in a newly released 2.1.212 > > > > On Thursday, April 7, 2022 at 7:01:21 PM UTC-4 Jake Dunn wrote: > >> I've been trying to resolve this issue when running an integration test >> against an in-memory H2 database. The query itself seems to work fine when >> running against an actual Postgres instance in normal development, but I >> get this error when running against H2. Any thoughts on how to resolve? >> >> ### Error querying database. Cause: >> org.h2.jdbc.JdbcSQLNonTransientException: General error: >> "java.lang.NullPointerException"; SQL statement >> >> [50000-210] at >> app//org.h2.message.DbException.getJdbcSQLException(DbException.java:573) >> at >> app//org.h2.message.DbException.getJdbcSQLException(DbException.java:496) >> at app//org.h2.message.DbException.get(DbException.java:216) at >> app//org.h2.message.DbException.convert(DbException.java:414) at >> app//org.h2.command.Command.executeQuery(Command.java:211) at >> app//org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:248) >> >> at >> app//com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) >> >> at >> app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) >> >> at >> [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) at >> [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> >> at >> [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> at [email protected]/java.lang.reflect.Method.invoke(Method.java:566) >> at >> app//org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) >> >> at platform//com.sun.proxy.$Proxy308.execute(Unknown Source) at >> app//org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) >> >> at >> app//org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) >> >> at >> app//org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) >> >> at >> app//org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) >> >> at >> app//org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) >> at >> app//org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) >> >> at >> app//org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) >> >> at >> app//org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) >> >> at >> app//org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) >> >> at >> app//org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) >> >> at >> app//org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) >> >> at >> [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) at >> [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> >> at >> [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> at [email protected]/java.lang.reflect.Method.invoke(Method.java:566) >> at >> app//org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) >> >> ... 150 more Caused by: java.lang.NullPointerException at >> org.h2.command.query.Query.getParameterValues(Query.java:449) at >> org.h2.command.query.Query.exists(Query.java:523) at >> org.h2.expression.condition.ExistsPredicate.getValue(ExistsPredicate.java:25) >> >> at >> org.h2.expression.condition.ConditionAndOrN.getValue(ConditionAndOrN.java:128) >> >> at >> org.h2.expression.condition.ConditionAndOr.getValue(ConditionAndOr.java:106) >> at >> org.h2.expression.condition.ConditionAndOr.getValue(ConditionAndOr.java:110) >> at org.h2.expression.Expression.getBooleanValue(Expression.java:332) >> at org.h2.table.TableFilter.isOk(TableFilter.java:505) at >> org.h2.table.TableFilter.next(TableFilter.java:451) at >> org.h2.command.query.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1825) >> >> at org.h2.result.LazyResult.hasNext(LazyResult.java:78) at >> org.h2.result.FetchedResult.next(FetchedResult.java:34) at >> org.h2.command.query.Select.queryFlat(Select.java:728) at >> org.h2.command.query.Select.queryWithoutCache(Select.java:833) at >> org.h2.command.query.Query.queryWithoutCacheLazyCheck(Query.java:197) at >> org.h2.command.query.Query.query(Query.java:494) at >> org.h2.command.query.Query.query(Query.java:457) at >> org.h2.index.ViewIndex.find(ViewIndex.java:270) at >> org.h2.index.ViewIndex.find(ViewIndex.java:153) at >> org.h2.index.IndexCursor.find(IndexCursor.java:161) at >> org.h2.table.TableFilter.next(TableFilter.java:394) at >> org.h2.command.query.Select.gatherGroup(Select.java:517) at >> org.h2.command.query.Select.queryGroup(Select.java:488) at >> org.h2.command.query.Select.queryWithoutCache(Select.java:828) at >> org.h2.command.query.Query.queryWithoutCacheLazyCheck(Query.java:197) at >> org.h2.command.query.Query.query(Query.java:494) at >> org.h2.command.query.Query.query(Query.java:457) at >> org.h2.command.CommandContainer.query(CommandContainer.java:256) at >> org.h2.command.Command.executeQuery(Command.java:190) ... 175 more >> >> >> -- 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/30fa064b-2d3e-45ea-93bf-1997854add65n%40googlegroups.com.
