New URL dialog box

This is a feature of JBuilder Professional and Enterprise.

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

Driver

Use the Driver drop-down list to select a driver or enter the driver information. For a discussion of the different types of drivers, see JDBC database drivers below.

URL

The URL field is used to browse to or enter the desired URL. The browse button (ellipsis) will be enabled when a database driver that is recognized by JBuilder is selected in the Driver field.



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. Drivers which are shown in red are not properly configured.

The drivers can connect to

JDataStore data sources

JDataStore is a high-performance, small-footprint, all Java, 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: