Note: This Data Source Profiles tool works for Microsoft .NET Framework\IIS, but does not work for EAServer 6.x, JBoss, JEUS, WebLogic, NetWeaver, and WebSphere.
To create data source for EAServer 6.x, JBoss, JEUS, WebLogic, NetWeaver, and WebSphere, refer to Database Connection Setup in Appeon Server Configuration Guide for J2EE.
Appeon applications use JDBC data sources created in Appeon Server to connect to the database. The Data Source Profile tab allows you to maintain a storage of data sources which you can specify to use for Appeon applications. Its function is the same as the one provided in AEM, and changes made on the tab or AEM are automatically synchronized.
Follow the instructions below to create a data source on the Data Source Profile tab:
Step 1: Select an Appeon Server from the Appeon Server list box. Only the configured Appeon Server profiles are listed.
The data sources existing on the application server will be displayed.
Step 2: Click the Add button to create a data source in the application server. The Add dialog box is displayed.
The following table provides instructions for how to specify the data source settings.
Table 18. Instructions to specify data source settings
|
Settings |
Instructions |
|---|---|
|
Name |
Type the name of the data source. The data source name can contain a combination of letters, underscores ("_"), and numbers. Do not use double-byte characters (such as Chinese, Korean, Japanese characters, etc.) or spaces. |
|
Driver |
Select the driver type for the data source. |
|
Host |
Type the database host. |
|
Port |
Type the database port. |
|
Database Name |
Type the database name. |
|
ODBC Data Source |
Type the data source name only when the driver type is ODBC-JDBC Bridge. |
|
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. |
|
Maximum Connection Pool Size |
Specify the maximum number of connections Appeon Server opens and pools on startup. |
|
Minimum Connection Pool Size |
Specify the minimum number of connections Appeon Server opens and pools on startup. |
|
Connection Timeout |
Specify the timeout period for the connection. |
|
Command Timeout |
Specify the timeout period for the commands. |
|
Connection Lifetime |
Specify the lifetime period for the pooled connection. To be specific, you can specify the timeout period from the time a connection is created to the time when the connection returns to the pool. If the actual lifetime of a connection exceeds that specified in Connection Lifetime, the connection will be terminated. It is recommended to be used in cluster configuration when forcing the load balancing between a running server and a server just brought online. If the value is set to 0, the pooled connection allows the maximum connection timeout. |
|
Other Options |
Specify the connection_authentication property for SAP ASA/SQL Anywhere database. The value should be "authentic_code=###". "authentic_code" is the key word, text after "=" should be the authorization code. Appeon Server will automatically set the connection_authentication property when connecting with the SAP ASA/SQL Anywhere database. This setting is effective to SAP ASA/SQL Anywhere database only. |
|
Dynamic Database Connection |
Select whether to enable dynamic database connection. When it is on, the LogID and LogPass of the Transaction object will be used to connect to the database; when it is off, the user name and password specified in the data source will be used to connect to the database. |
|
Pooling |
Select whether to use the connection pool. |
Refer to the section called “Setting up Appeon Server data sources” in Appeon Server Configuration Guide for .NET or in Appeon Server Configuration Guide for J2EE for how to specify the settings for different JDBC drivers and database types.
