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
