Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 83685 invoked from network); 28 Mar 2007 14:51:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Mar 2007 14:51:08 -0000 Received: (qmail 74174 invoked by uid 500); 28 Mar 2007 14:51:13 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 74156 invoked by uid 500); 28 Mar 2007 14:51:13 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 36016 invoked by uid 99); 28 Mar 2007 14:36:12 -0000 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of pmenon@ca.ibm.com designates 32.97.182.142 as permitted sender) To: derby-user@db.apache.org Subject: problem with view's and optimizer MIME-Version: 1.0 X-Mailer: Lotus Notes Release 7.0 HF242 April 21, 2006 Message-ID: From: Prashanth Menon Date: Wed, 28 Mar 2007 10:35:40 -0400 X-MIMETrack: Serialize by Router on D25ML03/25/M/IBM(Release 7.0.1HF346 | August 4, 2006) at 03/28/2007 10:35:42, Serialize complete at 03/28/2007 10:35:42 Content-Type: multipart/alternative; boundary="=_alternative 00502AE1852572AC_=" X-Virus-Checked: Checked by ClamAV on apache.org This is a multipart message in MIME format. --=_alternative 00502AE1852572AC_= Content-Type: text/plain; charset="US-ASCII" 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 --=_alternative 00502AE1852572AC_= Content-Type: text/html; charset="US-ASCII"
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 --=_alternative 00502AE1852572AC_=--