JDBC Connection information

To connect to a database, you must enter the appropriate JDBC database driver and connection string.

The JDBC Connection information dialog appears when you are creating or updating a meta-schema file, or when you are changing the connection for the DB Explorer plug-in.

Figure: JDBC Connection information dialog

Example of a JDBC Connection information dialog.

Figure 1 shows one example of a JDBC connection information form. Depending on where the form appears, the look-and-feel may differ.

Table 1. JDBC Connection information form objects
Form object Description
Current schema field Identifies the current schema, if any. When you select to edit the database connection for a meta-schema file, the name of the currently connected database displays. If no connection has been made, the field states that no schema is selected.
Note: In some contexts, this read-only field does not display.
Keep schema connection information synchronized checkbox When selected, the schema connection information will be permanently updated for the current meta-schema (.4db). This check box appears as selected and read-only when you edit the database connection for an existing meta-schema file. If you edit the connection from DB Explorer, you can uncheck this option to dissociate the DB Explorer connection information from the meta-schema connection information.
Note: In some contexts, this read-only field does not display.
Previous connections combobox If you have set connections previously, you can select those connections from this drop-down list. Selecting a connection populates the database type, database driver and connection string fields with the values of that connection.
Database type combobox Select the database type.
Database driver field Enter the database driver. See Table 2.
Connection string field Enter the connection string, which provides the details needed to find and connect to the database. See Table 2 for both the connection string syntax and example.
Database owner field Enter the name of the database owner.
Note: This field is not always required. Refer to your database vendor documentation.
User name field Enter the user name for the connection.
Note: This field is not always required. Refer to your database vendor documentation.
User password field Enter the user's password.
Note: This field is not always required. Refer to your database vendor documentation.
Test Connection button This button allows you to verify that the information entered is valid for connecting to the database.
Table 2. JDBC database connection information, by vendor
Vendor Java Driver Class (Database driver) JDBC connection string format Sample connection string
Oracle
oracle.jdbc.driver.OracleDriver
jdbc:oracle:driver_type:
[username/password]@database_specifier
jdbc:oracle:thin:@//localhost:1521/XE
IBM Informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://[{ip-address|host-name}:
{port-number|server-name}][/database-name]:
INFORMIXSERVER=server-name[{;user=user;
password=password]|
CSM=(SSO=database_server@realm,ENC=true)}
[;name=value[;name=value]...]
jdbc:informix-sqli://localhost:9088/native_types:INFORMIXSERVER=ol_informix1170
IBM DB2
com.ibm.db2.jcc.DB2Driver
jdbc:db2://server:port/database
jdbc:db2://localhost:50000/NAT_TYPE
Microsoft SQL Server
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://[serverName[\instanceName]
[:portNumber]][;property=value
[;property=value]]
jdbc:sqlserver://AUCKLAND\SQLEXPRESS2012;databaseName=native_types
Oracle MySQL
com.mysql.jdbc.Driver
jdbc:mysql://[host][,failoverhost...]
[:port]/[database] [?propertyName1]
[=propertyValue1][&propertyName2]
[=propertyValue2]...
jdbc:mysql://localhost:3306/native_types
PostgreSQL
org.postgresql.Driver
jdbc:postgresql://host:port/database
jdbc:postgresql://localhost:5433/native_types
SQLite
org.sqlite.JDBC
jdbc:sqlite:filepath
jdbc:sqlite:F:/tmp/DB/jdbc/tests/sqt_types.db