This document is meant to be a help in setting up a new MRALD installation.
It provides a list of common (and some uncommon) databases and the format
for their JDBC strings. The format of the list is:
Database
DBDRIVER string
DBSERVER string
Numbers given are port numbers and are the defaults as best I can tell.
Where shown, <database> is used to show the database name - the
JDBC term for this is "catalog". You may have to change them depending
on the installation. MRALD has not been tested on all these, but at
least we now have strings for them.
Postgres
org.postgresql.Driver
jdbc:postgresql://<host>:5432/<database>
MySql
com.mysql.jdbc.Driver
jdbc:mysql://<mysqlhost>/<database>
Oracle
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@<server>:1521:<sid> (for thin)
jdbc:oracle:oci8:@<database> (for OCI)
Informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://<host>:<port>:informixserver=<ifx_server>
DB2
COM.ibm.db2.jdbc.app.DB2Driver
jdbc:db2://<host>/<database>
Sybase
com.sybase.jdbc2.jdbc.SybDriver
jdbc:sybase:Tds:<host>:2638/<database> (database is optional?)
SQLServer
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://localhost:1433
An as alternative to the vendor drivers for SQLServer and Sybase, you can use the jTDS drvier from here.
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:<server_type>://<server>[:<port>] [/<database>]
(server type is 'sqlserver' or 'sybase' :: port default is 1433 for SQL Server and 7100 for Sybase :: database is optional)
net.sourceforge.jtds.jdbc.Driver
HypersonicSQL
org.hsqldb.jdbcDriver
jdbc:hsqldb:hsqls://<host>:9001/<database>
Mckoi
com.mckoi.JDBCDriver
jdbc:mckoi://<host>/<database>