B2B Integration

 View Only

  • 1.  Error while calling DB2 stored proc from ITX map (JDBC)

    Posted Wed April 05, 2023 09:35 AM
      |   view attached

    Hi,

    I am getting below while calling the proc using the IBM provided sample code (attached).
    Error code - 600 ; Error message - Could not open connection

    The same connectivity is working from DB Visualizer and there are no errors in jdbcm4 trace file. How to fix this error?



    ------------------------------
    Phanee Mullapudi
    ------------------------------


  • 2.  RE: Error while calling DB2 stored proc from ITX map (JDBC)

    Posted Fri April 07, 2023 02:35 PM

    Your PUT call is writing the JDBC adapter trace to m4jdbc.mtr.  That will be in the 'map directory', which will vary depending upon how you're calling the map.  If you're running in the Design Studio or an ITX engine, such as the Launcher, it will be in the same directory with the .mmc.

    Take a look at that.  You should get some more specific information.




    ------------------------------
    Rich McFate
    ------------------------------

    Original Message


  • 3.  RE: Error while calling DB2 stored proc from ITX map (JDBC)

    Posted Fri April 07, 2023 02:35 PM

    Your PUT call is writing the ITX JDBC adapter trace to m4jdbc.mtr.  Look there for more specific information.  That file will be in you 'map directory', which will vary depending upon how you're calling the map.  If your using the Design Studio, it will be in the same directory as the .mmc.




    ------------------------------
    Rich McFate
    Principal Architect
    CoEnterprise
    ------------------------------

    Original Message


  • 4.  RE: Error while calling DB2 stored proc from ITX map (JDBC)

    Posted Fri April 07, 2023 02:48 PM
      |   view attached

    I was working on DB2 SP a while back using the JDBC adapter.  It uses both input/output cards and GET function.  I am attaching the project here, see if it's helpful?



    ------------------------------
    Rex Chan
    ------------------------------

    Attachment(s)

    zip
    DB2_SP.zip   40 KB 1 version
    Original Message