Change connection details

In order to show or edit data, you must be connected to a relational database.

  1. Open the JDBC Connection information dialog.
    • From within DB Explorer view, click the Choose Connection Information icon.
    • With the meta-schema file (.4db, .4dbx) opened in the central work area, select Database > Edit Database Connection.
    • With the meta-schema file (.4db, .4dbx) opened in the central work area, click anywhere within the white space in the meta-schema diagram and select Edit Database Connection from the context menu.
    • With the meta-schema file (.4db, .4dbx) opened in the central work area, in the Database Structure view, right-click on the database node and select Edit Database Connection.
  2. On the JDBC Connection information page, complete the Database Connection Information and Database User Information sections.

    Use this table to help complete the database connection information fields.

    Table 1. 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

    If you have previously extracted a data schema, you can select the connection stream from Previous connections combobox, and it will complete the Database type, Database driver and Connection string fields for you.

    Depending on the database, you may have to provide database user information.
  3. Click Test Connection to verify your configuration.
  4. Click OK to close the dialog.