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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

JDBC Adapter Connection problem

  • 1.  JDBC Adapter Connection problem

    Posted 05/23/08 07:28 AM

    Hi
    I am trying to enable the JDBC Adapter after having configured it.
    I even restarted the integration server but i am still getting error msgs…

    1)unable to configure connection manager

    2)Cannot connect to database with data source Oracle.jdbc.pool.OracleDataSource

    3)Listener refused the connection

    All these error msgs are being displayed in the error log.
    Pls let me know how can i solve this issue?


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


  • 2.  RE: JDBC Adapter Connection problem

    Posted 05/23/08 08:42 AM

    Check whether the listner for the database is up or not.
    Check also whether you are giving valid user name or password.


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


  • 3.  RE: JDBC Adapter Connection problem

    Posted 05/23/08 08:45 AM

    Also check if you have zip files (classe12.zip or ojdbc.jar) at the correct path.


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


  • 4.  RE: JDBC Adapter Connection problem

    Posted 05/23/08 08:55 AM

    Ok…how do i check the listener?
    i also checked the jar files they are copied at proper locations.


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


  • 5.  RE: JDBC Adapter Connection problem

    Posted 05/23/08 08:57 AM

    Ask the DB guy whether the listener for the particular database is up or not.


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


  • 6.  RE: JDBC Adapter Connection problem

    Posted 05/23/08 10:52 AM

    The problem got solved.
    Thanks for the help.


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


  • 7.  RE: JDBC Adapter Connection problem

    Posted 05/24/08 09:05 AM

    What was the problem’s Soluion?


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


  • 8.  RE: JDBC Adapter Connection problem

    Posted 05/27/08 11:59 AM

    The problem was with the Database ie Oracle.Some changes had been made to it which affected the JDBC Adapter configuration.


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


  • 9.  RE: JDBC Adapter Connection problem

    Posted 06/23/08 07:26 AM

    hai mallika
    i am also facing the same problem in jdbc adapter connection can u please let me know the process how to resolve those error

    if not can u send the screen shots to my mail id :

    sanjeev1028@gmail.com

    awaiting your reply…
    bye,
    Sanjeev:)


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


  • 10.  RE: JDBC Adapter Connection problem

    Posted 07/03/08 01:26 PM

    Mallika:

    How did you configure the JDBC adapter? I’m using IS 7.1 and trying to install the component. I’m not seeing any JDBC adapter under the adapters section of the admin UI. I want to use the BatchInsertSQL feature and looks like it needs the adapter to be configured.

    • Jayadev.

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


  • 11.  RE: JDBC Adapter Connection problem

    Posted 08/05/08 10:09 AM

    Hi
    I am trying to do jdbc adapter connection.
    i configured with oracle as the database.
    when i try to enable it there is the following error:
    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource nw:JDBCAdapterConnection.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.200] The JDBC DataSource class “oracle.jdbc.pool.OracleDataSource” cannot be located.oracle.jdbc.pool.OracleDataSourcecan nyone tell me wat could be the reason?
    thanks
    regards
    mallika


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


Related Content