Skip to Content

Error in JDBC Adapter.


I have a File to JDBC Scenario which is asynchronous. I have two segments in the Target structure, one segment with action: insert and other with execute.

Target Structure:



Table name

action Insert







abc_update_pm_invoice mapped to constant[]

action EXECUTE




Now I receive an error in message monitor:

MP: exception caught with cause Error processing request in sax parser: Error when executing statement for table/stored proc. 'abc_update_pm_invoice' (structure 'SP'): SQL Server did not return a response. The connection has been closed.

Any help?


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 14, 2016 at 05:23 AM

    Are you making a synchronous call to the Database and expecting a response?

    The error states - the Database failed to respond which implies, PI has pushed the request to the DB but the DB is not responding with the required data.

    To find out which of the 2 ( Insert vs SP ) is causing this issue, I would disable one of the segments in the mapping and test the same. This would tell you where the issue resides, Insert statement vs Stored Procedure and this would then help the DB admin also understand why the response is not returned.



    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2016 at 08:15 AM

    Hi Vijay,

    Talk with the DB guys if the communication with the DB should be done under SSL, there are a lot of threads in java forums linking that exception with SSL. You should a little test before, as Bhavhes said, for example only with the insert or doing an easier select, only to assure if the problem is in the connection, i think it could be here; or the problem coming in other side.


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2016 at 07:39 PM


    Your Query might be wrong..

    Run the query used in Stored procedure in the DB and check if its working fine.

    Add comment
    10|10000 characters needed characters exceeded