To configure XA-compliant SQL components, you must integrate them using a Remote JDBC service endpoint.
This implementation is required when you want your J2EE application server to handle and administer the database connections. If this is the case, first configure the J2EE Application Server service endpoint to access the application server, and then configure the Remote JDBC service endpoint.
To create a Remote JDBC service endpoint service endpoint:
Access the Service
Endpoints | Add Service Endpoint | Edit Service Endpoint endpoint_name
page for the SQL Database type and Remote JDBC subtype.
For access instructions, see Creating
a Service Endpoint.
Enter the properties for the service endpoint:
Database Type - The type of database that you will be connecting to:
IBM DB2 JDBC (Type 2)
Cloudscape Database
MsSQL JDBC (i-net Driver)
Sybase Database
MsSQL JDBC (DataDirect Connect for JDBC)
IBM DB2 JDBC (Type 3)
DB2 Universal Database Driver
Sybase Database (SA JDBC)
MySQL Database
Informix Database
Oracle Database
IBM DB2 AS/400 JDBC
Postgress SQL Database
Microsoft SQL Database
MsSQL 2005 Microsoft Driver
DB2 Database for OS390
Oracle (DataDirect Connect for JDBC)
Progress Database
J2EE - The J2EE configuration that you previously defined as a J2EE Application Server service endpoint. This is the application server that manages the database connections.
Lookup Name - The JNDI lookup name for the database connection configured in the application server.
Note: if you are in Studio environment, define the J2EE configuration as a GENERIC J2EE, as it is external to the Studio. If you are working in an Enterprise J2EE environment, that is deployed in the same J2EE application server that handles the connections to the database, remember to redefine the service endpoint to access to it into LOCAL, as it is the same application server.
Click Save.
Note: Default values may not be appropriate for your database. You should review and override with values suitable for the database.