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.

 View Only
Expand all | Collapse all

unable to enable JDBC Adapter connection

  • 1.  unable to enable JDBC Adapter connection

    Posted Thu October 08, 2009 04:08 PM

    Hi!

    When trying to enable a new JDBC Adapter connection I get the following error:

    Error encountered [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource connections:virtuco_Billing.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    com.wm.adk.WmAdapter.createAdapterException(I[Ljava/lang/String;Ljava/lang/Throwable;Z)Lcom/wm/adk/error/AdapterException;

    The first two lines seem to be common with other error types.
    I could not find docs about “createAdapterException” nor about “AdapterException”.

    does any one knows about this error ?
    thx and regards

    A.L.

    NB: Here is the IS environment:

    Software Product webMethods Integration Server Version 6.5 Updates None Build Number 395 SSL Strong (128-bit) Server Environment Java Version 1.4.2_07 (48.0) Java Data Model 32-bit Java Vendor Sun Microsystems Inc. Java Home C:\Program Files\webMethods6\jvm\win142\jre Java Classpath C:\Program Files\webMethods6\jvm\win142\jre\lib\rt.jar
    C:\Program Files\webMethods6\jvm\win142\jre\lib\i18n.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\proxy.jar
    Server Classpath C:\Program Files\webMethods6\IntegrationServer\updates\IS_Build395Update.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\classes
    C:\Program Files\webMethods6\IntegrationServer\lib\server.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\client.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\mail.jar
    C:\Program Files\webMethods6\common\lib\wmbrokerclient.jar
    C:\Program Files\webMethods6\common\lib\wmjmsclient.jar
    C:\Program Files\webMethods6\common\lib\jms.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\entrust\enttoolkit.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\jars\resolver.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\jars\sl53_cj34.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\jars\xercesImpl.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\jars\xml-apis.jar
    C:\Program Files\webMethods6\IntegrationServer\lib\jars\xmlParserAPIs.jar
    C:\Program Files\webMethods6\IntegrationServer\packages\WmART\code\jars\static\wmartbundle.jar
    C:\Program Files\webMethods6\IntegrationServer\packages\WmFlatFile\code\jars\static\ffcore.jar
    C:\Program Files\webMethods6\IntegrationServer\packages\WmJDBCAdapter\code\jars\static\javaxsql.zip
    C:\Program Files\webMethods6\IntegrationServer\packages\WmJDBCAdapter\code\jars\static\ojdbc14.jar
    C:\Program Files\webMethods6\IntegrationServer\packages\WmWin32\code\classes
    OS Windows XP OS Platform x86 OS Version 5.1 Current User SYSTEM Working Dir C:\Program Files\webMethods6\IntegrationServer

    Here is the JDBC Adapter configuration:

    connections:virtuco_Billing Details Connection Type JDBC Adapter Connection Package Name Virtuco_Billing Connection Properties Transaction Type LOCAL_TRANSACTION DataSource Class oracle.jdbc.pool.OracleDataSource serverName localhost user VIRTUFAC password ****** databaseName VIRTUCO portNumber 1521 networkProtocol tcp Other Properties driverType=thin Connection Management Properties Enable Connection Pooling true Minimum Pool Size 1 Maximum Pool Size 10 Pool Increment Size 1 Block Timeout (msec) 1000 Expire Timeout (msec) 1000 Startup Retry Count 0 Startup Backoff Timeout (sec) 10


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: unable to enable JDBC Adapter connection

    Posted Fri October 09, 2009 09:54 AM

    Hi

    Place ojdbc14.jar in Integrationserver\lib\jars directory and restart your server.

    Regards,
    Pranith


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 3.  RE: unable to enable JDBC Adapter connection

    Posted Fri October 09, 2009 10:57 AM

    Hi !

    Actually placing ojdbc14.jar in Integrationserver\lib\jars directory is the same as placing it in the IntegrationServer\packages\WmJDBCAdapter\code\jars\static\ directory.

    I found the error; the name of my database was wrong.
    Thank you anyway.

    Regads.
    A.L.


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General