Data source parameters

The main two requirements for data source configuration are: (1) the driver must be JDBC type; (2) the data source must connect to the database used by the application. The settings discussed in this section focus on meeting these two requirements. Configure the other data source parameters that are not mentioned here based on your own knowledge about data source configuration or simply use the default settings.

Unless specified, the settings given in this chapter apply to the following application servers that Appeon supports: WebLogic, WebSphere, JBoss, JEUS, NetWeaver, and EAServer.

Note that the values of driver class name and Database URL are case sensitive.

Data source parameters for SAP ASA/SQL Anywhere

SAP ASA/SQL Anywhere databases support jConnect (recommended), iAnywhere JDBC-ODBC, and Sun JDBC-ODBC bridge. jConnect is preferable than iAnywhere JDBC-ODBC and Sun JDBC-ODBC bridge because it delivers much better performance at runtime. However, the Appeon Demo uses the Sun JDBC-ODBC bridge because this driver can be automatically configured by the Appeon installation program.

Note:

1) WebSphere server and JEUS server do not support JDBC-ODBC bridge driver, and supports only jConnect driver.

2) To use jConnect to connect with ASA/SQL Anywhere, you must start ASA/SQL Anywhere as service before configuration.

3) jConnect 6.0 is preferable to jConnect 5.5.

Table 26. Data source parameters for SAP ASA/SQL Anywhere

Driver

Parameter

Value

Note

jConnect JDBC driver (Recommended)

Driver class name

For JConnect 5.5: com.sybase.jdbc2.jdbc.SybDriver

For JConnect 6.0: com.sybase.jdbc3.jdbc.SybDriver

Hostname stands for the database server name or IP address.

Port stands for the database server port. The default ASA/SQL Anywhere port is 2638.

ServiceName stands for the name of the ASA/SQL Anywhere database service specified during configuration.

DSNname refers to the name of the ODBC DSN that is created for the database.

Database URL

jdbc:sybase:Tds:Hostname:Port/ServiceName

iAnywhere JDBC-ODBC driver

Driver class name

For JDBC 2.0: ianywhere.ml.jdbcodbc.IDriver

For JDBC 3.0: ianywhere.ml.jdbcodbc.jdbc3.IDriver

Database URL

jdbc:odbc:dsn=DSNname

Sun JDBC-ODBC driver

Driver class name

sun.jdbc.odbc.JdbcOdbcDriver

Database URL

jdbc:odbc:DSNname

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for ASE

ASE databases support jConnect JDBC driver only. ASE 15 supports JConnect 6.0 only.

Table 27. Data source parameters for ASE

Parameter

Value

Note

Driver class name

For JConnect 5.5: com.sybase.jdbc2.jdbc.SybDriver

For JConnect 6.0: com.sybase.jdbc3.jdbc.SybDriver

Hostname stands for the database server name or IP address.

Port stands for the database server port. The default ASE port is 2048.

DBName stands for the name of the database.

Database URL

jdbc:sybase:Tds:Hostname:Port/​DBName

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for SAP IQ

SAP IQ databases support JConnect JDBC driver or Sun JDBC-ODBC driver.

Table 28. Data source parameters for SAP IQ

Driver

Parameter

Value

Note

JConnect JDBC driver (Recomm​ended)

Driver class name

For JConnect 5.5: com.sybase.jdbc2.jdbc.SybDriver

For JConnect 6: com.sybase.jdbc3.jdbc.SybDriver

Hostname stands for the database server name or IP address.

Port stands for the database server port.

ServiceName stands for the name of the database service specified during configuration.

DSNname refers to the name of the ODBC DSN that is created for the database.

Database URL

jdbc:sybase:Tds:Hostname:Port/​ServiceName

Sun JDBC-ODBC driver

Driver class name

sun.jdbc.odbc.JdbcOdbcDriver

Database URL

jdbc:odbc:DSNname

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for SAP HANA

SAP HANA databases support SAP In-Memory Database JDBC driver.

Table 29. Data source parameters for SAP HANA

Driver

Parameter

Value

Note

SAP In-Memory Database JDBC driver

Driver class name

com.sap.db.jdbc.Driver

Hostname stands for the database server name or IP address.

Port stands for the database server port.

Database URL

jdbc:sap://Host:Port?reconnect=true

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for Microsoft SQL Server

Appeon recommends using jTDS JDBC driver (or WebLogic JDBC driver for WebLogic hosting Appeon Server) rather than the Microsoft SQL Server JDBC driver, because it can eliminate memory leak and boost performance.

Table 30. Data source parameters for Microsoft SQL Server

Driver

Parameter

Value

Note

jTDS JDBC driver (Recommended)

Driver class name

net.sourceforge.jtds.jdbc.Driver

Hostname stands for the database server name or IP address.

Port stands for the database server port. The default SQL Server port is 1433.

DBName stands for the name of the database to which the data source connects.

"SelectMethod=cursor" must be specified, otherwise errors will occur when inserting data.

Database URL

jdbc:jtds:sqlserver://Hostname:​Port/DBName; SelectMethod=cursor

WebLogic SQL Server JDBC driver (for WebLogic server only)

Driver class name

weblogic.jdbc.sqlserver.​SQLServerDriver

Database URL

jdbc:bea:sqlserver://Hostname:​Port

Microsoft SQL Server JDBC driver

Driver class name

test3 For Microsoft SQL 2000: com.microsoft.jdbc.sqlserver.SQL​ServerDriver

For Microsoft SQL 2005: com.microsoft.sqlserver.jdbc.SQL​ServerDriver

Database URL

jdbc:sqlserver://Hostname:Port;​DatabaseName=DBName;​SelectMethod=cursor

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for Oracle

Oracle databases support the Oracle JDBC driver only.

Table 31. Data source parameters for Oracle

Parameter

Value

Note

Driver class name

oracle.jdbc.driver.OracleDriver

Hostname stands for the database server name or IP address.

Port stands for the database server port. The default Oracle port is 1521.

DBName stands for the name of the database to which the data source connects.

Database URL

jdbc:oracle:thin:@hostname:port:DBName for Oracle 9i, 10g, and 11g

jdbc:oracle:thin:@//hostname:port/DBName for Oracle 12c

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for IBM DB2

IBM DB2 databases support the IBM JDBC driver only.

Table 32. Data source parameters for IBM DB2

Parameter

Value

Note

Driver class name

COM.ibm.db2.jdbc.net.DB2Driver

Hostname stands for the database server name or IP address.

Port stands for the database server port. The port used by JDBC will be different than the one used by db2 client. The default JDBC port is 6789 while the port used by db2 client is 50000.

DBName stands for the name of the database to which the data source connects.

Database URL

jdbc:db2://Hostname:Port/DBName

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for Informix

Informix databases support the IBM Informix JDBC driver only.

Table 33. Data source parameters for Informix

Parameter

Value

Note

Driver class name

com.informix.jdbc.IfxDriver

Hostname stands for the name or IP address of the machine hosting the database server. One machine can host several database servers.

Port stands for the database server port.

DBName stands for the name of the database to which the data source connects.

DBServerName stands for the name of the database server.

Database URL

jdbc:informix-sqli://Hostname:Port/DBName: informixserver=DBServerName

For example: jdbc:informix-sqli://192.0.2.117:1527/mytestdb:informixserver=ol_s_122005_144417

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for MySQL

MySQL databases support MySQL Connector/J driver. Different servers use different driver class names. See the following table for details.

Table 34. Data source parameters for MySQL

Application Server

Parameter

Value

Note

JBoss & WebSphere

Driver class name

com.mysql.jdbc.jdbc2.optional.MysqlXADataSource

Hostname stands for the database server name or IP address.

Port stands for the database server port.

ServiceName stands for the name of the database service specified during configuration.

Database URL

jdbc:mysql:Hostname:Port/ServiceName

EAServer & WebLogic

Driver class name

com.mysql.jdbc.Driver

Database URL

jdbc:mysql:Hostname:Port/ServiceName

JEUS

Driver class name

com.mysql.jdbc.jdbc2.optional.MysqlConnection​PoolDataSource

Database URL

jdbc:mysql:Hostname:Port/ServiceName

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for Teradata

Teradata databases support the Teradata JDBC driver only.

Table 35. Data source parameters for Teradata

Parameter

Value

Note

Driver class name

For WebLogic/JBoss/JEUS:

com.teradata.jdbc.TeraDriver

For WebSphere:

com.teradata.jdbc.TeraConnectionPoolDataSource

Hostname stands for the database server name or IP address.

DBPort stands for the database server port. The default Teradata port is 1025.

DBName stands for the name of the database to which the data source connects.

Database URL

jdbc:teradata://Hostname/DATABASE=DBName,​DBS_PORT=DBPort,TMODE=ANSI,CHARSET=​UTF8

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)


Data source parameters for PostgreSQL

PostgreSQL databases support the PostgreSQL JDBC driver only.

Table 36. Data source parameters for PostgreSQL

Parameter

Value

Note

Driver class name

org.postgresql.Driver

Hostname stands for the database server name or IP address.

DBPort stands for the database server port. The default PostgreSQL port is 5432.

DBName stands for the name of the database to which the data source connects.

Database URL

jdbc:postgresql://Hostname:DBPort/DBName

User Name

(Type the database login username. The username is set on the database server.)

Password

(Type the database login password. The password is set on the database server.)