6.2 Sample Configuration

6.2.1 DB2

URL: jdbc:db2://<DBServer>:6789/sample

JdbcDriver: COM.ibm.db2.jdbc.net.DB2Driver

Username: <username>

Password: <password>

PropertiesFilename: jdbc_db2.cfg

MaxConnections: 200

6.2.2 Oracle

URL: jdbc:oracle:thin:@<machine Ip>:1521:<sid>

JdbcDriver: oracle.jdbc.driver.OracleDriver

Username: <username>

Password : <password>

PropertiesFilename: jdbc_oracle.cfg

MaxConnections: 200

6.2.3 MSSQL

URL: jdbc:microsoft:sqlserver://<machineName>:1433;SelectMethod=Cursor;databaseName=<database_name>

If the server driver in use is the Microsoft SQL 2005 or later, the URL is

URL: jdbc:sqlserver://<machineName>:1433;SelectMethod=Cursor;databaseName=<database_name>

JdbcDriver: com.microsoft.jdbc.sqlserver.SQLServerDriver

If the server driver in use is the Microsoft SQL 2005 or later, the JdbcDriver is:

JdbcDriver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Username: <username>

Password: <password>

PropertiesFilename: jdbc_mssqls.cfg

MaxConnections: 200

Icon

If the Microsoft SQL 2005 or later server driver is used, the DB_TABLE_NOT_FOUND should be changed from jdbc_mssqls.cfg to S0002. Otherwise, the default value 42S02 will be used.

6.2.4 MySQL

URL: jdbc:mysql://localhost/mysql

JdbcDriver: com.mysql.jdbc.Driver

Username: <username>

Password: <password>

PropertiesFilename: jdbc_mysqls.cfg

MaxConnections: 200

6.2.5 Cloudscape

URL: jdbc:cloudscape:mydb;create=true

JdbcDriver : COM.cloudscape.core.JDBCDriver

Username: <username>

Password: <password>

PropertiesFilename: jdbc_cloudscape.cfg

MaxConnections: 200