Hi,
I receive a NullPointerException in the Derby client when trying to
execute a prepared statement from iBATIS. This is the stack trace:
org.apache.derby.client.am.SqlException: The exception
'java.lang.NullPointerException' was thrown while evaluating an
expression. SQLSTATE: XJ001: Java exception: ':
java.lang.NullPointerException'.
at
org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1371)
at
org.apache.derby.client.am.Statement.completeOpenQuery(Statement.java:1042)
at
org.apache.derby.client.net.NetStatementReply.parseOpenQueryFailure(NetStatementReply.java:503)
at
org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(NetStatementReply.java:226)
at
org.apache.derby.client.net.NetStatementReply.readOpenQuery(NetStatementReply.java:56)
at
org.apache.derby.client.net.StatementReply.readOpenQuery(StatementReply.java:49)
at
org.apache.derby.client.net.NetStatement.readOpenQuery_(NetStatement.java:151)
at
org.apache.derby.client.am.Statement.readOpenQuery(Statement.java:1038)
at
org.apache.derby.client.am.PreparedStatement.flowExecute(PreparedStatement.java:1396)
at
org.apache.derby.client.am.PreparedStatement.executeX(PreparedStatement.java:893)
at
org.apache.derby.client.am.PreparedStatement.execute(PreparedStatement.java:884)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
at $Proxy1.execute(Unknown Source)
at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:180)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70)
The SQL I'm running contains two inner joins, a WHERE and ORDER BY
clause and two parameters. Both the parameters are in the WHERE clause.
I did a short test with the 10.2.1.1 beta release too, but the error is
the same.
Any ideas on how I should deal with this internal server error?
Thanks,
Robert