Added the preferPreparedStatements attribute to the RepositoryConfiguration Configuration object. When set to true, Oracle Waveset uses PreparedStatements whereever possible. By default this attribute is false. (ID-10968)
This attribute can improve repository performance under certain conditions.
The repository must use pooled connections.
The connections must support implicit statement caching.
Otherwise, this attribute may degrade performance. Oracle Waveset does not explicitly cache prepared statements from the client side of the JDBC call. It depends on the JDBC drivers to do that. Since statements are cached on the actual JDBC connection, if connection pooling is not used, there is no opportunity for the cached statements to be re-used. Normally this means Oracle Waveset must be configured to use an application server DataSource, and the DataSource must use JDBC drivers that support implicit connection pooling.