Connection property editor
The Connection property editor dialog is used to set the necessary properties to connect to a database server.
To display this dialog, select the connection property in the Component Inspector when a Database component is highlighted in the Component Tree. The property values contained in this dialog are stored in the ConnectionDescriptor object.
Connection URL
Specify the Universal Resource Locator for the database connection. The format consists of the URL type ("JDBC" for JDBC database access), followed by driver-specific information, separated by colons. The driver-specific information is driver/server dependent. Refer to the documentation for your driver for more information on this property. It typically includes the driver name followed by the data source name.
For example, to access a Local InterBase Server sample file that has been configured with a data source name of DataSet Tutorial, the URL is: jdbc:odbc:DataSet Tutorial
Choose URL
Click this button to display the Choose a Connection URL dialog box. This dialog displays a history list of URLs that you have most recently connected to. Also available from the Choose a Connection URL dialog is a Show Data Sources button that displays all ODBC Drivers that have been registered in your computer's system registry.
Username
Enter the user name authorized to access the server database.
Password
Enter the password of the specified Username for access to the server database. An asterisk (*) appears for each character that you type in this field.
Prompt User For Password
Select this if you want a prompt to appear each time the connection to the database is attempted.
Driver Class
Specify the driver class to use when connecting to the database. This property is optional if you have already registered the driver class with JDBC. If you haven't, specify it here so that JBuilder registers the driver class with JDBC and loads it in memory before attempting the database connection.
Test Connection
Click this button to test whether the database connection can be opened with the properties specified in this dialog box. The results are displayed in the Message text box (described below).