App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#Applicationintegration
#App Connect
#AppConnect
 View Only
Back to discussions
Expand all | Collapse all

ACE: connect DB2 database via java compute node throwing Error, pls help..

  • 1.  ACE: connect DB2 database via java compute node throwing Error, pls help..

    Posted Wed May 17, 2023 02:42 PM

    Hi All,
    ACE: connect DB2 database via java compute node throwing Error,

    May 16 08:32:20 contact admin user:err|error ACE[10748162]: IBM App Connect Enterprise v12030 (ACEDEV20D12_IN.HIPAA_IS08) [Thread 14168] (Msg 1/1) BIP4362E: Ja
    va node error: Error committing Transaction for JDBC DataSourceName .
    May 16 08:32:20 contact admin user:err|error ACE[10748162]: IBM App Connect Enterprise v12030 (ACEDEV20D12_IN.HIPAA_IS08) [Thread 14168] (Msg 1/2) BIP2695E: Th
    read number '14168' with name 'com.contact admin.batchprocessing.Batch_Processing(BatchProcessing)' failed to commit a resource of type 'JDBC'. Other resources have
    been committed.
    May 16 08:32:20 contact admin user:err|error ACE[10748162]: IBM App Connect Enterprise v12030 (ACEDEV20D12_IN.HIPAA_IS08) [Thread 14168] (Msg 2/2) BIP6265E: A
    problem was encountered when committing a transaction with the JDBC Datasource 'contact admin'.

    Any help please?

    Thanks and regards
    Chris
    9901726688
    IBM India Pvt Ltd.



    ------------------------------
    CHRISTOPHER RAJESH KUMAR DAVID DURAIRAJ
    ------------------------------


  • 2.  RE: ACE: connect DB2 database via java compute node throwing Error, pls help..

    Posted Thu May 18, 2023 01:39 AM

    Hi Chistoper, 

    You should remove the close connection block on your code, may your issue be like this.  You can find more details on the below link.

    https://www.ibm.com/docs/en/integration-bus/9.0.0?topic=SSMKHH_9.0.0/com.ibm.etools.mft.doc/ac30494_.html



    ------------------------------
    Burak Görener
    ist
    +90262646 50 11
    ------------------------------

    Original Message


  • 3.  RE: ACE: connect DB2 database via java compute node throwing Error, pls help..

    Posted Thu May 18, 2023 07:44 AM

    Hi Burak ,
    I have commented conn.close(); statement in the finally block ,still same error happening .. 

    do you see any other issue to fix this error?

    Thanks in advance
    Chris
    9901726688



    ------------------------------
    CHRISTOPHER RAJESH KUMAR DAVID DURAIRAJ
    ------------------------------

    Original Message


  • 4.  RE: ACE: connect DB2 database via java compute node throwing Error, pls help..

    Posted Mon May 22, 2023 02:45 AM

    Hi Christopher, 

    You might had commit your connection manually. Please remove the commit lines on your code block and try again. 



    ------------------------------
    Burak Görener
    ist
    +90262646 50 11
    ------------------------------

    Original Message


Related Content