|
Lexicon Database Configuration |
proiv dashboard |
 |
The Lexicon database can be hosted by a variety of vendor databases. The default PROIV settings point to an Apache Derby instance but this can be changed to other databases that provide a JDBC driver. The driver will need to be installed from the database provider.
Below are details of possible settings for the JDBC Driver and Database Connection Strings for supported databases. The connection details consist of:
|
Host |
The address of the server to connect to. This can be a DNS or IP address, or can be localhost (127.0.0.1). |
|
Port |
The port number on the server. |
|
Instance |
A specific database instance if more than one resides on the server. |
|
DBName |
The lexicon database name. |
All start with a vendor specific JDBC tag. [] indicates optional elements.
DERBY
|
Driver: org.apache.derby.jdbc.ClientDriver Connection String Format: jdbc:derby://Host[:Port]/DBName Connection String Example: jdbc:derby://localhost:9820/lexidb |
SQLSERVER
|
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver Connection String Format: jdbc:sqlserver://Host[:Port][;instanceName=value][;property=value[;property=value]] Connection String Example: jdbc:sqlserver://localhost;instanceName=lexServer;databaseName=lexidb |
ORACLE
|
Driver: oracle.jdbc.OracleDriver Connection String Format: jdbc:oracle:thin:@Host:Port:DBName Connection String Example: jdbc:oracle:thin:@localhost:1521:lexidb |
See docs.oracle.com
POSTGRESQL
|
Driver: org.postgresql.Driver Connection String Format: jdbc:postgresql://Host:Port/DBName Connection String Example: jdbc:postgresql://localhost:5432/lexidb |
Topic ID: 860002