Skip to Content
avatar image
Former Member

JDBC Exception

Hi,

i'm receiving the following error on my idoc->XI->JDBC scenario.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.StagingPromotionHeaderImport' (structure 'InsertStagingPromotionHeaderImport'): com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(57) [XI2JDBC[:POSOB_PromoBonus_ReceiverSys:CC_POSOB_PromoBonus_JDBCOutput]_62, IO:95159, Dbc:953f9]. PktNum:0. TotalReceived:0. PktSize:4,096.

the first idoc sent was successful but the second try caused this error.

any ideas?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 26, 2007 at 05:41 AM

    Connection has been reset by the Target Database.

    1. In the receivr JDBC adapter, in advanced mode, select Disnconnection From Datrabase after Each Message Processing.

    2. Or,. just make some dummy changes and reactivate the JDBC adapter.

    regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • One reason can be that the Database allows only one connection at a time and also disconnects the connection automatically.

      I agree that this is not a long term solution when the load is high as connecting and disconnecting evry polling interval will have slight issues, the better option would be to sit with your DB team and try to look into the DB logs and find out why the DB is disconnecting the JDBC after a single message.

      Regards

      Bhavesh

  • Mar 26, 2007 at 05:41 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27, 2007 at 09:59 PM

    Thanks, disconnecting after each process solved the issue.

    Points awarded.

    I am curious yet however, is this the correct approach as the process will handle thousands of db calls later?

    Add comment
    10|10000 characters needed characters exceeded