Implementing Schema Objects in Java

In a Java environment, the OpenAccess SDK Server maps the schema object requests to calls to methods on the sqlip interface, such as sqlipTables, sqlipColumns, etc. (see Connection-level Methods for Java). The third-party SQL engine IP must implement these methods to open the cursors according to their definitions in the Schema Objects section. The cursor opened must match the column sequence and types described in this section. Column names are not important. By default, the third-party SQL engine API calls the schema methods. Alternatively, the queries can be sent directly to your data source.

If you want to skip implementation of schema methods, you can instead set the ServiceJavaIPUseCatalogQueries service attribute to Enable. The schema request will be passed to the SQL database as a normal query through the sqlipPrepareStmt and sqlipExecuteStmt calls.