How to install a JDBC driver in JBuilder 5?

Add the driver to JBuilder

  1. Open JBuilder and choose “Tools | Enterprise Setup”. Click the Database Drivers tab which displays *.config files for all the currently known database drivers.
  2. Click Add to add a new driver, then New to create a new library file for the driver. The library file is used to add the driver to the required libraries list for projects.
    Note: You can also create a new library under “Tools | Configure Libraries”, but since you would then have to use Enterprise Setup to derive the *.config file, it is simpler to do it all here.
  3. Type a name and select a location for the new file in the Create New Library dialog box.
  4. Click Add, and browse to the location of the driver jar file Opta.jar. You can select the directory containing the driver and all it's support files, or you can select just the archive file for the driver. Either will work. JBuilder will extract the information it needs.
    jb1.jpg
  5. Click OK to close the file browser. This displays the new library at the bottom of the library list and selects it.
  6. Click OK. JBuilder creates a new .library file in the JBuilder /lib directory with the name you specified (for example, InterClient.library). It also returns you to the Database Drivers page which displays the name of the corresponding *.config file in the list which will be derived from the library file (for example, InterClient.config).
    jb2.jpg
  7. Select the new .config file in the database driver list and click OK. This places the *.config file in the JBuilder /lib/ext directory.
    jb3.jpg
  8. Close and restart JBuilder so the changes to the database drivers will take effect, and the new driver will be put on the JBuilder class path.

 

Using the Database Pilot

After you have add the driver to JBuilder you can use the Database Pilot. You need to add a new URL.

jb4.jpg 

Add the driver to the project

Projects run from within JBuilder use only the class path defined for that project. Therefore, to make sure the JDBC driver is available for all new projects that will need it, define the library and add it to your default list of required libraries. This is done from within JBuilder using the following steps:

  1. Start JBuilder and close any open projects.
  2. Choose “Project | Default Project Properties”.
  3. Select the Required Libraries tab on the Paths page, then click the Add button.
  4. Select the JDBC driver from the library list (for example i-net OPTA ) and click OK.
  5. Click OK to close the Default Project Properties dialog box.
 

© Copyright 1996 - 2024, i-net software; All Rights Reserved.