Reading Time: < 1 minute

The following post details the instructions for connecting to the Always Free Oracle (Enterprise) Database using a JDBC Driver, a credentials wallet and JetBeans DataGrip Application. 


Oracle provides drivers that enable users to make JDBC connections to Oracle databases. The two most common methods of connecting to Oracle databases via JDBC are the Oracle Thin JDBC driver and the Oracle OCI JDBC driver. I never managed to get the OCI JDBC driver to work with the oracle wallet, but did get the thin client to work. 

Download the latest JDBC Thin driver

 
  • Oracle Database 19c (19.3) JDBC Driver & UCP Downloads 
  • You also need the additional jar: oraclepki.jar

Using a JDBC Connection with 19.3 JDBC Driver

 

Adapted from this guide:

 

  • Place your wallet in a directory of your choice. 
  • Place the JDBC driver in a director of your choice along with the oraclepki jar and add both files in the data sources and drivers settings screen. 

 

  • Create your database URL as

 

DB_URL=”jdbc:oracle:thin:@dbname_high?TNS_ADMIN=/Users/test/wallet_dbname”

 

In my case the DB_URL is:

 

“jdbc:oracle:thin:@student2_low?TNS_ADMIN=C:\\Wallet_student”

 

  • Go to datagrip and select add new source

 

  • Test your connection, it should work.