Thanks,

Nadav hoze
Java programmer
dbMotion Ltd.
Direct: +972-8-6206802
Extension number: 6802
Mobile: 972-54-4821606
E-mail: [email protected]


  Please consider the environment before printing this e-mail

dbMotion is an innovative provider of medical informatics. The dbMotion™ 
Solution facilitates Interoperability and Health Information Exchange (HIE) for 
integrated healthcare delivery systems and health information networks. It 
integrates medical information from across the continuum of care, leveraging a 
Service Oriented Architecture (SOA).
Visit dbMotion at www.dbmotion.com.



-----Original Message-----
From: Nadav Hoze
Sent: Sunday, June 13, 2010 4:50 PM
To: [email protected]
Subject: RE: database in a an inconsistent stat, after a communications error 
has been detected: Connection reset by peer: socket write error

I think I found the problem.
I launch couple of jvms with the same code that insert new data to the DB.

I had the following exception:
DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create 
database 'CTS_SYNCH', see the next exception for details.::SQLSTATE: 
XBM0JDirectory C:\Program 
Files\eclipses\Galileo\eclipse\ws\ExecuteSynchronization\CTS_SYNCH already 
exists.

And I saw that the service.properties which is created inside the CTS_SYNCH 
folder was missing, can it suddenly be deleted ?

Thanks,

Nadav hoze
Java programmer
dbMotion Ltd.
Direct: +972-8-6206802
Extension number: 6802
Mobile: 972-54-4821606
E-mail: [email protected]


  Please consider the environment before printing this e-mail

dbMotion is an innovative provider of medical informatics. The dbMotion™ 
Solution facilitates Interoperability and Health Information Exchange (HIE) for 
integrated healthcare delivery systems and health information networks. It 
integrates medical information from across the continuum of care, leveraging a 
Service Oriented Architecture (SOA).
Visit dbMotion at www.dbmotion.com.



-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Sunday, June 13, 2010 1:46 PM
To: [email protected]
Subject: Re: database in a an inconsistent stat, after a communications error 
has been detected: Connection reset by peer: socket write error

On 06/13/10 11:35 AM, Nadav Hoze wrote:
>
> Hi,
>
> We have a service in our company that works with derby embedded db in
> a server mode.
>
> I have an ongoing task which uses the db, and in one of the times I
> got the following exception:
>
> :52:44.961 WARN - JDBCExceptionReporter.java:77 (logExceptions) - SQL
> Error: 40000, SQLState: 08006
>
> 07:52:44.961 ERROR - JDBCExceptionReporter.java:78 (logExceptions) - A
> communications error has been detected: Connection reset by peer:
> socket write error.
>
> When I tried to reconnect to the server again I got the followings:
>
> “SQL State XJ041 Error Code 40000” Which mean by the derby manual:
>
> XJ041 - Failed to create database '/<databaseName>/', see the next
> exception for
>
> details.
>

When this error is raised, there should be more information in derby.log
on the server. The "next exception" mentioned in the error message will
hopefully explain what went wrong, and it should be available in derby.log.

--
Knut Anders


This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
Please note that any disclosure, copying or distribution of the content of this 
information is strictly forbidden. If you have received this email message in 
error please notify its sender and then delete it from your files.

Reply via email to