Subject RE: [Firebird-Java] FW: java.lang.ArrayIndexOutOfBoundsException: 0 after Updates
Author Helmut Kaindl
Hello,

here is the full stacktrace:

2013-07-15 22:10:18 [ERROR] esrasoftcommunications.JobDispatcher.run(): java.lang.ArrayIndexOutOfBoundsException: 0
2013-07-15 22:10:18 [TRACE] esrasoftcommunications.JobDispatcher.run(): java.lang.Exception: java.lang.ArrayIndexOutOfBoundsException: 0
at esrasoftcommunications.Database.executeUpdate(Database.java:229)
at esrasoftcommunications.JobData.updateStatus(JobData.java:315)
at esrasoftcommunications.JobDispatcher.run(JobDispatcher.java:118)
at esrasoftcommunications.EsraSoftCommunications.main(EsraSoftCommunications.java:29)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.getSqlCounts(AbstractJavaGDSImpl.java:1648)
at org.firebirdsql.gds.impl.GDSHelper.getSqlCounts(GDSHelper.java:358)
at org.firebirdsql.jdbc.AbstractStatement.getUpdateCount(AbstractStatement.java:942)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:209)
at esrasoftcommunications.Database.executeUpdate(Database.java:223)
at esrasoftcommunications.JobData.updateStatus(JobData.java:315)
at esrasoftcommunications.JobDispatcher.run(JobDispatcher.java:118)
at esrasoftcommunications.EsraSoftCommunications.main(EsraSoftCommunications.java:29)


There is just one thread running. A Java Application started on the linux terminal. I tried it with open java 7 and oracle java 7 runtime environment.

Tanks for your help.

Greetings,
Helmut Kaindl


To: Firebird-Java@yahoogroups.com
From: mark@...
Date: Tue, 16 Jul 2013 09:43:57 +0200
Subject: Re: [Firebird-Java] FW: java.lang.ArrayIndexOutOfBoundsException: 0 after Updates


























On Tue, 16 Jul 2013 00:00:15 +0200, Helmut Kaindl

<helmut.kaindl@...> wrote:

> Hello,

>

> I prepare some Update Statements and execute them about 1000 times.

> All the results are perfect.

> After that I want to make another Update or Select with the same

database

> Connection.

>

> But I always get the

> java.lang.Exception: java.lang.ArrayIndexOutOfBoundsException: 0

> at esrasoftcommunications.Database.executeUpdate(Database.java:229)

> Error.

>

> If I close the connection and open a new at the correct Moment,

everything

> is working fine.

>

> When I Prepare the statements after every update, I get the error

already

> while executing the Updates.

>

> If I close and open the database Connection after every Update - the job

> cannot connect to my database after some time.

>

> So there seem to be no way to get the job to run correct in my

> environment.

>

> Using:

> jaybird-full-2.2.3.jar

> firebird2.5.1 classic on Ubuntu Linux 12.04



I need some more information. Can you post the full stacktrace of the

exception? I would also like to know if you share a connection on multiple

threads concurrently.



Mark

















[Non-text portions of this message have been removed]