JDBC Adaper "socket closed"

[Former Member]

Hello All,

We are trying to update a database table in Oracle through SAP XI.

Our scenario is IDOC to JDBC.

We are facing a problem during the JDBC connectivity between XI and Oracle.

<b>In adapter monitoring the error saying that Java.sql.SQLException: IO Exception: "socket closed".</b>

We are using XI 3.0 with Oracle 9.2 and at the other end the Database system(where the updation is to be done) is based on Oracle 8.1

The above process works when we try to update the database table (created on Oracle 8i) throgh JAVA Application.

<b>When this updation occurs throgh XI it fails!!</b>

Thanks in Adv.

Rajesh Yallabandi

[bhavesh_kantilal]

Hi,

just check if you are using OJDBC14.jar as the driver to connect to the database.

Also, check this note 889410 . it talks abt the same issue with respoect to the file adapter. Might give a few pointers on your problem.

Regards,

Bhavesh

[former_member187587]

Good day Yallabandi,

Can other SQL statment works?

<u>If not then:</u>

Please check that you supplied the JDBC adapter with the right and most updated matching JDB\CODBC driver for your destination database.

You also need to load the right jars to your Adapter framwork using the SDM tool.

Follow the "How To Install and configure JDBC" guide

supplied by SAP (get it on the service market place).

Good luck.

Nimrod Gisis

Message was edited by: Nimrod Gisis

[Former Member]

HI,

Please can you look at this thread.

Regards

Vijaya