[DERBY-6981] SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.U

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.12.1.1
• Fix Version/s: 10.15.1.3
• Component/s: JDBC
• Labels: newbie
• Environment: OSX,CentOS
• Issue & fix info: Newcomer, Workaround attached
• Bug behavior facts: Crash, Performance
• Assignee: Bryan Pendleton
• Reporter: Roger Sanghee Kim
• Created: 31/Jan/18 02:07
• Updated: 01/May/19 16:08
• Resolved: 08/Feb/18 02:50

Description

Original error mesage:

 

java.sql.SQLException: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.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.ClientResultSet.next(Unknown Source) at org.ziptie.provider.credentials.internal.test1.main(test1.java:43) Caused by: ERROR XJ001: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.U at org.apache.derby.client.am.ClientResultSet.completeSqlca(Unknown Source) at org.apache.derby.client.net.NetResultSetReply.parseFetchError(Unknown Source) at org.apache.derby.client.net.NetResultSetReply.parseCNTQRYreply(Unknown Source) at org.apache.derby.client.net.NetResultSetReply.readFetch(Unknown Source) at org.apache.derby.client.net.ResultSetReply.readFetch(Unknown Source) at org.apache.derby.client.net.NetResultSet.readFetch_(Unknown Source) at org.apache.derby.client.net.NetResultSet.flowFetch(Unknown Source) at org.apache.derby.client.net.NetCursor.getMoreData_(Unknown Source) at org.apache.derby.client.am.Cursor.stepNext(Unknown Source) at org.apache.derby.client.am.Cursor.next(Unknown Source) at org.apache.derby.client.am.ClientResultSet.nextX(Unknown Source)

DERBY-6735 is very similar bug.

DDL

 

CREATE TABLE TEST1
(
ID int PRIMARY KEY NOT NULL,
LASTUPDATE timestamp
)

 

I have attached test Code:derby-test.java

test Code with embeded derby : Main.java

^{Full code on my intellij : Test1.zip:}

Another database (PostgreSQL) has no problem.

I also put a workaround in the code.