IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online 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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Got An Error while enabling JDBC Connection

    Posted 12/21/06 09:32 AM

    Hi All!

    i Have Created the JDBC Connection to my oracle 9i database given all parameters and otherproperties i set driverType=oci.connection is established.

    if i am trying to enable the connection given below Error

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource COLTOrderSubmission.common.adapter.connection:COLTOrderSubmissionConnection.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    envCharSetId

    Does anybody me regarding this issue…


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: Got An Error while enabling JDBC Connection

    Posted 12/21/06 05:48 PM

    Many reasons, starting with missing jars or, for OCI, DLL’s or *.so files. Others include wrong hostnames, wrong database names, etc.

    Are you providing a property to specify a character set? The “envCharSetId” would seem to indicate a problem with the char set.

    Mark


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Got An Error while enabling JDBC Connection

    Posted 12/22/06 06:24 AM

    Hi Mar!

    Thanx for reply i am not getting any other message like host name wrong,database wrong and also i am not providing “envCharSetId” in properties, i am using oracle 9i database when i am tring to enable the connection got an Error

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource COLTOrderSubmission.common.adapter.connection:COLTOrderSubmissionConnection.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    envCharSetId


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Got An Error while enabling JDBC Connection

    Posted 12/22/06 01:35 PM

    You need to check with your DBA to see whether a property is required related to character set.

    Have you googled “Oracle envCharSetId” yet or did you want someone to do that for you as well?


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: Got An Error while enabling JDBC Connection

    Posted 12/29/06 07:21 AM

    thanx for reply Mark Carlson ,got the solution…


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 6.  RE: Got An Error while enabling JDBC Connection

    Posted 12/29/06 08:25 AM

    Glad you got it solved. What did you determine was the root cause of the issue?


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards