db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prashanth Menon <pme...@ca.ibm.com>
Subject problem with view's and optimizer
Date Wed, 28 Mar 2007 14:35:40 GMT
Hi all!

I'm using Derby 10.1 and it's been fairly faithful thus far, but I am 
having problems with some of my views.  I create a complex view fine 
through ij (or even calling an sql script) but when I try to select the 
data from the view (select server_id from server_table;) it gives me a 
"ERROR XJ001: Java exception: ': java.lang.NullPointerException' " error. 
And any subsequent access to WORKING tables gives me a "ERROR XJ001: Java 
exception: ': java.lang.NullPointerException' ".  It works fine otherwise, 
I've got many other complex views I can access fine, but this won't work. 
I've attached the output of the log file (note that the view was created 
fine, but accessing the view doesn't work):

----------------------------------------------------------------
2007-03-28 14:01:18.891 GMT:
 Booting Derby version The Apache Software Foundation - Apache Derby - 
10.1.2.5 - (413784): instance c013800d-0111-98d9-bedc-0000001d89a8
on database directory C:\Program Files\derby\databases\TC_B 

Database Class Loader started - derby.database.classpath=''
2007-03-28 14:04:45.000 GMT Thread[main,5,main] (XID = 217812), (SESSIONID 
= 0), (DATABASE = C:\Program Files\derby\databases\TC_B), (DRDAID = null), 
Cleanup action starting
2007-03-28 14:04:45.000 GMT Thread[main,5,main] (XID = 217812), (SESSIONID 
= 0), (DATABASE = C:\Program Files\derby\databases\TC_B), (DRDAID = null), 
Failed Statement is: select server_id from win_srv_view1
java.lang.NullPointerException
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.SelectNode.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.SelectNode.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.TableOperatorNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.JoinNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.TableOperatorNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.JoinNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.TableOperatorNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.JoinNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.SelectNode.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.SelectNode.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.OptimizerImpl.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.SelectNode.modifyAccessPaths(Unknown 
Source)
        at 
org.apache.derby.impl.sql.compile.DMLStatementNode.optimize(Unknown 
Source)
        at org.apache.derby.impl.sql.compile.CursorNode.optimize(Unknown 
Source)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown 
Source)
        at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown 
Source)
        at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown

Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown 
Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown 
Source)
        at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown 
Source)
        at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
        at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
        at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
        at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
        at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
        at org.apache.derby.tools.ij.main(Unknown Source)
Cleanup action completed


Regards,
Prashanth Menon
Mime
View raw message