[EMAIL PROTECTED] wrote: >Hi, > I have apache derby 10.0 running on a MontaVista Linux system (3.1 >Professional with Linux/i686 2.4.20) in embedded mode. >The java level is Sun's jre 1.4.2_04. >There are around 500,000 records in a table in the DB. >I have one thread inserting rows into this table at a rate of around 50 >msecs. >Another thread is periodically doing selects on this table and some >deletes. >After running for about 10 hours the thread that is inserting rows catches >a SQLException with the follwing details: > >SQLError is 40000 > SQLState is 08003 > SQL Error Message is 'No current connection' > >No other thread in the VM has issed a shutdown request to derby. > >What conditions could cause the DB to close connections to it ? Has anyone >else seen this error before ? >The error does not occur consistently. > >Thanks in advance. >Sunil. > > > > > > > No clear cut answers except to say it doesn't sound like you should lose your connection in the scenario you describe. Sounds like something went wrong before you lost your connection, so I am not sure how helpful it would be to look at the trace at the time you got the "no Current Connection" error.
Here are a few hints for debugging the problem. Check the derby.log and see if you see a trace. Check the connection on the thread doing the select to determine if it is a problem specific to this connection or to the entire derby system. If that is not revealing make a file called derby.properties in derby.system.home (or the directory where java starts if derby.system.home is not set) and put the following lines in it., rerun and look at the derby.log again. derby.stream.error.logSeverityLevel=0 derby.language.logStatementText=true This might generate a lot of output in your scenario, but is usually helpful in debugging something like this since the problem shows up right at the end of the derby.log if the program exits after the failure. Kathey
