JDBC (DB Parameters)

[Former Member]

Hi Guys,

We are using XI to connect oracle DB (10.1.7.0)

• Required Drivers where installed on XI java stack using SDM.

• Configuration Parameters jdbc:oracle:thin:@10.xx.xx.xx5:1521:mestest (Username and Password where given)

Above configuration was fine and all scenarios where running in phase.

Well now we need to switch the connection to another DB with same schema.

So now we configured jdbc:oracle:thin:@10.xx.xx.xx6:1521:messap (Username an Password)

But doing so it throws an error.

Do we need to maintain TNS.ora

[Former Member]

Hi,

Can you send me the error message from RWB for your jdbc adapter

Regards,

Sreeni

[Former Member]

Hi

Kindly find the error !!

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@<IP for DB>:1521:<DB name>': SQLException: Io exception: The Network Adapter could not establish the connection

regards

srini

[Former Member]

Hi

DB is not identified at runtime. Check with the authorizations you have to connect.

Another thing is you need to have the DB entry in tnsnames.ora at server.

Thanks

Gaurav

[Former Member]

thx

wud check !!

srini

[Former Member]

Hi

thx to all

Srini

[dharamveer_gaur2]

Change your port number according to new Database

[Former Member]

Hi

Port number is same

as we tried to connect the DB using Toad from our system with same port worked fine

rgds

srini