Hi,

I am facing a problem in creating a JDBC connection. I am connecting to a remote Oracle DB. When I am trying to create the JDBC Connection. It is giving the error as :

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource v1.jdbcAdapterConnection:JDBCConnection.[ART.118.5063] Adapter Runtime (Connection): Unable to start connection v1.jdbcAdapterConnection:JDBCConnection: after 1 attempt(s).[ADA.1.200] The JDBC DataSource class "oracle.jdbc.pool.OracleDataSource " cannot be located.oracle/jdbc/pool/OracleDataSource

There are so many other connections which are enabled(around 10 connections). What might be the problem.

Connection Details:
Connection Type:JDBC Adapter Connection
Package: v1
Transaction type: No_Transaction
Datasourceclass: oracle.jdbc.pool.OracleDataSource
network protocal: tcp
Other: driverType=thin
enable connection : true
minimum pool size:0
max :10
pool incre:1
block;1000
expire:1000
startup retry:0
startup backoff:5

Kindly help.
Thanks,
David.

"oracle.jdbc.pool.OracleDataSource "

Verify that there is not a trailing space in the datasource class field.

Hi Reamon,

I have solved the problem.I have searched the advantage webMethods and found the solution.Yes, You’re right.It’s because of the spaces.

Anyways, You are perfect in hitting the bulls eye.

Thanks,
David.