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  

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