Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 84821 invoked from network); 20 May 2010 21:42:43 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 20 May 2010 21:42:43 -0000 Received: (qmail 98478 invoked by uid 500); 20 May 2010 21:42:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 98449 invoked by uid 500); 20 May 2010 21:42:43 -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 98442 invoked by uid 99); 20 May 2010 21:42:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 May 2010 21:42:43 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 May 2010 21:42:40 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o4KLgIO6004991 for ; Thu, 20 May 2010 21:42:18 GMT Message-ID: <10430868.7081274391738817.JavaMail.jira@thor> Date: Thu, 20 May 2010 17:42:18 -0400 (EDT) From: "Ray O'Hagan (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-4671) Embedded driver does not work with jbossCache In-Reply-To: <32321836.6951274391556357.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ray O'Hagan updated DERBY-4671: ------------------------------- Attachment: CacheIssue.java Also attached a full eclipseProject which contains all jars & code to reproduce the problem. > Embedded driver does not work with jbossCache > --------------------------------------------- > > Key: DERBY-4671 > URL: https://issues.apache.org/jira/browse/DERBY-4671 > Project: Derby > Issue Type: Bug > Affects Versions: 10.6.1.0 > Environment: ------------------ Java Information ------------------ > Java Version: 1.5.0_12 > Java Vendor: Sun Microsystems Inc. > Java home: c:\FDE\JDK1.5.0_12\jre > Java classpath: .;C:\Program Files\Java\jre1.5.0_06\lib\ext\QTJava.zip;C:\FDE\db-derby-10.6.1.0-bin/lib/derby.jar;C:\FDE\db-derby-10.6.1.0-bin/lib/derbynet.jar;C:\FDE\db-derby-10 > 6.1.0-bin/lib/derbyclient.jar;C:\FDE\db-derby-10.6.1.0-bin/lib/derbytools.jar > OS name: Windows XP > OS architecture: x86 > OS version: 5.1 > Java user name: rayohagan > Java user home: C:\Documents and Settings\rayohagan.FUTRIX > Java user dir: C:\FDE\db-derby-10.6.1.0-bin\bin > java.specification.name: Java Platform API Specification > java.specification.version: 1.5 > java.runtime.version: 1.5.0_12-b04 > --------- Derby Information -------- > JRE - JDBC: J2SE 5.0 - JDBC 3.0 > [C:\FDE\db-derby-10.6.1.0-bin\lib\derby.jar] 10.6.1.0 - (938214) > [C:\FDE\db-derby-10.6.1.0-bin\lib\derbytools.jar] 10.6.1.0 - (938214) > [C:\FDE\db-derby-10.6.1.0-bin\lib\derbynet.jar] 10.6.1.0 - (938214) > [C:\FDE\db-derby-10.6.1.0-bin\lib\derbyclient.jar] 10.6.1.0 - (938214) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > Current Locale : [English/New Zealand [en_NZ]] > Found support for locale: [cs] > version: 10.6.1.0 - (938214) > Found support for locale: [de_DE] > version: 10.6.1.0 - (938214) > Found support for locale: [es] > version: 10.6.1.0 - (938214) > Found support for locale: [fr] > version: 10.6.1.0 - (938214) > Found support for locale: [hu] > version: 10.6.1.0 - (938214) > Found support for locale: [it] > version: 10.6.1.0 - (938214) > Found support for locale: [ja_JP] > version: 10.6.1.0 - (938214) > Found support for locale: [ko_KR] > version: 10.6.1.0 - (938214) > Found support for locale: [pl] > version: 10.6.1.0 - (938214) > Found support for locale: [pt_BR] > version: 10.6.1.0 - (938214) > Found support for locale: [ru] > version: 10.6.1.0 - (938214) > Found support for locale: [zh_CN] > version: 10.6.1.0 - (938214) > Found support for locale: [zh_TW] > version: 10.6.1.0 - (938214) > ------------------------------------------------------ > Reporter: Ray O'Hagan > Attachments: CacheIssue.java > > > When trying to use jbossCache (version 3.2.5) and an embedded derby driver the following exception is thrown when jbossCache tries to persist information to the database > 48610 [AsyncCacheLoader-0] ERROR org.jboss.cache.loader.JDBCCacheLoader [] - Failed to insert node :Java exception: ': java.lang.NullPointerException'. > 48610 [AsyncCacheLoader-0] WARN org.jboss.cache.loader.AsyncCacheLoader [] - Failed to process async modifications: java.lang.IllegalStateException: Failed to insert node: Java e > xception: ': java.lang.NullPointerException'. > 48610 [AsyncCacheLoader-0] DEBUG org.jboss.cache.loader.AsyncCacheLoader [] - Exception: > java.lang.IllegalStateException: Failed to insert node: Java exception: ': java.lang.NullPointerException'. > at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:562) > at org.jboss.cache.loader.JDBCCacheLoader.addNewSubtree(JDBCCacheLoader.java:367) > at org.jboss.cache.loader.JDBCCacheLoader.put(JDBCCacheLoader.java:110) > at org.jboss.cache.loader.AbstractCacheLoader.put(AbstractCacheLoader.java:303) > at org.jboss.cache.loader.AbstractDelegatingCacheLoader.put(AbstractDelegatingCacheLoader.java:110) > at org.jboss.cache.loader.AsyncCacheLoader.access$601(AsyncCacheLoader.java:105) > at org.jboss.cache.loader.AsyncCacheLoader$AsyncProcessor.put(AsyncCacheLoader.java:417) > at org.jboss.cache.loader.AsyncCacheLoader$AsyncProcessor.run0(AsyncCacheLoader.java:409) > at org.jboss.cache.loader.AsyncCacheLoader$AsyncProcessor.run(AsyncCacheLoader.java:371) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:619) > Caused by: java.sql.SQLException: Java exception: ': java.lang.NullPointerException'. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:142) > at org.apache.derby.impl.jdbc.Util.javaException(Util.java:299) > 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:2269) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(EmbedPreparedStatement.java:148) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(EmbedPreparedStatement20.java:82) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(EmbedPreparedStatement30.java:63) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(EmbedPreparedStatement40.java:40) > at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:105) > at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1607) > at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1435) > at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213) > at org.jboss.cache.loader.AdjListJDBCCacheLoader.prepareAndLogStatement(AdjListJDBCCacheLoader.java:90) > at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:545) > ... 14 more > Caused by: java.sql.SQLException: Java exception: ': java.lang.NullPointerException'. > 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) > ... 30 more > Caused by: java.lang.NullPointerException > at org.apache.derby.impl.sql.compile.CharTypeCompiler.convertible(CharTypeCompiler.java:54) > at org.apache.derby.impl.sql.compile.CharTypeCompiler.storable(CharTypeCompiler.java:100) > at org.apache.derby.impl.sql.compile.ResultColumn.checkStorableExpression(ResultColumn.java:887) > at org.apache.derby.impl.sql.compile.ResultColumn.checkStorableExpression(ResultColumn.java:879) > at org.apache.derby.impl.sql.compile.ResultColumnList.checkStorableExpressions(ResultColumnList.java:953) > at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(InsertNode.java:456) > at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:324) > at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:90) > at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:828) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(EmbedPreparedStatement.java:130) > ... 23 more > It works fine using ClientDriver. > Sample code and configuration files are attached. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.