Unable to connect to Oracle 10g DB

, ,
1

Hi All,

I am trying to connection(wM 7.1) to DB (Oracle 10g)

I am getting this error message
Adapters > JDBC Adapter > Connections
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Jdbc.Conn:TestDB.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection Jdbc.Conn:TestDB: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL

Below are the Connection details:

Connection Type JDBC Adapter Connection
Package Name Jdbc
Connection Properties
Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName 127.0.0.1
user wM
password ******
databaseName XE
portNumber 1521
networkProtocol tcp
Other Properties driveType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 0
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

About the jar file I have copied the jar file from the oracle Jdbc folder and I can see it in wM IS about page

C:\webMethods7\IntegrationServer\lib\jars\ojdbc14.jar

About java version

Java Version 1.5.0_12 (49.0)

Please help me

Thanks

2

hi, are you able to connect to the database with the same credentials from SQL Developer or any other tool?
ojdbc14.jar should be fine. Looks no issues with wM but database, check if your database is available.

-regards
DC

3

“oracle.jdbc.pool.OracleDataSource”.
Invalid Oracle URL specified: OracleDataSource.makeURL"

Make sure you are providing correct DB details, check if there are any space in between

4

Hello,
As Shahid mentioned, please check the DB URL. If you are not sure, on the above right hand, there is Help written, click on that and all the connection details are written, copy that and use.

5

Hi All,

Thanks for the response, I checked as per ur suggestion but no luck… still have same issue please help !.

Thxs

6

Can you explain what you checked?

  1. is the database and TNS listener running?
  2. are you able to connect to the database from external client like sql developer?
  3. are you able to ping the oracle server from the webMethods box?
    4 are you able to connect to other oracle databases from webMethods?

-regards,
DC