|
To add a new JDBC driver to Ignition, click the Create new JDBC Driver link from Databases > Drivers page. In order to install a new driver, you'll need the Java JAR file that contains it and any other required JARs, as well as the full name of the driver class. This name is provided in the manufacturer's documentation.
Main Properties
Classname
|
The full name of the JDBC driver. Should be provided in the manufacturer's documentation.
|
JAR files
|
The core JAR file containing the driver, as well as any others required by it.
|
Driver Defaults and Instructions
These properties will be used as defaults when creating new connections against this driver.
Driver Type
|
The brand of database. This is used for optimizations in the gateway, if in doubt, select GENERIC
|
URL Format
|
A template/example of the jdbc connection string to use. The driver documentation should have examples of this string.
|
URL Instructions
|
Free form instructions that will be shown to help the user create a connection.
|
Default Connection Properties
|
Any additional properties to add by default to the connection string.
|
Connection Property Instructions
|
Tips about which connection properties might be useful.
|
Default Validation Query
|
The default query that will be used to verify that the connection is available.
|
SQL Language Compatibility
Default Translator
|
The database translator that will be used by default for connections from this driver.
|
|