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,
The New URL dialog displays.
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.
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.
The drivers can connect to
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 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.jdbcExplorer.tnsnames=<fully qualified filename of tnsnames.ora>
for example,
jbuilder.jdbcExplorer.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