I have two Wm instances 6.5 (Linux, 1.4 JVM) and 7.2 (Windows, 1.5 JVM), I have setup JDBC connection in both of them using following parameters below, 6.5 JDBC connection is working fine but 7.2 JDBC is not working and shows “Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleConnectionPoolDataSource”.
invalid arguments in call" Error:
Transaction Type: LOCAL_TRANSACTION
DataSource Class: oracle.jdbc.pool.OracleDataSource
serverName: oracleprod
user: TGEG
password: ******
databaseName: TGEG
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
Startup Retry Count: 0
Startup Backoff Timeout (sec): 10
In both Wms, I have copied ojdbc14.jar files under lib\jars. The only difference is 6.5 connecting to Oracle XE and 7.2 needs to connect to Oracle 10g.
I have made sure that there are no trailing spaces in the connection setup values.
If i remove the value of “Other Properties” in 7.2, then following error is generated; “Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL”