Lexicon Database Configuration

Click here to see this page in full context

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

See db.apache.org/derby/docs

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

See docs.microsoft.com

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

See jdbc.postgresql.org

Comment on this topic

Topic ID: 860002