java.sql.SQLException: No more data to read from socket

[frank_schmitt3]

Hallo,

when calling the jdbc-Adapter sometimes (after weekend; when a long time no calling happended) the following execption occured:

java.sql.SQLException: No more data to read from socket

What´s the problem?

Thanks in advance,

Frank

XI-Message:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Aufruf eines Adapters

-->

<SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

....

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'xxx' (structure 'xxx'): java.sql.SQLException: No more data to read from socket</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

[Former Member]

Please check the thread

http://scn.sap.com/thread/478846

[Former Member]

Please check the thread

http://scn.sap.com/thread/478846

[Former Member]

Frank,

This error most likely occurs when you use DB connection pool, which I think is the case in XI. When the JDBC adapter tries to connect to the database and discovers that the connection has been timed out/lost, then this exception is generated. Please have a look of the connection settings of your JDBC adapter and also at the note 831162.

Regards,

Roberto

[Former Member]

Can any one explain how to handle these exception.

as the note specified in this blog is not yet relaesed.

Shravan