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.
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.
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.
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 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 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).
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.
jdbc:oci8:@Beq-local.world
When the Oracle driver is selected in the Driver box, the Browse button next to the URL box will be enabled to help you construct an URL, as well as to build "thin" URLs. If JBuilder is able to find the Oracle file tnsnames.ora, you can browse to and select Oracle data sources. If JBuilder is unable to locate the tnsnames.ora file, then no Oracle databases will be available to browse. If you know the location of the tnsnames.ora file and JBuilder is unable to find it, you can explicitly specify the location of the file by adding the following line to the jbuilder.properties file:
jbuilder.datapilot.tnsnames=<fully qualified filename of tnsnames.ora>
for example,
jbuilder.datapilot.tnsnames=//usr/orant//net80//admin//tnsnames.ora
Note: JBuilder must be closed when you make changes to jbuilder.properties, and the changes must be saved before JBuilder is loaded.
jdbc:oracle:thin@myoracleserver:1526:ORCL
The Browse button can help you construct the URL.
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
Some other possible drivers that can be used to connect to your local or remote database are:
An example of a DB2 URL is:
jdbc:db2://hostname:50002/database
An example of a Sybase URL is:
jdbc:sybase:Tds:hostname:2025
An example of an Informix URL is:
jdbc:informix-sql:://hostname:1526/dbname:INFORMIXSERVER=informixservername;user=username;password=password
An example of an MS-SQLServer URL is:
jdbc:weblogic:mssqlserver4:hostname:1433