Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

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.

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

Hi,

which Service Packs/Feature Packs are you running?

IS 6.1 is currently at SP1
JDBC 6.0.3 is currently at FP1, which will provide you some feature like changing connections for AdapterServices etc.

Can you provide us your connection configuration screen?

Under “Other Properties” specify “driverType=thin”.

Check your DB-configuration for SID and ServiceName. Maybe you picked up the wrong one for you connection.

Regards,
Holger

Holger,

Thanks for your reply. Here are the connection parameters that I am using.

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

Any correction?
Thanks!

By the way, in following file –
C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora

this is the entry that I have made –
hr =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hr)
)
)

Please Help!!

  • NS

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

Thanks!

  • NS

Hi N.Shah, I can understand your frustration, it takes a lot to get something right the first time, that includes training and even proper requirement analysis.

It would be better, if you could club the issue from multiple post into one single post to avoid several emails.