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.


#TechXchangePresenter
 View Only
  • 1.  Unable to connect to Oracle database

    Posted Tue January 11, 2011 07:40 AM

    Hi,
    I am trying to connect to oracle database. I am getting following error in the JDBC adapter connection. I have tried with another datasource class still iam getting following error. I am using windows7 but with the same configuration on windows xp i am able to connect.

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource adapterconnections:oracleconnections.
    [ART.118.5063] Adapter Runtime (Connection): Unable to start connection adapterconnections:oracleconnections: after 1 attempt(s).
    [ADA.1.200] The JDBC DataSource class “oracle.jdbc.pool.OracleDataSource” cannot be located.
    oracle.jdbc.pool.OracleDataSource

    Connection Type JDBC Adapter Connection
    Package Name AdapterConnections
    Connection Properties
    Transaction Type LOCAL_TRANSACTION
    DataSource Class oracle.jdbc.pool.OracleDataSource
    serverName localhost
    user webMethods
    password ******
    databaseName XE
    portNumber 1521
    networkProtocol
    Other Properties drivertype=thin
    Connection Management Properties
    Enable Connection Pooling true
    Minimum Pool Size 0
    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

    Please help me

    Thanks In advance


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


  • 2.  RE: Unable to connect to Oracle database

    Posted Tue January 11, 2011 09:15 PM

    Du you have classes12.jar or ojdbc14.jar available in ur Lib file system of server running on windows 7?


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


  • 3.  RE: Unable to connect to Oracle database

    Posted Wed January 12, 2011 06:52 AM

    From error it looks that your driver classes are not loaded, take the class12.jar or ojdbc14.jar (client driver), put them in IS/lib/jars and restart the IS… if you still face the issue then your driver might be incorrect. Try to get the drivers jar from the DB server installation directory.


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


  • 4.  RE: Unable to connect to Oracle database

    Posted Wed January 12, 2011 07:19 PM

    I fixed the issue. i have got new classes12.jar and placed in Integration server/lib/jars. Now it is connected.

    Thank You very much


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