Configure JDBC Driver in SQL Developer


JDBC is the Java Database Connectivity standard and it provides a mechanism for Java programs to connect to databases.To access databases using JDBC, you must use a JDBC driver. Database vendors offer JDBC drivers as free downloads.

SQL Developer supports the following JDBC drivers.

  • IBM DB2: You need the binary driver jar files db2jcc.jar and db2jcc_license_cu.jar. Search for DB2 Universal JDBC Drivers or download it here.
  • Microsoft Access: No additional driver is required. Access uses the JDBC/ODBC bridge
  • Microsoft SQL Server and Sybase: jTDS driver version 1.2. Download here.
    The binary driver is located within the jtds-1.2-dist.zip. This jar file is called jtds-1.2.jar.
  • MySQL: MySQL JDBC Driver, version 5.04. Download here.
    The binary driver is located within the mysql-connector-java-5.0.4.tar.gz (or .zip). The jar file is called mysql-connector-java-5.0.4-bin.jar.
  • Teradata: Use Teradata JDBC Driver 12.0 or above. Both the Teradata JDBC Driver 12.0 and 13.0 use the jar files terajdbc4.jar and tdgssconfig.jar. Download here.

Once you have extracted the relevant jar file to your disk, you need to configure SQL Developer to tell it where this driver resides.


How to Install a JDBC Driver in Oracle SQL Developer

 

Using Check For Updates to configure JDBC Drivers

Oracle SQL Developer also supports the use of Check for Updates to install the drivers required for MySQL, Microsoft SQL Server and Sybase. To use Check for Updates, start SQL Developer and select Help -> Check for Updates.


Home

Need More Help? Explore these Resources. See this Quick Video on How to Migrate with SQL Developer Go

In-Memory Replay Banner