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.  DataBase connection Error

    Posted Tue June 23, 2015 03:54 PM

    Hi all ,
    when i m trying to enable JDBC connection getting following error , please find the following errors

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource JdbcConnection:JDBCcon.
    [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

    ==============
    version -webMethods- 8.0
    Oracle = 11g version

    please find my attached screen shot of my configuration
    New Microsoft Office Word Document.docx (128 KB)


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


  • 2.  RE: DataBase connection Error

    Posted Tue June 23, 2015 04:03 PM

    Vamsee,

    I noticed in the Other Properties text driver Type (make sure you have no space there) set it as “driverType=thin”
    and enable it.

    Also is the localhost accessible to the IS?

    HTH,
    RMG


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


  • 3.  RE: DataBase connection Error

    Posted Wed June 24, 2015 12:57 AM

    Hi thanks for your quick reply even i tried tht now am getting new error

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource JdbcConnection:JDBCcon.
    [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”.
    Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    The Connection descriptor used by the client was:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=localhost))(CONNECT_DATA=(SID=XE)))

    Kind Regards
    krish


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


  • 4.  RE: DataBase connection Error

    Posted Wed June 24, 2015 03:56 AM

    Try with ORCL or orcl instead of XE.

    And reach me on my email ASAP.


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


  • 5.  RE: DataBase connection Error

    Posted Tue September 08, 2015 08:43 AM

    hi, may be its too late, but you have an error in the driverType there is a white space (driver Type)
    and the XE is for Oracle Database Express Edition.

    HTH


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