Re: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.

Wed, 20 May 2009 07:12:20 -0700 

Schueller, Henriette wrote:



Hello,

I want to report a bug.


Hi Henriette,

Thank you for coming to the user list with your Derby problem :)
Derby uses Jira to track bugs, which you can find at [1].


Also, thanks a lot for providing a repro. I ran it with a debug build, 
and can confirm that it triggers a bug. The rather long stack trace is 
included at the bottom of this mail. Feel free to include it in the Jira 
issue, if you create one. If you don't feel like logging the bug, let us 
know such that a person in the community can do it for you.



Regards
--
Kristian

[1] https://issues.apache.org/jira/browse/DERBY



ERROR XJ001: Java exception: 'ASSERT FAILED ColumnReference for correct 
column (columnPosition = 1, exposed table name = POCSTRUCT12_121) not 
found on either side of BinaryRelationalOperator: 
org.apache.derby.shared.common.sanity.AssertFailure'.
java.sql.SQLException: Java exception: 'ASSERT FAILED ColumnReference 
for correct column (columnPosition = 1, exposed table name = 
POCSTRUCT12_121) not found on either side of BinaryRelationalOperator: 
org.apache.derby.shared.common.sanity.AssertFailure'.
	at 
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)

        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
        at org.apache.derby.impl.jdbc.Util.javaException(Util.java:244)

	at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403)
	at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
	at 
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
	at 
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
	at 
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
	at 
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)

        at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
        at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:505)
        at 
org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:347)
        at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
        at org.apache.derby.impl.tools.ij.Main.go(Main.java:210)
        at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:177)
        at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
        at org.apache.derby.tools.ij.main(ij.java:59)

Caused by: java.sql.SQLException: Java exception: 'ASSERT FAILED 
ColumnReference for correct column (columnPosition = 1, exposed table 
name = POCSTRUCT12_121) not found on either side of 
BinaryRelationalOperator: 
org.apache.derby.shared.common.sanity.AssertFailure'.
	at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
	at 
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
	at 
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)

        ... 16 more

Caused by: org.apache.derby.shared.common.sanity.AssertFailure: ASSERT 
FAILED ColumnReference for correct column (columnPosition = 1, exposed 
table name = POCSTRUCT12_121) not found on either side of 
BinaryRelationalOperator
	at 
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:162)
	at 
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:147)
	at 
org.apache.derby.impl.sql.compile.BinaryRelationalOperatorNode.generateExpressionOperand(BinaryRelationalOperatorNode.java:488)
	at 
org.apache.derby.impl.sql.compile.Predicate.generateExpressionOperand(Predicate.java:670)
	at 
org.apache.derby.impl.sql.compile.PredicateList.generateSetColumn(PredicateList.java:3524)
	at 
org.apache.derby.impl.sql.compile.PredicateList.generateStartKey(PredicateList.java:3348)
	at 
org.apache.derby.impl.sql.compile.BaseJoinStrategy.fillInScanArgs1(BaseJoinStrategy.java:109)
	at 
org.apache.derby.impl.sql.compile.NestedLoopJoinStrategy.getScanArgs(NestedLoopJoinStrategy.java:248)
	at 
org.apache.derby.impl.sql.compile.FromBaseTable.getScanArguments(FromBaseTable.java:3449)
	at 
org.apache.derby.impl.sql.compile.FromBaseTable.generateResultSet(FromBaseTable.java:3139)
	at 
org.apache.derby.impl.sql.compile.FromBaseTable.generate(FromBaseTable.java:3066)
	at 
org.apache.derby.impl.sql.compile.IndexToBaseRowNode.generate(IndexToBaseRowNode.java:236)
	at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1472)
	at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1336)
	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1579)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
	at 
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)

        at 
org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)

	at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1472)
	at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1336)
	at 
org.apache.derby.impl.sql.compile.ScrollInsensitiveResultSetNode.generate(ScrollInsensitiveResultSetNode.java:109)
	at 
org.apache.derby.impl.sql.compile.CursorNode.generate(CursorNode.java:606)
	at 
org.apache.derby.impl.sql.compile.StatementNode.generate(StatementNode.java:347)
	at 
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:449)
	at 
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
	at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:802)
	at 
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)

        ... 9 more






 

I connect to an empty database; The database has the schema: see 
attached file “jc3iedm-create.sql”.



 

 


C:\SyLT>C:\apache\javadb\bin\ij

IJ Version 10.5

ij> connect 'jdbc:derby:C:\SyLT\db\jc3iedm\current\empty';

ij> run 'C:\SyLT\test.sql';


 


see attached file test.sql


 


The result is:

FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.


 

This is very strange. The select runs I an oracle database without any 
problem.



 


Hope you can help me


 


Henriette Schüller


 

 

 


*************************************************

Henriette Schüller


 


Forschungsgesellschaft für

Angewandte Naturwissenschaften e. V. (FGAN)

Neuenahrer Str. 20, 53343 Wachtberg, Germany

Tel.: 0049 (0)228 9435-522

Fax: 0049 (0)228 9435-685


 


E-Mail: [email protected]

Web: www.fgan.de

************************************************

Sitz der Gesellschaft: Bonn

Registergericht: Amtsgericht Bonn VR 2530


Vorstand: Dr. rer. nat. Ralf Dornhaus (Vors.), Prof. Dr. Joachim Ender 
(Stellv.)(Stellv.)



 

 

 

























					Reply via email to