Error for JDBC Connection with Oracle 10g Express Edition ??

Hello Gurus,

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)))

Questions -->

  1. Is 6.1 platform and JDBC - 6.0.3 compatible with the database I am tryting to use?
  2. What am I missing that is causing the error?

Any help is really appreciated!
Thanks!

  • NS

Have you chcked your listener or port is enabled ?

Thanks Talha Khan for the reply.

I checked it and found this –
command – netstat
result – TCP nirshah-056991:1521 nirshah-056991.ams.com:1053 ESTABLISHED

  1. The Host that I used in JDBC Configuration is – 127.0.0.1. Is that ok? Or should I use – nirshah-056991, as mentioned in result of “netstat”?
  2. why does it reflect back “1053”? Should not it display “1521”?

Any suggestion?
Thanks!

  • NS

Somebody… Please Help!!

  • NS

Nevermind, my mistake - the listener was listening on XE database and somehow in my configuration, I was using HR!

Thanks!

  • NS

Glad it worked out … Sorry I was out of office yesterday and couldn’t reply earlier…

No problem! Thanks, though, for your quick responses and help.