Adding a new database connection URL

This is a feature of JBuilder Professional and Enterprise.

To access the New URL dialog, select Tools|JDBC Explorer. Then select File|New, or right-click an existing URL and select New from the context menu. Use this dialog to add a new database connection URL.

To create a new URL from the JDBC Explorer,

  1. Select File|New, or right-click an existing URL and select New from the context menu.

    The New URL dialog displays.

    File|New dialog

  2. Select a Driver from the drop-down list or enter the driver information. For a discussion of the different types of drivers, see JDBC database drivers below.

  3. Browse to or enter the desired URL. The Browse button will be enabled when a database driver that is recognized by JBuilder is selected in the Driver field.

  4. Click OK to close the dialog.

  5. Select the expand glyph to open the database connection.

  6. Enter your user name and password.

    When using the InterBase sample files, the user name is SYSDBA and the password is masterkey.

    When using the sample JDataStore files, enter your user name, leave the password blank.

JDBC database drivers

The New URL dialog box contains a drop-down list of some of the possible drivers that can be used to connect to your local or remote database. Drivers must be installed to be used, and the driver's files must be added to the JBuilder startup script or batch file's CLASSPATH, or to your environment's CLASSPATH variable before JBuilder is launched. JDBC Explorer:list of drivers

The drivers can connect to

JDataStore data sources

JDataStore is a high-performance, small-footprint, 100% Pure JavaTM, multifaceted data storage solution. For more information, see the JDataStore Programmer's Guide.

The JDataStore driver is:

The URL for the sample JDataStore employee database might look like:

jdbc:borland:dslocal:/jbuilder/samples/JDataStore/datastores/employee.jds

To define an URL for a JDataStore on your local machine, use the Browse button, select Local JDataStore Database, and click Browse to locate a JDataStore (with an extension .jds).

The URL for a remote JDataStore driver might look like:

jdbc:borland:dsremote://hostname//jbuilder/samples/JDataStore/datastores/employee.jds

To define an URL for a JDataStore on a remote machine, use the Browse button, select Remote JDataStore Database, and enter the name of the host and the location (drive (if applicable), directory, and file name) of the JDataStore (with an extension .jds) on the host.

InterClient data sources

InterClient is an all-Java JDBC driver for InterBase that ships with certain versions of JBuilder. It is available for Solaris, HP-UX, Windows NT, Linux, and Windows 95/98. See "Setting up InterBase and InterClient" in Database Application Developer's Guide for more information.

The InterClient driver is:

The URL for an InterBase database might look like:

jdbc:interbase://localhost//usr/interbase/examples/employee.gdb

To define an URL for an InterBase database on your local machine, use the Browse button to locate an InterBase database (with an extension .gdb).

Oracle data sources

If Oracle drivers are installed, and the driver's files are listed in the ClassPath, you can select the following Oracle drivers:

There are two kinds of Oracle drivers: the OCI and the "thin" drivers.

ODBC data sources

ODBC drivers are:

To view available ODBC data sources, select the Browse button.

If you are using Windows NT, you can define new ODBC sources, or modify existing ones, using the 32-bit ODBC Admininstrator from the Windows Control Panel. An URL for an ODBC data source might look like:

jdbc:odbc:odbcDataSource

Other data sources

Some other possible drivers that can be used to connect to your local or remote database are: