db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rob <fury...@gmail.com>
Subject Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption
Date Fri, 30 Sep 2011 14:38:21 GMT
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

Mime
View raw message