Driver management

A JDBC driver allows the administrator user to access different types of databases. As soon as a database driver is added, the admin user can configure the database connection using the world objects. You can add the new driver from Data management.

In the Description tab, provide values for the following fields regarding details about the driver:

Field Description
Name Unique identifier for the driver
Description A label for the driver. This label is displayed across the GUI. The description can be internationalized (translated into the language defined for each user) using the Internationalization tab

Default URL

The driver URL used to connect on the database. The URL is different depending on the database type like: Oracle, MySQL, and so on.
Class name The driver class
Catalog separator The separator used for the tables, views and internal database management.
Identifier quote string The identifier used for the string interpretation.
Join Style

The style of join affects the SQL query generated based on the specified data structure:

  • ANSI: table1 T1 [inner|left|right|full] join (table T2 on T1.field1=T2.field1)
  • Basic: table1 T1, table T2 WHERE T1.field1=T2.field1
  • Oracle: table1 T1, table T2 WHERE T1.field1(+)=T2.field1

In addition, you can specify database options, including the following:

  • Supports catalog
  • Supports schema
  • Supports INNER JOIN
  • Supports LEFT JOIN
  • Supports RIGHT JOIN
  • Supports FULL JOIN

You use the Functions tab to define the mapping between functions and their proper implementations.

Refer to the database management system's documentation for information relating to the implementation of each function.

To use the database driver, you must save it to the lib folder for your web server.

Related Links