JDBC connection to Oracle 12c howto ?

Follow

Paavo Muranen

• January 23, 2017 09:24

How to make proper jdbc connection to Oracle 12c.

In the same machine Oracle's SqlDeveloper is able to connect the database but can't get Datastorm connect to work.

And when trying to connect:

What am I missing?

rgrds Paavo

 

0

• 

  Catharine Coleman

  • January 25, 2017 16:41

  Hi Paavo,

  Is TSPING installed on the machine?  If so, and if you haven't checked already, can you verify that you can reach the database with :

  tnsping <tnsentry>

  Thanks,

   

  Catharine

   

   

   

   

  0

  Comment actions Permalink
• 

  Paul Rasmussen

  • January 25, 2017 19:59

  Hi Paavo,

  Please try the following and let us know if it works:   

  1. Download the latest Oracle 12c JDBC driver (ojdbc7.jar).
  2. Place the JAR file in "C:\Users\<YourUsername>\AppData\Local\Dataverse\site\lib\java\ext".
  3. Retry

  Paul

  0

  Comment actions Permalink

Please sign in to leave a comment.