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

jdbc adapter connection error

  • 1.  jdbc adapter connection error

    Posted Tue March 08, 2016 11:49 PM

    I’m working with Integration server 7.1 and Oracle 11g.

    My jdbc pools are working fine.

    But when coming to the JDBC adapter, I copied “ojdbc6” jar file under the jdbc adapter/code/jars directory and restarted the Integration Server.

    But I’m throwing with this … you could find the name of the data source class in the error… I’ve given the valid username and password. In the "database " field I entered my sid name ie “orcl”. Please go through the attachment once.

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource kalyan:kaljdbcConn.
    [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”.
    Invalid Oracle URL specified: OracleDataSource.makeURL

    Kindly get to me with help

    thanks

    clay water


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 2.  RE: jdbc adapter connection error

    Posted Wed March 09, 2016 12:23 AM

    Oh…

    I got it connected... I gave the "driverType=thin" and got connected.   I forgot to do that earlier...
    

    thanks,

    cw


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods