Data Source Settings

Important: Copy required .jar files to the appropriate /lib directory. Replace {machineName} and {myPassword} with appropriate values.

MS SQL

- requires sqljdbc.jar

- http://msdn2.microsoft.com/en-us/data/aa937724.aspx

- ensure that TCP/IP is enabled as an access protocol

Data Source Name = SnappMX

JDBC URL = jdbc:sqlserver://localhost:1433;databaseName=SnappMX

Driver Class = com.microsoft.sqlserver.jdbc.SQLServerDriver

Type = javax.sql.DataSource

Server/Host = localhost

Port = 1433

UserName = sa

Password = {myPassword}

MySQL 

- requires mysql-connector-java-5.0.5-bin.jar

- http://dev.mysql.com/downloads/

Data Source Name = SnappMX

JDBC URL = jdbc:mysql://localhost:3306/SnappMX

Driver Class = com.mysql.jdbc.Driver

Type = javax.sql.DataSource

Server/Host = localhost

Port = 3306

UserName = root

Password = {myPassword}

SQLite

- sqlitejdbc-v037-nested.jar

- http://www.zentus.com/sqlitejdbc/

Data Source Name = SnappMX

JDBC URL = jdbc:mysql://localhost:3306/SnappMX

Driver Class = org.sqlite.JDBC

Type = javax.sql.DataSource

URL = jdbc:sqlite://C:/Program Files/SQLite/SnappMX.sdb

Firebird

- requires jaybird-full-2.1.1.jar

- http://www.firebirdsql.org/index.php?op=files&id=jaybird

Data Source Name = SnappMX

JDBC URL = jdbc:firebirdsql://localhost:3050/C:\Program Files

\Firebird\Firebird_2_0\SNAPPMX.fdb

Driver Class = org.firebirdsql.jdbc.FBDriver

Type = javax.sql.DataSource

Server/Host = localhost

Port = 3050

UserName = SYSDBA

Password = masterkey

 Oracle 

- requires ojdbc14.jar

- http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Data Source Name = SnappMX

JDBC URL = jdbc:oracle:thin:@{machineName}:1521:SnappMX

Driver Class = oracle.jdbc.OracleDriver

Type = javax.sql.DataSource

Server/Host = {Machine Name}

Port = 1521

UserName = system

Password = {myPassword}

DB2 

- requires db2jcc.jar and db2jcc_license_cu.jar

- http://www.ibm.com/developerworks/db2/downloads/jcc/

Data Source Name = SnappMX

JDBC URL = jdbc:db2://localhost:50000/snappmx

Driver Class = com.ibm.db2.jcc.DB2Driver

Type = javax.sql.DataSource

Server/Host = localhost

Port = 50000

UserName = db2admin

Password = {myPassword}

Sybase ASE 

- requires jconn3.jar

- http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect

Data Source Name = SnappMX

JDBC URL = jdbc:sybase:Tds:{machineName}:5000/SnappMX

?SQLINITSTRING=set quoted_identifier off

Driver Class = com.sybase.jdbc3.jdbc.SybDriver

Type = javax.sql.DataSource

Server/Host = localhost

Port = 5000

UserName = sa

Password = {myPassword}