You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by rob <fu...@gmail.com> on 2011/09/30 16:38:21 UTC
Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption
Hi,
I have a derby database i use it in embeeded mode with datanucleus
JDO, it was at version 10.5 and i have updated it to version 10.8, i
used it for a while with no problems but now, with no reason, it
becomes unusable with datanucleus.
I am able to connect to it with a client like squirrel sql, run query
on it etc, but using it with for example SchemaTool from datanucleus
gives me an exception about the connection closed.
SchemaTool is used to create/update the schema in the database and
these are parts of the logs from running SchemaTool:
15:52:36.875 [main] DEBUG D.Connection - Connection "connection is
closed" is already closed
java.sql.SQLNonTransientConnectionException: No current connection.
Caused by: java.sql.SQLException: No current connection.
I have enabled in derby.properties :
derby.stream.error.logSeverityLevel=0
derby.language.logStatementText=true
and looking on derby.log i see several ArrayIndexOutOfBoundsExeption.
I have to say that if i take the original copy of the database at
version 10.5 and i update it to 10.8 i can use it with no problems
with datanucleus, i don't understand what happened in this case.
In my opinion it's not the update the cause but i don't know what is
wrong with it and if there is some way to fix it.
I have others databases 10.8(created with version 10.8) with the same
schema of this that runs with datanucleus with no problems.
I write below some of the exceptions from derby.log, the problem seems
on the SYS.getIndexInfo.
Thanks for the help
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Begin
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), End
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null
java.lang.ArrayIndexOutOfBoundsException: 0
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729),
(SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Executing
prepared statement: EXECUTE STATEMENT SYS."getTables" :End prepared
statement with 7 parameters begin parameter #1: % :end parameter begin
parameter #2: % :end parameter begin parameter #3: FASCE_LISTA :end
parameter begin parameter #4: T :end parameter begin parameter #5: V
:end parameter begin parameter #6: A :end parameter begin parameter
#7: S :end parameter
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729),
(SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729),
(SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null with 7 parameters begin parameter #1: % :end
parameter begin parameter #2: % :end parameter begin parameter #3:
FASCE_LISTA :end parameter begin parameter #4: T :end parameter begin
parameter #5: V :end parameter begin parameter #6: A :end parameter
begin parameter #7: S :end parameter
java.lang.ArrayIndexOutOfBoundsException: 0
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807),
(SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Executing
prepared statement: EXECUTE STATEMENT SYS."getTables" :End prepared
statement with 7 parameters begin parameter #1: % :end parameter begin
parameter #2: % :end parameter begin parameter #3: FASCE_LISTA :end
parameter begin parameter #4: T :end parameter begin parameter #5: V
:end parameter begin parameter #6: A :end parameter begin parameter
#7: S :end parameter
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807),
(SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807),
(SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null with 7 parameters begin parameter #1: % :end
parameter begin parameter #2: % :end parameter begin parameter #3:
FASCE_LISTA :end parameter begin parameter #4: T :end parameter begin
parameter #5: V :end parameter begin parameter #6: A :end parameter
begin parameter #7: S :end parameter
java.lang.ArrayIndexOutOfBoundsException: 0
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Begin
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), End
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null
java.lang.ArrayIndexOutOfBoundsException: 0
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Begin
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), End
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null
java.lang.ArrayIndexOutOfBoundsException: 0
Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284),
(SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), Begin
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284),
(SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), End
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284),
(SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284),
(SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null
java.lang.ArrayIndexOutOfBoundsException: 0
Re: Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption
Posted by Kathey Marsden <km...@sbcglobal.net>.
On 9/30/2011 8:24 AM, rob wrote:
> Sorry here are the full stacktrace:
Rob, I think you should go ahead and file a bug for this and work on a
reproduction that you can attach to the issue.
http://db.apache.org/derby/DerbyBugGuidelines.html
Please make sure you include the exact 10.5 version you are upgrading from.
Things to try:
1) See if a stand alone java program which just runs getIndexInfo()
runs against the upgraded database pops the issue.
2) If that reproduces the problem and you can't share your database, ry
creating one at the problematic 10.5 version, run getIndexInfo on that,
upgrade to 10.8 and then run getIndexInfo against that.
Below is a small Embedded template program that you can modify when
trying to get a reproduction. Just add a call to
conn.getMetaData().getIndexInfo
Thanks
Kathey
import java.sql.*;
import java.net.*;
import java.io.*;
public class EmbeddedTemplate {
public static void main(String[] args) throws Exception{
try {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection conn =
DriverManager.getConnection("jdbc:derby:wombat;create=true");
// clean up from a previous run
Statement s = conn.createStatement();
try {
s.executeUpdate("DROP TABLE T");
} catch (SQLException se) {
if (!se.getSQLState().equals("42Y55"))
throw se;
}
// Do something with the database.
// Add a couple rows to a table and select
s.executeUpdate("CREATE TABLE T (I INT, C CLOB(1M))");
PreparedStatement ps = conn.prepareStatement("INSERT INTO T
VALUES(?,?)");
ps.setInt(1,1);
ps.setString(2,"Hello");
ps.executeUpdate();
ps.setInt(1,2);
ps.setString(2,"Goodbye");
ps.executeUpdate();
ResultSet rs = s.executeQuery("SELECT * FROM T");
System.out.println("--- RESULTS SELECT * FROM T ---");
while (rs.next()) {
System.out.println(rs.getInt(1) + "," + rs.getString(2));
}
rs.close();
ps.close();
s.close();
conn.close();
} catch (SQLException se) {
while (se != null) {
System.out.println("SQLState=" + se.getSQLState() +
se.getMessage());
se.printStackTrace();
se = se.getNextException();
}
}
}
}
Re: Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption
Posted by rob <fu...@gmail.com>.
Sorry here are the full stacktrace:
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Executing
prepared statement: EXECUTE STATEMENT SYS."getTables" :End prepared
statement with 7 parameters begin parameter #1: % :end parameter begin
parameter #2: % :end parameter begin parameter #3:
FASCETIMBRATURETIPO_LISTA :end parameter begin parameter #4: T :end
parameter begin parameter #5: V :end parameter begin parameter #6: A
:end parameter begin parameter #7: S :end parameter
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Begin
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), End
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650),
(SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null
java.lang.ArrayIndexOutOfBoundsException: 0
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)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQueryUsingSystemTables(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetIndexInfo(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getIndexInfo(Unknown
Source)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
at org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1097)
at org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:696)
at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:398)
at org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3234)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2827)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2557)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2203)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:987)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:953)
at org.datanucleus.store.AbstractStoreManager.initialiseAutoStart(AbstractStoreManager.java:677)
at org.datanucleus.store.rdbms.RDBMSManager.initialiseSchema(RDBMSManager.java:814)
at org.datanucleus.store.rdbms.RDBMSManager.<init>(RDBMSManager.java:387)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:572)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:300)
at org.datanucleus.store.FederationManager.initialiseStoreManager(FederationManager.java:168)
at org.datanucleus.store.FederationManager.<init>(FederationManager.java:70)
at org.datanucleus.ObjectManagerFactoryImpl.initialiseStoreManager(ObjectManagerFactoryImpl.java:153)
at org.datanucleus.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:526)
at org.datanucleus.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:174)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1956)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1951)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1159)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:839)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:698)
at presenze.GeneraSchema.main(GeneraSchema.java:75)
Cleanup action completed
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729),
(SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Executing
prepared statement: EXECUTE STATEMENT SYS."getTables" :End prepared
statement with 7 parameters begin parameter #1: % :end parameter begin
parameter #2: % :end parameter begin parameter #3:
FASCETIMBRATURETIPO_LISTA :end parameter begin parameter #4: T :end
parameter begin parameter #5: V :end parameter begin parameter #6: A
:end parameter begin parameter #7: S :end parameter
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729),
(SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729),
(SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null with 7 parameters begin parameter #1: % :end
parameter begin parameter #2: % :end parameter begin parameter #3:
FASCETIMBRATURETIPO_LISTA :end parameter begin parameter #4: T :end
parameter begin parameter #5: V :end parameter begin parameter #6: A
:end parameter begin parameter #7: S :end parameter
java.lang.ArrayIndexOutOfBoundsException: 0
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)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQueryUsingSystemTables(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetIndexInfo(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getIndexInfo(Unknown
Source)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
at org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1097)
at org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:696)
at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:398)
at org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3234)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2827)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2557)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2203)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:987)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:953)
at org.datanucleus.store.AbstractStoreManager.initialiseAutoStart(AbstractStoreManager.java:677)
at org.datanucleus.store.rdbms.RDBMSManager.initialiseSchema(RDBMSManager.java:814)
at org.datanucleus.store.rdbms.RDBMSManager.<init>(RDBMSManager.java:387)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:572)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:300)
at org.datanucleus.store.FederationManager.initialiseStoreManager(FederationManager.java:168)
at org.datanucleus.store.FederationManager.<init>(FederationManager.java:70)
at org.datanucleus.ObjectManagerFactoryImpl.initialiseStoreManager(ObjectManagerFactoryImpl.java:153)
at org.datanucleus.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:526)
at org.datanucleus.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:174)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1956)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1951)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1159)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:839)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:698)
at presenze.GeneraSchema.main(GeneraSchema.java:75)
Cleanup action completed
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807),
(SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Executing
prepared statement: EXECUTE STATEMENT SYS."getTables" :End prepared
statement with 7 parameters begin parameter #1: % :end parameter begin
parameter #2: % :end parameter begin parameter #3:
FASCETIMBRATURETIPO_LISTA :end parameter begin parameter #4: T :end
parameter begin parameter #5: V :end parameter begin parameter #6: A
:end parameter begin parameter #7: S :end parameter
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807),
(SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807),
(SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null with 7 parameters begin parameter #1: % :end
parameter begin parameter #2: % :end parameter begin parameter #3:
FASCETIMBRATURETIPO_LISTA :end parameter begin parameter #4: T :end
parameter begin parameter #5: V :end parameter begin parameter #6: A
:end parameter begin parameter #7: S :end parameter
java.lang.ArrayIndexOutOfBoundsException: 0
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)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQueryUsingSystemTables(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetIndexInfo(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getIndexInfo(Unknown
Source)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
at org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1097)
at org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:696)
at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:398)
at org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3234)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2827)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2557)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2203)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:987)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:953)
at org.datanucleus.store.AbstractStoreManager.initialiseAutoStart(AbstractStoreManager.java:677)
at org.datanucleus.store.rdbms.RDBMSManager.initialiseSchema(RDBMSManager.java:814)
at org.datanucleus.store.rdbms.RDBMSManager.<init>(RDBMSManager.java:387)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:572)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:300)
at org.datanucleus.store.FederationManager.initialiseStoreManager(FederationManager.java:168)
at org.datanucleus.store.FederationManager.<init>(FederationManager.java:70)
at org.datanucleus.ObjectManagerFactoryImpl.initialiseStoreManager(ObjectManagerFactoryImpl.java:153)
at org.datanucleus.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:526)
at org.datanucleus.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:174)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1956)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1951)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1159)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:839)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:698)
at presenze.GeneraSchema.main(GeneraSchema.java:75)
Cleanup action completed
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Begin
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), End
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883),
(SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null
java.lang.ArrayIndexOutOfBoundsException: 0
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)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQueryUsingSystemTables(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetIndexInfo(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getIndexInfo(Unknown
Source)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
at org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1097)
at org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:696)
at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:398)
at org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3234)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2827)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2557)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2203)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:987)
at org.datanucleus.store.rdbms.SchemaTool.createSchema(SchemaTool.java:699)
at presenze.GeneraSchema.main(GeneraSchema.java:171)
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Begin
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), End
compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo"
:End prepared statement
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup
action starting
Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084),
(SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Failed
Statement is: null
java.lang.ArrayIndexOutOfBoundsException: 0
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)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQueryUsingSystemTables(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetIndexInfo(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getIndexInfo(Unknown
Source)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
at org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1097)
at org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:696)
at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:398)
at org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3234)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2827)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2557)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2203)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:987)
at org.datanucleus.store.rdbms.SchemaTool.createSchema(SchemaTool.java:699)
at presenze.GeneraSchema.main(GeneraSchema.java:171)
Cleanup action completed
On 30 September 2011 16:52, Kathey Marsden <km...@sbcglobal.net> wrote:
> On 9/30/2011 7:38 AM, rob wrote:
>>
>> I write below some of the exceptions from derby.log, the problem seems
>> on the SYS.getIndexInfo.
>
> Rob can you provide the stack trace from the derby.log for the
> ArrayIndexOutOfBoundsException?
>
>
>
Re: Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption
Posted by Kathey Marsden <km...@sbcglobal.net>.
On 9/30/2011 7:38 AM, rob wrote:
> I write below some of the exceptions from derby.log, the problem seems
> on the SYS.getIndexInfo.
Rob can you provide the stack trace from the derby.log for the
ArrayIndexOutOfBoundsException?