db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Date Wed, 20 May 2009 14:11:28 GMT
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: h.schueller@fgan.de
> 
> 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.)
> 
>  
> 
>  
> 
>  
> 


Mime
View raw message