JDBC

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