Previous Topic: Supported FeaturesNext Topic: Java Web Client Generation


Multiple Database Support

CA Gen Java applications use JDBC and are designed to allow access to one or more databases within a given procedure step. Clients wishing to use this feature must create a database resource for each database to be accessed by the procedure step.

In contrast, CA Gen C applications can access only one database for a given procedure step. This is due to the use of the default database handle for all embedded SQL statements.

Commits and rollbacks for multiple database connections may or may not be performed using a two-phased commit facility. In the Java Web Client environment, two-phased commit is supported only when the deployment options for using JDBC DataSources and JTA transactions are set and properly configured. In the EJB environment, two-phased commit is supported only when utilizing XA-compliant JDBC and JTA drivers.