[
https://issues.apache.org/jira/browse/DERBY-6735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14131206#comment-14131206
]
Knut Anders Hatlen commented on DERBY-6735:
-------------------------------------------
The NullPointerException happened over on the server, so the client-side stack
trace doesn't really tell much about what went wrong. Did derby.log on the
server contain any clues, such as the original NPE?
What does the failing query look like?
> NPE in org.apache.derby.client.am.ClientStatement.completeSqlca
> ---------------------------------------------------------------
>
> Key: DERBY-6735
> URL: https://issues.apache.org/jira/browse/DERBY-6735
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.11.1.1
> Environment: Windows 7 64Bit, Java8_20 64Bit
> Reporter: Thomas Meyer
>
> When using row_number() over() in an SQL I get this exception:
> ERROR XJ001: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC:
> java.lang.NullPointerException¶¶XJ001.U
> java.sql.SQLException: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001,
> SQLERRMC: java.lang.NullPointerException¶¶XJ001.U
> at
> org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
> at org.apache.derby.client.am.ClientStatement.execute(Unknown Source)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown
> Source)
> at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
> at org.apache.derby.tools.ij.main(Unknown Source)
> Caused by: ERROR XJ001: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001,
> SQLERRMC: java.lang.NullPointerException¶¶XJ001.U
> at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
> Source)
> at
> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
> Source)
> at
> org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(Unknown
> Source)
> at org.apache.derby.client.am.ClientStatement.flowExecute(Unknown
> Source)
> at org.apache.derby.client.am.ClientStatement.executeX(Unknown Source)
> ... 9 more
> ij>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
