Unable to establish-Oracle Database Connection through ready api tool

[NK12]

Hello all,

I'm not able to establish the Oracle Data Base connection

Have copied proper(ojdbc14.jar file) in bin\ext folder

used the

driver name as oracle.jdbc.driver.OracleDriver

connection string as jdbc:oracle:thin:username/password//<serverName>

can you please tell us how to send the connection string

[Lucian]

Hey,

In your ReadyApi application look to your bottom left. You should have some logs there. Can you share them with us?

[NK12]

Hello Lucian,

I don't have any logs in my Error Log tab

But getting attached error message when we test the connection

Please check it out

Thanks!

[Lucian]

I think the connection string is wrong. Mine looks something like this:

jdbc:oracle:thin:username/password@db-server:8080:orcl

[jhanzeb1]

jdbc: oracle:thin:username/password@servername:1521: SID

Exactly same as yours, with an oracle port

[richie]

Hi,

The content of your error response (issue with the NIC) leads me to believe there is something essential missing.

Have you confirmed you can access the db using the same creds from a different tool? (I.e. using some db interrogation tool like sqldeveloper/toad/dbvisualiser?

Depending if you have oracle installed locally the apps will default to try and use the tnsnames.ora file (toad and sqldeveloper do this by default if memory serves), but dbvisualiser allows you to use the jdbc thin driver connection string you need. If you download and setup and test the connection in another tool will confirm the problem is a soapui problem or not.

Also. Have you confirmed the jdbc .jar file youre using is correct relative to the version of oracle db you are trying to connect to?

Have you ensured youre using the correct jdk version relative to the version of oracle you are trying to connect to?

The version of .jar file you use is peculiar to the version of java (jdk), which is peculiar to oracle db version you are trying to connect to.

Also the java environment variables (classpath, java_home, path)which indicates to the operating system where to look to run your runtime needs to be correct? If you have multiple instances of jdk/jre installed, you might be executing the wrong runtime. To check this,run a commandprompt and execute 'java -version' at the prompt.

So things to check

1. Can you connect to db from another tool (dbvisualiser) with your current jdbc connectiom details?

2. Oracle version's supported java version (jdk v1.8?)
3. Jdbc .jar file version matches the java version required by your oracle instance
4. Classpath, java_home, path environment variables need to point to the correct version of jdk

Above points are a fair start to check....option one will give us a good start...it will confirm if theres general connectiom problem rather than it being specific to soapui....error response looks like a general connection problem, although this could be a mistake

Cheers!

richie

[NK12]

Hello All,

1. Have copied ojdbc6 and 7 Jar files(Have taken these Jar files from my Oracle home-->Jdbc directory) in Ext and lib folder of Smart Bear

2.I'm using the connection string as

jdbc:oracle:thin:UserName/Password@ServerName:1521:Sid

3.When i click on Test Connection Button it is not showing any pop up message as Connection successfully tested

4.However it shows in logs as The JDBC driver [oracle.jdbc.driver.OracleDriver] is already registered.

@richie 

1.I'm able to connect my oracle db using my credentials through Toad Tool

2.My Java version is 1.8.0_172( I did research for this java version JDBC jar files-ojdbc6 and 7 are compatible

[richie]

Hi @NK12,

I have some thoughts but i'm driving at moment. Will respond in about an hour and a half.

Cheers

richie

[richie]

Quick question. What version of oracle are you trying to connect to? (Not your local oracle installation, but the remote database you are trying to connect to?)

[NK12]

@richie

It is Oracle 12