![]() |
Cloudscape Properties
|
Reference Manual |
cloudscape.jdbc.metadataStoredPreparedStatementsFunctionCloudscape's local JDBC driver has built-in queries for the JDBC DatabaseMetaData methods that supply information about the Cloudscape system. These methods are useful for applications working with generic DBMSs, such as database tools. The cloudscape.jdbc.metadataStoredPreparedStatements property configures the JDBC driver to take advantage of stored prepared statements to avoid preparing these queries each time a system starts up. When configured to use stored prepared statements, the JDBC driver stores all JDBC metadata stored prepared statements, which are placed in the SYS schema. JDBC metadata queries are duplicated in every Cloudscape database even if a single Cloudscape instance manages several databases. The full set of statements adds about 60K to the size of a database. You can delete the stored prepared statements in a database created for these queries by executing the method dropAllJDBCMetaDataSPSes in the class COM.cloudscape.database.Database in an SQL-J statement. To create an instance of that class against which you can call the method, call getDatabaseOfConnection() in the class COM.cloudscape.database.Factory (aliased as Factory). For example:
CALL Factory.getDatabaseOfConnection(). The JDBC driver is responsible for the creation and retrieval of the JDBC metadata statements. Possible Values (case-insensitive)
DefaultExamplecloudscape.jdbc.metadataStoredPreparedStatements= ScopeNOTE: Without row locking, concurrency may be bad using the dynamic configuration. Dynamic or StaticThis property is dynamic; if you change it while Cloudscape is running, the change takes effect immediately. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |