Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
Content-class: urn:content-classes:message
Subject: RE: NullPointerException in Derby driver (from at least 10.2.2.0)
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Wed, 13 Feb 2008 16:38:52 -0500
Message-ID: <5268113955D1B54ABB357F639594DAB205E4F6@bcdc.boxicom.lan>
In-Reply-To: <02fe01c86e76$de206380$8700a8c0@referentia.com>
Thread-Topic: NullPointerException in Derby driver (from at least 10.2.2.0)
Thread-Index: Achod4KBJ0qwD6yJR6uK0UYE2nufwQF/lW6gAASWtWA=
References: <5268113955D1B54ABB357F639594DAB205E43A@bcdc.boxicom.lan>
 <200802061516.45234.daniel@nuix.com>
 <02fe01c86e76$de206380$8700a8c0@referentia.com>
From: "Eric Floehr" <Eric.Floehr@3x.com>
To: "Derby Discussion" <derby-user@db.apache.org>

Jim,

That's definitely what we are seeing, and our only option was to restart
the app as well.  You should really check the interrupt, because it
wasn't so much that InterruptedException was thrown at your code in the
thread for us.  What was happening is the interrupt flag was getting set
down in the network layer, the interrupt was successfully handled there,
but the interrupt flag was not getting cleared.  So then, next time
there was a commit on the database (in a totally separate part of the
code) on that thread, we had the problem.

-Eric

> -----Original Message-----
> From: Jim Newsham [mailto:jnewsham@referentia.com]
> Sent: Wednesday, February 13, 2008 2:30 PM
> To: 'Derby Discussion'
> Subject: RE: NullPointerException in Derby driver (from at least
> 10.2.2.0)
>=20
>=20
> I have been seeing this same problem (very) intermittently as well...
> just
> have been way too busy with other things at the time to look into it.
> When
> it occurs, I generally see a NullPointerException on commit, and
> subsequent
> usage of the (statement? connection? data source? not sure exactly)
> gives
> "No current connection" errors.  Our application needs to be restarted
> to
> recover, so I think the data source is no longer usable.
>=20
> This is with embedded 10.3.2.1.  Not sure if the thread is being
> interrupted
> in this case.  I think not, but could be wrong.
>=20
> Jim
>=20
> > -----Original Message-----
> > From: Daniel Noll [mailto:daniel@nuix.com]
> > Sent: Tuesday, February 05, 2008 6:17 PM
> > To: Derby Discussion
> > Subject: Re: NullPointerException in Derby driver (from at least
> 10.2.2.0)
> >
> > On Wednesday 06 February 2008 04:00:26 Eric Floehr wrote:
> > > All,
> > > I'm experiencing a NullPointerException (somewhat random)
> apparently
> > > within the Derby JDBC driver (stack trace below), and am wondering
> if
> > > anyone has any suggestions on finding the root cause.  I am using
> Derby
> > > 10.3.2.1 (though the problem also occurred on 10.2.2.0) with an
> IBATIS
> > > front-end (version 2.3.1.700, though it also occurred with 2.2),
> using
> > > Derby in single-user mode (direct not via server).
> >
> > Interesting, I found exactly the same problem.  I'm not sure whether
> I
> > posted
> > about it to the list or whether I stayed quiet.
> >
> > Do you have another warning earlier in the log about the connection
> having
> > been closed?  The few times I've seen this, the connection has
> "closed
> > itself" (despite being embedded, and thus having no good reason
> to...) and
> > then I've seen these errors for all operations directly afterwards.
> >
> > Daniel
>=20
>=20