problems with derby database

["alexander.elsholz" <al...@widas.de>]

hi,

because of the failure discribed in this bug:
http://jira.codehaus.org/browse/CONTINUUM-1355

i tried to use an external derby-database. 

it happened often, that tomcat hangs, and when i killed tomcat the database
was clean.

so now i use my derby db of the glassfish-app.

but when i start my tomcat now i get this error:

2009-03-17 10:25:47,105 [main] WARN 
net.sf.ehcache.config.ConfigurationFactory  - No configuration found.
Configuring ehcach
e from ehcache-failsafe.xml  found in the classpath:
jar:file:/opt/apache-tomcat-5.5.27/webapps/continuum/WEB-INF/lib/ehcache
-1.5.0.jar!/ehcache-failsafe.xml
2009-03-17 10:25:59,544 [main] ERROR JPOX.RDBMS.Schema  - An exception was
thrown while adding/validating class(es) : DERBY S
QL error: SQLCODE: -1, SQLSTATE: 38000, SQLERRMC: java.sql.SQLException:
Java exception: '1: java.lang.ArrayIndexOutOfBoundsE
xception'.^T38000
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: 38000,
SQLERRMC: java.sql.SQLException: Java exception: '1: ja
va.lang.ArrayIndexOutOfBoundsException'.^T38000
        at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
        at
org.apache.derby.client.am.DatabaseMetaData.getImportedKeys(Unknown Source)
        at
org.jpox.store.rdbms.RDBMSStoreHelper.getForeignKeyInfoForTable(RDBMSStoreHelper.java:376)
        at
org.jpox.store.rdbms.table.TableImpl.getExistingForeignKeys(TableImpl.java:937)
        at
org.jpox.store.rdbms.table.TableImpl.validateForeignKeys(TableImpl.java:421)
        at
org.jpox.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:394)
        at
org.jpox.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:2875)
        at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3123)
        at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
        at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
        at
org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
        at
org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
        at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
        at
org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
        at
org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
        at
org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
        at
org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached(PlexusJdoUtils.java:358)
        at
org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached(PlexusJdoUtils.java:346)
        at
org.apache.continuum.dao.AbstractDao.getAllObjectsDetached(AbstractDao.java:156)
        ...

and in derby log:


Database Class Loader started - derby.database.classpath=''
2009-03-17 09:25:59.502 GMT Thread[DRDAConnThread_15,5,main] (XID = 226),
(SESSIONID = 5), (DATABASE = continuum2), (DRDAID =
 C0A88987.O49B-449795775501675641{31}), Cleanup action starting
2009-03-17 09:25:59.502 GMT Thread[DRDAConnThread_15,5,main] (XID = 226),
(SESSIONID = 5), (DATABASE = continuum2), (DRDAID =
 C0A88987.O49B-449795775501675641{31}), Failed Statement is: CALL
SYSIBM.SQLFOREIGNKEYS(?,?,?,?,?,?,?) with 7 parameters begi
n parameter #1:  :end parameter begin parameter #2: NULL :end parameter
begin parameter #3:  :end parameter begin parameter #
4: NULL :end parameter begin parameter #5: NULL :end parameter begin
parameter #6: SYSTEMCONFIGURATION :end parameter begin p
arameter #7: DATATYPE='JDBC';IMPORTEDKEY=1; CURSORHOLD=1 :end parameter
java.lang.ArrayIndexOutOfBoundsException: 1
        at
org.apache.derby.impl.sql.GenericParameterValueSet.initialize(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.BaseActivation.setupActivation(Unknown
Source)
        at org.apache.derby.impl.sql.GenericActivationHolder.<init>(Unknown
Source)
        at
org.apache.derby.impl.sql.GenericPreparedStatement.getActivation(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
        ...
Cleanup action completed
New exception raised during cleanup null
java.lang.NullPointerException
        at
org.apache.derby.impl.sql.compile.CompilerContextImpl.initRequiredPriv(Unknown
Source)
        at
org.apache.derby.impl.sql.compile.CompilerContextImpl.resetContext(Unknown
Source)
        at
org.apache.derby.impl.sql.compile.CompilerContextImpl.cleanupOnError(Unknown
Source)

thanks alex
-- 
View this message in context: http://www.nabble.com/problems-with-derby-database-tp22555463p22555463.html
Sent from the Continuum - Users mailing list archive at Nabble.com.