db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6981) SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.U
Date Wed, 31 Jan 2018 14:37:00 GMT

    [ 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)

Mime
View raw message