Setting up data source for JEUS

The following section will take one database type (Oracle database with Oracle JDBC driver) as an example to show you how to create a data source for JEUS, you can later create data sources for other database types by taking the same steps below but specifying different parameters according to Data source parameters.

Detailed steps are as below:

Step 1: Start JEUS and log on to the JEUS Manager.

Step 2: Click the node name: JEUS Manager Resources > JDBC in the JEUS Node Tree.

Step 3: Click Creating a new JDBC DataSource.

Figure 63. JDBC DataSource page

JDBC DataSource page

Step 4: In the DBMS dropdown list box, select Oracle, and in the DataSources Available list box, select Oracle LocalXADataSource -- Thin.

Figure 64. Creating a new JDBC DataSource page

Creating a new JDBC DataSource page

You must select LocalXADataSource or XADataSource. LocalXADataSource is preferable to XADataSource because it improves the application performance. For SQL Anywhere databases, you can only select LocalXADataSource. Following are the recommended datasources for different database drivers:

  • MS SQL Server 2000 JDBC driver: MS-SQ LocalXADataSource

  • MS SQL Server 2005 JDBC driver: Custom DataSource

  • jTDS/IBM JDBC Driver: BlackBox LocalXADataSource

  • Oracle JDBC driver: Oracle LocalXADataSource -- Thin, or Oracle XADataSource -- Thin

  • jConnect: SAP jConnect 5.5 LocalXADataSource

Step 5: Specify the datasource properties and click Next twice.

Figure 65. Datasource properties page

Datasource properties page

The following table lists instructions for how to specify the properties for a datasource.

Table 24. Datasource properties

Export Name

Input any text as the datasource name. For example, "oracle_datasource1". This name will be recognized as the data source name in AEM.

Database Name

Type the database name. For example, "oracletest01".

Port Number

Type the database port. The default port is 1521.

Server Name

Type the database server name. For example, 192.0.0.91.

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.

If the password has no effect in the Password field, input "password=password" to the Additional Properties box.


Step 6: Click Create and ensure that the JDBC data source is successfully created.

Figure 66. Create a new JDBC DataSource page

Create a new JDBC DataSource page

A message pops up if the JDBC data source is successfully created.

Figure 67. Datasource successfully created

Datasource successfully created