skip to main content
Configuring an OpenAccess SDK IP for a Third-Party SQL Engine : Configuration Parameters : Configuring an IP Written in Java for a Third-Party SQL Engine
 

Configuring an IP Written in Java for a Third-Party SQL Engine

The following table lists the configuration attributes that can be set for an IP written in Java for a third-party SQL engine.
Table 19. Java IP Parameters
Service Attribute
Description
Calculates the size of the data buffer passed into the sqlipFetchIntoBuffer call when working in bulk fetch mode (ServiceJavaIPUseBulkFetch is Enabled). The total amount of memory allocated to hold rows is this value multiplied by ServiceSQLFetchBlockSize.
Specifies the prefix to use for schema tables when ServiceJavaIPUseCatalogQueries is enabled. The default prefix is OA_.
Calculates the size of the string buffer (the number of bytes per row) passed into the sqlipFetchIntoBuffer call when working in bulk fetch mode (ServiceJavaIPUseBulkFetch is Enabled). The total amount of memory allocated to hold rows is this value multiplied by ServiceSQLFetchBlockSize. Your IP must not exceed the buffer.
Determines whether values for columns are retrieved using data type specific functions when working with a third-party SQL engine in Java. Reserved for internal use.
Determines whether rows are retrieved using the bulk fetch buffers by calling the sqlipFetchRowsInBuffer method in the third-party SQL engine IP. Using bulk fetch improves performance by reducing the number of native to Java calls.
Determines whether schema information is retrieved using queries on underlying tables or views when working with a third-party SQL engine in Java.