- Data source parameters for SAP SQL Anywhere
- Data source parameters for ASE
- Data source parameters for SAP IQ
- 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 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 PowerServer supports: WebLogic, WebSphere, JBoss, and JEUS.
Note that the values of driver class name and Database URL are case sensitive.
SAP 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 SQL Anywhere, you must start SQL Anywhere as service before configuration.
3) jConnect 6.0 is preferable to jConnect 5.5.
Table 25. Data source parameters for SAP 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 SQL Anywhere port is 2638. ServiceName stands for the name of the 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 26. 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 27. 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.) |
||
We recommend using jTDS JDBC driver (or WebLogic JDBC driver for WebLogic hosting PowerServer) rather than the Microsoft SQL Server JDBC driver, because it can eliminate memory leak and boost performance.
Table 28. 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. |
|
XA datasource class |
net.sourceforge.jtds.jdbcx.JtdsDataSource |
||
|
Database URL |
jdbc:jtds:sqlserver://Hostname:Port/;DatabaseName=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 |
com.microsoft.jdbc.sqlserver.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 29. 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 11g jdbc:oracle:thin:@//hostname:port/DBName for Oracle 12c, 18c, and 19c |
|
|
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 30. 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 31. 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 32. 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 |
||
|
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.) |
||
PostgreSQL databases support the PostgreSQL JDBC driver only.
Table 33. 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.) |
|
