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.  Problem in creating JDBC Adapte with WebMethods 6.0.1

    Posted Thu February 12, 2004 07:00 AM

    Hi,
    While creating JDBC conenction with wemebtods6.0.1 I am geting following error.

    Can anybody help me on the same.

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

    DatabaseName Provided is : jdbc:oracle:thin:@137.72.248.220:1521:ora90


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


  • 2.  RE: Problem in creating JDBC Adapte with WebMethods 6.0.1

    Posted Thu February 12, 2004 08:39 AM

    Try using this URL:
    jdbc:oracle://137.72.248.220:1521;SID=ora90.
    Also verify your username and password. We ran into issues where we had a wrong password and got an invalid url error message back.


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


  • 3.  RE: Problem in creating JDBC Adapte with WebMethods 6.0.1

    Posted Thu February 12, 2004 10:46 AM

    hi,
    try using the following settings on the JDBC Adapter connection page:

    Transaction Type = LOCAL_TRANSACTION
    DataSource Class = oracle.jdbc.pool.OracleDataSource
    serverName = 137.72.248.220
    user
    password
    databaseName ora90
    portNumber 1521
    networkProtocol
    Other Properties driverType=thin

    every time you change a setting also the password has to be retyped.
    uli


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


  • 4.  RE: Problem in creating JDBC Adapte with WebMethods 6.0.1

    Posted Fri February 13, 2004 12:29 AM

    Thanx for the help.

    But problem still persists.


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


  • 5.  RE: Problem in creating JDBC Adapte with WebMethods 6.0.1

    Posted Thu March 25, 2004 09:52 AM

    try to put the fully qualified BOX name instead of the IPAddress or put IPaddress with fully qualified name,like I have a box named USNBKA035, if i use this it gives the same error you have, I used USNBKA035.us.ul.com, this works fine.


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