Chapter 4. Extensions to JDBC

It is not necessary to pool client-side JBoss Data Virtualization prepared statements, because JBoss Data Virtualization performs plan caching on the server side.

The number of cached plans is configurable. The plans are purged in order of least recently used (LRU).

Cached plans are not distributed through a cluster. A new plan must be created for each cluster member.

Plans are cached for the entire VDB or for just a particular session. The scope of a plan is detected automatically based upon the functions evaluated during its planning process.

Runtime updates of costing information do not yet cause re-planning. At this time only session-scoped temporary table or internally materialized tables update their costing information.

Stored procedures executed through a callable statement have their plans cached in the same way as a prepared statement.

Bind variable types in function signatures, for example where t.col = abs(?), can be determined if the function has only one signature or if the function is used in a predicate where the return type can be determined. In more complex situations it may be necessary to add a type hint with a cast or convert, for example upper(convert(?, string)).