Use OpenESQL with the JDBC option to compile your JVM managed applications. This option:
- Is invoked using the SQL(DBMAN=JDBC) compiler directive
- Uses any of several JDBC drivers
- Can connect to one JDBC Data Source using either a JDBC Connection String or a JDBC DataSource Object.
- When connecting with a JDBC DataSource Object, enables you to connect to your Java data source for compilations with the SQL CHECK directive (this simulates OpenESQL DSNs with ODBC or ADO.NET)
- Compiles applications to communicate with the OpenESQL JVM Managed Runtime
- Enables maximum interoperability between different database systems
- Provides support for pessimistic and optimistic (locking) concurrency control
- Supports dynamic SQL using PREPARE, EXECUTE and EXECUTE IMMEDIATE statements and cursors that use prepared statements, but only with host variable lists in the EXECUTE and OPEN statements
- Does not support disconnected or offline DataSets