Skip to Content
avatar image
Former Member

JDBC Adaper "socket closed"

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • May 15, 2006 at 08:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 15, 2006 at 08:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded