Database Templates for JDBC Connections

Use database templates when adding a JDBC connection or during deployment when adding database mapping from ODBC.

Table 1. DB2 template
Field Description
driverClass com.ibm.db2.jcc.DB2Driver

This field must not be changed.
user Enter your user name.
password Enter your password.
ant.project Use the default: default-data-sources
databaseURL jdbc:db2://hostname:port/database

Use this databaseURL template pattern to add your information.
databaseType Unknown

This template uses the driverClass and databaseURL.
Table 2. Informix template
Field Description
user Enter your user name.
password Enter your password.
serviceName Enter the service name.
ant.project Use the default: default-data-sources
portNumber Enter the port number.
databaseName Enter the name of the database.
serverName Enter the server name.
databaseType Informix

Do not change this field.
Table 3. Oracle template
Field Description
user Enter your user name.
password Enter your password.
serviceName Enter the service name.
ant.project Use the default: default-data-sources
portNumber Enter the port number.
databaseName Enter the name of the database.
serverName Enter the server name.
databaseType Oracle

Do not change this field.
Table 4. SQL Anywhere template
Field Description
user Enter your user name.
password Enter your password.
serviceName Enter the name of the service.
ant.project Use the default: default-data-sources
portNumber Enter the port number.
serverName Enter the name of the database.
databaseType SQL_Anywhere

Do not change this field.
odbcDataSource ODBC DSN
Note: The SQL Anywhere template uses the iAnywhere JDBC/ODBC driver.
Table 5. SQL Server template
Field Description
user Enter your user name.
password Enter your password.
ant.project Use the default: default-data-sources
portNumber Enter the port number.
databaseName Enter the name of the database.
serverName Enter the server name.
databaseType SQL_Server

Do not change this field.
Table 6. Sybase ASA template
Field Description
user Enter your user name.
password Enter your password.
serviceName Enter the name of the service.
ant.project Use the default: default-data-sources
portNumber Enter the port number.
serverName Enter the name of the database.
databaseType Sybase_ASA

Do not change this field.
Note: The Sybase ASA template uses the jConnect JDBC driver.
Table 7. Sybase ASE template
Field Description
user Enter your user name.
password Enter your password.
ant.project Use the default: default-data-sources
portNumber Enter the port number.
serverName Enter the server name.
databaseType Sybase_ASE

Do not change this field.
Related tasks
Adding a Database Connection
Adding an OLE Database Provider

Created September 17, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com