Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Tasks : Common tasks for supported databases : Configuring a JDBC driver
 
Configuring a JDBC driver
DB Navigator requires a JDBC driver in order to connect to a database and supplies JDBC drivers for various database types. In most cases, the driver is installed and configured automatically during installation of DB Navigator. If the driver is not configured correctly, you must edit its configuration.
Among the supplied drivers is the JDBC ODBC Bridge. Although the bridge allows you to use predefined ODBC data sources, its use is typically not recommended, as it is a less efficient connection option.
To verify that the JDBC driver you need is configured correctly and is available for a database connection, choose Window > Preferences > Progress DB Navigator > JDBC Drivers. A list of drivers appears in the JDBC Drivers preferences page.
The JDBC drivers that are already successfully configured are tagged with a blue icon. If a driver is tagged with a red icon, however, the driver is not configured. You must configure the driver before it can be loaded to connect to a database.
To configure a JDBC driver from the JDBC Drivers Preferences page:
1. Select the driver, and click Edit. The Edit Driver dialog appears.
2. Verify the driver name in the Name field and the URL in the Example URL field. This URL entry forms the default URL when you create a new SQL connection. If the URL contains an IPv6 address, be sure to include an opening bracket before and a closing bracket after the address; for example, [thehostmachine]. (See the documentation for the driver for more information.)
3. Verify that any entries listed in the Extra Class Path tab point to a valid driver. Click Add to add a driver to the list, or click Delete to delete an existing driver from the list.
4. Verify the Driver Class Name for the selected driver. You can also select the driver and then click List Drivers to retrieve a list of available names. (If no driver class name appears automatically, you can type one in the Driver Class Name field.)
5. Click OK.
Note: The listed drivers have definitions that assume that the JDBC driver classes are in the current class path or are in your JRE extensions directory. (Consult the documentation for your Java implementation for more information.) If this is not the case, you must modify the driver definition to point to the jar file or the directory that contains these classes.
6. If you successfully configure the driver, a blue icon appears next to its name in the list of drivers. If the red icon still appears next to the driver's name, perform troubleshooting for the particular driver, as follows, to review the configuration:
*Troubleshooting the MS SQL Server database JDBC driver
*Troubleshooting the Progress OpenEdge database JDBC driver
*Troubleshooting the Oracle database JDBC driver