JDBC Adapter connection problem

Hi,

I’m installing JDBC Adapter on wM6.0 and have problem on connection creation. The parameters I gave as below:

Transaction Type :LOCAL_TRANSACTION
DataSource Class:oracle.jdbc.pool.OracleConnectionPoolDataSource
serverName:localhost
user:isv6
password:****
databaseName:localora
portNumber:1521
networkProtocal:(empty)
other Properites: driverType=thin

And I got the error msg. below:

[ART.118.5011] Adapter Runtime (Connection):Unable to create new connection exercise3.adapter:jdAdapterCon.
[ADA.001.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.
[wm-cjdbc30][Oracle JDBC Driver]Unable to connect. Invalid URL.

Can anybody give some advice, please?Many thanks.

Zhan

Transaction Type :LOCAL_TRANSACTION
DataSource :oracle.jdbc.pool.OracleConnectionPoolDataSource
serverName:localhost
user:isv6
password:****
databaseName:localora
portNumber:1521
networkProtocal:tcp
other Properites: driverType=thin

MAKE SURE CLASSES12.ZIP FILE IS PLACED IN THE \LIB FOLDER

thank you for your help.Actually I have put the zip file there…

I can’t say the problem has been sorted out as it seems weird: it works fine this minute and next minute, after changing the connection name and try again, it fails. (you can have a try!)

Is it realtive to oracle DB connection? Does it do database connection this moment, and something like the connection hasn’t been release yet?

Regards.
Zhan

hi Zhan

i don’t think u can change the connection name.
u can only change connection properties or connection management properties.

Connection Properties

Transaction Type :LOCAL_TRANSACTION
DataSource Class :oracle.jdbc.pool.OracleDataSource
serverName :my-0197
user: test1
password ******
databaseName :oradatabase
portNumber :1521
networkProtocol :TCP
Other Properties :driverType=thin

Connection Management Properties

Enable Connection Pooling: true
Minimum Pool Size: 1
Maximum Pool Size: 10
Pool Increment Size: 1
Block Timeout (msec) :1000
Expire Timeout (msec) : 1000

i have tried by changing properties. It works for me.
good luck…

Thirumal

zhan

r u sure that datbasename is “localora”. The rest all looks OK. Why not try your database name with “orcl” or “ora” just to make sure. Also try at sqlplus to connect using “scott/tiger@localora”

Thahir

sorry, it is late reply.

The reason I change the connection name is to create another new one. I think one physical database can have multiple alias.

The local one is my first step to try. Now, it seems working fine both on local database and remote ones.

Anyway, thank your for your msg. very much!
Regards.
Zhan

sorry, it is late reply.

Now, I changed to use SID/ServiceName which I get from my tnsnames.ora file pointing to my local databsae.

The local one is my first step to try. Now, it seems working fine both on local database and remote ones.

Anyway, thank your for your msg. very much!
Regards.
Zhan

How did you make it work, Zhan? what did you change?