I have installed “Oracle 10g Express Edition” on my system and am trying to configure with JDBC Adapter 6.0.3 but getting error message.
Configuration is as below -->
webMethods = 6.1
JDBC Adapter = 6.0.3
JVM = Sun 1.4.2
Database = Oracle 10g Express Edition
– I have downloaded the compatible driver = ojdbc14.jar
– and copied it into IS/lib
– also have updated the classpath envt. varialbe to include this new jar file.
Adapter Connection Parameters -->
Connection Type = JDBC Adapter Connection
Package Name = Experiments
Transaction Type = LOCAL_TRANSACTION
DataSource Class = oracle.jdbc.pool.OracleDataSource
serverName = 127.0.0.1 (because “oracle 10g express edition” is running on the same system)
user = hr
password = hr
databaseName = HR
portNumber = 1521
Other Properties = “driverType=thin”
Enable Connection Pooling = true
Minimum Pool size = 1
Maximum pool size = 10
pool increment size = 1
block timeout = 60,000
expire timeout = 60,000
startup retry count = 1
startup backoff timeout = 10
Still getting following error.
ERROR MESSAGE -->
2006-07-10 17:50:41 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS= (PROTOCOL=tcp)(PORT=1521) (HOST=127.0.0.1))(CONNECT_DATA=(SID=HR)))
- Is 6.1 platform and JDBC - 6.0.3 compatible with the database I am tryting to use?
- What am I missing that is causing the error?
Any help is really appreciated!