- Data source parameters for SAP ASA/SQL Anywhere
- Data source parameters for ASE
- Data source parameters for SAP IQ
- Data source parameters for SAP HANA
- Data source parameters for Microsoft SQL Server
- Data source parameters for Oracle
- Data source parameters for IBM DB2
- Data source parameters for Informix
- Data source parameters for MySQL
- Data source parameters for Teradata
- Data source parameters for PostgreSQL
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.
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.) |
||
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.) |
|
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 (Recommended) |
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.) |
||
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.) |
||
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.SQLServerDriver For Microsoft SQL 2005: com.microsoft.sqlserver.jdbc.SQLServerDriver |
|
|
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.) |
||
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.) |
|
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.) |
|
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.) |
|
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.MysqlConnectionPoolDataSource |
|
|
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.) |
||
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.) |
|
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.) |
|
