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
