JDBC Adapter Connection problem

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?

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

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

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

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

The problem got solved.
Thanks for the help.

What was the problem’s Soluion?

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

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:)

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.

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