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 Rhys Campbell <rh...@da-systems.co.uk> on 2006/03/03 02:20:46 UTC
No current connection
Hi,
I'm using Derby for a current project for the first time. Got on with it pretty well until tonight.
My app starts up a database, drops a few views and then recreates them. When another one of my Java classes moves on to do a small SELECT (that should yield a single result). The exception "No current connection" is raised with the query obviously failing.
I have checked the Derby.log but I am warned that the file is binary, when it opens in my editor, and a load of "junk" is displayed. I did use a little tool called "fd" which is a oct / hex character editor. This did make some sections of text legible but I couldn't see anything useful to explain my issue.
Can anyone offer me any pointers?
Many thanks,
Rhys
Re: No current connection
Posted by Rajesh Kartha <ka...@gmail.com>.
Hi Rhys,
>My app starts up a database, drops a few views and then recreates them.
When another one of my Java classes moves on to do a >small SELECT (that
should yield a single result). The exception "No current connection" is
raised with the query obviously failing.
Hard to tell what must be wrong. A repro (SQL or java program) would be
really useful, is that possible ?
>I have checked the Derby.log but I am warned that the file is binary, when
it opens in my editor, and a load of "junk" is displayed.
The derby.log typically should contain readable logs and stack traces,
unless some of the Derby properties such as 'derby.language.logStatementText'
(to log all statements executed) or 'derby.stream.error.logSeverityLevel'
(to log errors into the derby.log file) are used.
Using these properties will log the entire SQL statements, say - INSERT of
binary data into BLOBs, into the derby.log - thus ending up with unreadable
binary data. Are you working with binary data (BLOB etc.) and using any
Derby properties?
-Rajesh
On 3/2/06, Rhys Campbell <rh...@da-systems.co.uk> wrote:
>
> Hi,
>
> I'm using Derby for a current project for the first time. Got on with it
> pretty well until tonight.
>
> My app starts up a database, drops a few views and then recreates them.
> When another one of my Java classes moves on to do a small SELECT (that
> should yield a single result). The exception "No current connection" is
> raised with the query obviously failing.
>
> I have checked the Derby.log but I am warned that the file is binary, when
> it opens in my editor, and a load of "junk" is displayed. I did use a little
> tool called "fd" which is a oct / hex character editor. This did make some
> sections of text legible but I couldn't see anything useful to explain my
> issue.
>
> Can anyone offer me any pointers?
>
> Many thanks,
>
> Rhys
>
>
>