[
https://issues.apache.org/jira/browse/DERBY-6981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16346918#comment-16346918
]
Bryan Pendleton commented on DERBY-6981:
----------------------------------------
Yes, it reproduces for me now. I see the following in my derby.log:
Wed Jan 31 06:35:24 PST 2018 Thread[main,5,main] (XID = 212), (SESSIONID = 1),
(DATABASE = test), (DRDAID = null), Faile
d Statement is: SELECT id, LASTUPDATE FROM test1 WHERE id = ? FOR UPDATE OF id,
LASTUPDATE with 1 parameters begin parameter #1: 3 :end parameter
java.lang.NullPointerException
at
org.apache.derby.iapi.store.access.BackingStoreHashtable.remove(BackingStoreHashtable.java:968)
at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(TableScanResultSet.java:520)
at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:346)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:488)
at
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:450)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:394)
at Main.main(Main.java:123)
> SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.U
> ------------------------------------------------------------------
>
> Key: DERBY-6981
> URL: https://issues.apache.org/jira/browse/DERBY-6981
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.12.1.1
> Environment: OSX,CentOS
> Reporter: Roger Sanghee Kim
> Priority: Major
> Labels: newbie
> Attachments: Main.java, Test1.zip, derby-test.java, test1.java
>
>
> Original error mesage:
>
> {code:java}
> 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)
> {code}
> DERBY-6735 is very similar bug.
> DDL
>
> {code:java}
> CREATE TABLE TEST1
> (
> ID int PRIMARY KEY NOT NULL,
> LASTUPDATE timestamp
> ){code}
>
> 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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
