JDBC Database Configuration Properties

Database	MySQL	Oracle 8i / 9i	MSSQL	MSSQL
Driver	MySQL	Oracle 8i / 9i	iSprinta	jTDS
Filename	mysql-connector.jar	classes12.jar and nls_charset12.jar	Sprinta2000.jar	jtds.jar
Database Connect String	See below	See below	See below	See below
Java Class	com.mysql.jdbc.Driver	oracle.jdbc.driver.OracleDriver	com.inet.tds.TdsDriver	net.sourceforge.jtds.jdbc.Driver
JDBC URL	jdbc:mysql://	jdbc:oracle:thin:	jdbc:inetdae7:	jdbc:jtds:sqlserver://
Uses Username & Password Properties	NO, in connect string	Yes	NO, in connect string	NO, in connect string
Database Query Mode	1 (intermediate)	8i: 0 (Entry level) 9i 1 (intermediate)	1 (intermediate)	1 (intermediate)
Use Distinct Keyword	1 (yes)	1 (yes)	1 (yes)	1 (yes)
Left Escape Delimiter	*		[	[
Right Escape Delimiter			]	]
Character Wildcard	_	_	_	_
String Wildcard	%	%	%	%
Global Escape Delimiter	*
Unicode Field Prefix			N	N
NOTE: the " " is translated to "\" when the property file is read

Example with the Sprinta Driver:
DatabaseConnect = dalton.org:1433?database=DaltonColl&sql7=true&user=YourDBusername&password=YourDBpassword
Where:

Hostname	dalton.org/	use your hostname
Port	:1433	default, only change if needed
Database name	database=DaltonColl	use your database name
SQL version	sql7=true	default, should not change
DB Username	user=YourDBuser	use your DB Username
SQL version	password=YourDBPassword	use your DB Password

Example with the jTDS Driver:
DatabaseConnect = dalton.org:1433/ DaltonColl;user=YourDBusername;password=YourDBpassword
Where:

Hostname	dalton.org/	use your hostname
Port	:1433	default, only change if needed
Database name	DaltonColl	use your database name
DB Username	user=YourDBuser	use your DB Username
DB Password	password=YourDBPassword	use your DB Password

Oracle Example:
DatabaseConnect = @dalton.org:1521:YourSID
Where:

Hostname	@dalton.org/	use your hostname
Port	:1521	default, only change if needed
SID	YourSID	use your SID

MySQL Example:
DatabaseConnect = mysql.dalton.org:3306/YourDB?user=insight&password=insight&useUnicode=true&characterEncoding=utf8
Where:

Hostname	mysql.dalton.org/	use your hostname
Port	:3306	default, only change if needed
DatabaseName	YourDB	use your database name
DB Username	user=YourDBuser	use your DB Username
DB Password	password=YourDBPassword	use your DB Password