Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1E4B4181DF for ; Fri, 18 Dec 2015 05:05:46 +0000 (UTC) Received: (qmail 86253 invoked by uid 500); 18 Dec 2015 05:05:45 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 86226 invoked by uid 500); 18 Dec 2015 05:05:45 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 86216 invoked by uid 99); 18 Dec 2015 05:05:45 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Dec 2015 05:05:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 0134A180565 for ; Fri, 18 Dec 2015 05:05:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.13 X-Spam-Level: *** X-Spam-Status: No, score=3.13 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id o2RNvcyp79zf for ; Fri, 18 Dec 2015 05:05:35 +0000 (UTC) Received: from mail-pa0-f41.google.com (mail-pa0-f41.google.com [209.85.220.41]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 4F79020400 for ; Fri, 18 Dec 2015 05:05:35 +0000 (UTC) Received: by mail-pa0-f41.google.com with SMTP id q3so34105238pav.3 for ; Thu, 17 Dec 2015 21:05:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:subject:to:references:message-id:date:user-agent:mime-version :in-reply-to:content-type; bh=fz00NY/mZuQxUt8m6HhdJQbW/zQdEsE+RlEUR9tolNE=; b=y3dQkXiPiy1gFrREXYPfKNl/COOOtFQ0N47Z/gcZBdmX/9HjJD0YYIK+jSzPchO57G ELbE4EvxAcTdAlUWX6FllmSSEH+4tuhAC2RfZf6l2nSPjx95azBD98/o2ZzsF7oM30cI Jwd0ope21cRnVehxXg8+K9LfALoVn0CUZJ9L2UalEsl0xDHbdjBAbo298B3akAcpI8F+ vrvBra7grdkQTuJisHCjzK0+aqP9o0ggb0+F5e6pFFwf0oktCoGLAukvOvMEMGK1DkMs aFSKe5SzcGEaTYm9dXX+ScyO+kL9Tw4waenc+oo/BFZOBK7yEm3NmUv0mtF1hjRW0wTY uh2Q== X-Received: by 10.66.221.42 with SMTP id qb10mr2307627pac.51.1450415135091; Thu, 17 Dec 2015 21:05:35 -0800 (PST) Received: from [192.168.1.4] (c-73-162-245-116.hsd1.ca.comcast.net. [73.162.245.116]) by smtp.googlemail.com with ESMTPSA id g10sm14659035pfj.15.2015.12.17.21.05.34 for (version=TLSv1/SSLv3 cipher=OTHER); Thu, 17 Dec 2015 21:05:34 -0800 (PST) From: mike matrigali X-Google-Original-From: mike matrigali <"recent:mikemapp1"@gmail.com> Subject: Re: Exception running RunOptimizerTest To: derby-dev@db.apache.org References: Message-ID: <5673941B.8090204@gmail.com> Date: Thu, 17 Dec 2015 21:05:31 -0800 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------040607040905090403080002" This is a multi-part message in MIME format. --------------040607040905090403080002 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit i have not used netbeans so can't help much there. A good place to start looking for errors is derby.log, which should be in your testdb directory. it is probably in your current directory, but could be elsewhere based on various environmental variables. It definitely seems like a setup/jar file/permissions issue. if possible i would suggest getting something running outside netbeans first, if you have not done it yet. just get ij runnings against delivered jars and create a db and run some simple sql. Then try that in netbeans and you will know it is a problem with netbeans setup and not environmental in your system. /mikem On 12/16/2015 12:03 PM, Colm McHugh wrote: > Hi Derby devs, > > I am getting the exception below when running RunOptimizerTest (in org.apache.derbyTesting.system.optimizer). My goal is to step > through the query compilation code to understand how it works. I am using Java 1.8. I am using netbeans 8.0.1 and the class path > includes derbyrun.jar and derbyTesting.jar. Any help appreciated. > > run: > Running test with url jdbc:derby:testdb;create=true > Initializing db ... > SQL Exception :java.sql.SQLException: XJ041.C : [0] testdb > java.sql.SQLException: XJ041.C : [0] testdb > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:115) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:141) > at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:255) > at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2656) > at org.apache.derby.impl.jdbc.EmbedConnection.(EmbedConnection.java:435) > at org.apache.derby.jdbc.InternalDriver$1.run(InternalDriver.java:663) > at org.apache.derby.jdbc.InternalDriver$1.run( > InternalDriver.java:659) > > ========================= R E S U L T S ========================= > at java.security.AccessController.doPrivileged(Native Method) > > at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(InternalDriver.java:657) > at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:306) > at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:963) > at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:147) > at java.sql.DriverManager.getConnection(DriverManager.java:664) > at java.sql.DriverManager.getConnection(DriverManager.java:270) > at org.apache.derbyTesting.system.optimizer.RunOptimizerTest.main(RunOptimizerTest.java:94) > Caused by: ERROR XJ041: XJ041.C : [0] testdb > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory.java:170) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:75) > ... 14 more > Caused by: ERROR XBM01: XBM01.D > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290) > at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java:743) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1841) > at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java:1006) > at org.apache.derby.impl.services.monitor.FileMonitor.createPersistentService(FileMonitor.java:48) > at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java:650) > at org.apache.derby.impl.jdbc.EmbedConnection$5.run(EmbedConnection.java:4062) > at java.security.AccessController.doPrivileged(Native Method) > at org.apache.derby.impl.jdbc.EmbedConnection.createPersistentService(EmbedConnection.java:4056) > at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2649) > ... 11 more > Caused by: java.lang.NullPointerException > at org.apache.derby.impl.store.raw.log.LogToFile.writeControlFile(LogToFile.java:2411) > at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java:3383) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986) > at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:537) > at org.apache.derby.impl.services.monitor.FileMonitor.startModule(FileMonitor.java:48) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:460) > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory$10.run(BaseDataFileFactory.java:3058) > at java.security.AccessController.doPrivileged(Native Method) > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootServiceModule(BaseDataFileFactory.java:3052) > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java:1811) > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java:1287) > at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:227) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986) > at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:537) > at org.apache.derby.impl.services.monitor.FileMonitor.startModule(FileMonitor.java:48) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:460) > at org.apache.derby.impl.store.access.RAMAccessManager$5.run(RAMAccessManager.java:1393) > at java.security.AccessController.doPrivileged(Native Method) > at org.apache.derby.impl.store.access.RAMAccessManager.bootServiceModule(RAMAccessManager.java:1387) > at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:1039) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986) > at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:537) > at org.apache.derby.impl.services.monitor.FileMonitor.startModule(FileMonitor.java:48) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:460) > at org.apache.derby.impl.db.BasicDatabase$5.run(BasicDatabase.java:1001) > at java.security.AccessController.doPrivileged(Native Method) > at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(BasicDatabase.java:995) > at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:777) > at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:186) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986) > at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1814) > ... 18 more > BUILD SUCCESSFUL (total time: 2 seconds) -- email: Mike Matrigali - mikemapp1@gmail.com linkedin: https://www.linkedin.com/in/MikeMatrigali --------------040607040905090403080002 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
i have not used netbeans so can't help much there.

A good place to start looking for errors is derby.log, which should be in your testdb directory.  it is probably
in your current directory, but could be elsewhere based on various environmental variables.  It definitely seems
like a setup/jar file/permissions issue.

if possible i would suggest getting something running outside netbeans first, if you have not done it yet.  just get
ij runnings against delivered jars and create a db and run some simple sql.  Then try that in netbeans and you will
know it is a problem with netbeans setup and not environmental in your system.

/mikem

On 12/16/2015 12:03 PM, Colm McHugh wrote:
Hi Derby devs,

I am getting the exception below when running RunOptimizerTest (in org.apache.derbyTesting.system.optimizer). My goal is to step through the query compilation code to understand how it works. I am using Java 1.8. I am using netbeans 8.0.1 and the class path includes derbyrun.jar  and derbyTesting.jar. Any help appreciated.

run:
Running test with url jdbc:derby:testdb;create=true
Initializing db ...
SQL Exception :java.sql.SQLException: XJ041.C : [0] testdb
java.sql.SQLException: XJ041.C : [0] testdb
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:115)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:141)
at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:255)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2656)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:435)
at org.apache.derby.jdbc.InternalDriver$1.run(InternalDriver.java:663)
at org.apache.derby.jdbc.InternalDriver$1.run(
InternalDriver.java:659)

========================= R E S U L T S =========================
at java.security.AccessController.doPrivileged(Native Method)

at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(InternalDriver.java:657)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:306)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:963)
at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:147)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at org.apache.derbyTesting.system.optimizer.RunOptimizerTest.main(RunOptimizerTest.java:94)
Caused by: ERROR XJ041: XJ041.C : [0] testdb
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory.java:170)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:75)
... 14 more
Caused by: ERROR XBM01: XBM01.D
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java:743)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1841)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java:1006)
at org.apache.derby.impl.services.monitor.FileMonitor.createPersistentService(FileMonitor.java:48)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java:650)
at org.apache.derby.impl.jdbc.EmbedConnection$5.run(EmbedConnection.java:4062)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.jdbc.EmbedConnection.createPersistentService(EmbedConnection.java:4056)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java:2649)
... 11 more
Caused by: java.lang.NullPointerException
at org.apache.derby.impl.store.raw.log.LogToFile.writeControlFile(LogToFile.java:2411)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java:3383)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:537)
at org.apache.derby.impl.services.monitor.FileMonitor.startModule(FileMonitor.java:48)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:460)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory$10.run(BaseDataFileFactory.java:3058)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootServiceModule(BaseDataFileFactory.java:3052)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java:1811)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java:1287)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:227)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:537)
at org.apache.derby.impl.services.monitor.FileMonitor.startModule(FileMonitor.java:48)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:460)
at org.apache.derby.impl.store.access.RAMAccessManager$5.run(RAMAccessManager.java:1393)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.access.RAMAccessManager.bootServiceModule(RAMAccessManager.java:1387)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:1039)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:537)
at org.apache.derby.impl.services.monitor.FileMonitor.startModule(FileMonitor.java:48)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:460)
at org.apache.derby.impl.db.BasicDatabase$5.run(BasicDatabase.java:1001)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(BasicDatabase.java:995)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:777)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:186)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1986)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:334)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1814)
... 18 more
BUILD SUCCESSFUL (total time: 2 seconds)
 


-- 
email:    Mike Matrigali - mikemapp1@gmail.com
linkedin: https://www.linkedin.com/in/MikeMatrigali
--------------040607040905090403080002--