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
  • 1.  Webmethods 601 JDBC Adapter

    Posted Mon April 21, 2003 04:29 PM

    Hi , When i am trying to connect to an Oracle7.x Database using JDBC 6.0.1 adapter, i am getting the following error.

    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
    [wm-cjdbc30][Oracle JDBC Driver]Unable to connect. Invalid URL.

    But I am able to connect successfully to an Oracle8i Database using JDBC adapter6.0.1.Will JDBC6.0.1 support only for 8i and above?If this is the case what is the alternate for connecting to Oracle7.x using JDBC6.01 adapter.

    Any help is appreciated.


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


  • 2.  RE: Webmethods 601 JDBC Adapter

    Posted Tue April 22, 2003 07:33 AM

    Hi!

    Try with the Datasource Class: oracle.jdbc.pool.OracleConnectionPoolDataSource.

    I don’t have an Oracle 7 database to test this, but you can give it a try


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


  • 3.  RE: Webmethods 601 JDBC Adapter

    Posted Tue April 22, 2003 02:09 PM

    fyi. i am using oralce 9.2 and i tried both of the ds class names before but none of them work. same error.

    i have no problem using the db package with the oracle 9i and its driver.

    i thought it was the jdbc adapter problem, however, it works with ms sql 2k.


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


  • 4.  RE: Webmethods 601 JDBC Adapter

    Posted Tue April 22, 2003 02:20 PM

    ok i got it. try adding these two

    networkProtocol :TCP
    Other Properties :driverType=thin


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