Webmethods 601 JDBC Adapter

, ,
1

Hi , When i am trying to connect to an Oracle7.x Database using JDBC 6.0.1 adapter, i am getting the following error.

[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”.
[wm-cjdbc30][Oracle JDBC Driver]Unable to connect. Invalid URL.

But I am able to connect successfully to an Oracle8i Database using JDBC adapter6.0.1.Will JDBC6.0.1 support only for 8i and above?If this is the case what is the alternate for connecting to Oracle7.x using JDBC6.01 adapter.

Any help is appreciated.

2

Hi!

Try with the Datasource Class: oracle.jdbc.pool.OracleConnectionPoolDataSource.

I don’t have an Oracle 7 database to test this, but you can give it a try

3

fyi. i am using oralce 9.2 and i tried both of the ds class names before but none of them work. same error.

i have no problem using the db package with the oracle 9i and its driver.

i thought it was the jdbc adapter problem, however, it works with ms sql 2k.

4

ok i got it. try adding these two

networkProtocol :TCP
Other Properties :driverType=thin