Databases – manage your various database connections here.

What The Category Does

The database tab manages all the connections to your repositories and application data. Each project should use a separate database layer.

 If you want to define a database connection to a separate application data layer for testing in the lexicon test widgets, then you would create them here.

There are currently only two database types: Oracle and MySql; however it is possible that any database with a JDBC drive might use the OpenLexicon wizard.

For each repository and application data source create a separate database connection.

The syntax of the Oracle JDBC driver is: 

 jdbc:oracle:thin:@<server>:<port>:<instance>

Where:

<Server> = the IP, or DNS Name or address of the database machine

<sockett> the socket of the SQL request layer (i.e. SQL*Net)

 <instance> The name of the database instance

 A real one might look like this :jdbc:oracle:thin:@fry.bka-inc.com:1521:socrates

The syntax of the Mysql JDBC Connection is  very similar

 jdbc:mysql://<server>:<port>/<instance>

(Note the differances in the delimiters)

 Where the parameters are defined as before.