Limit statements cached in DatabaseMetaData [JDBC557] #590
Labels
affect-version: Jaybird 3.0.0
affect-version: Jaybird 3.0.1
affect-version: Jaybird 3.0.2
affect-version: Jaybird 3.0.3
affect-version: Jaybird 3.0.4
affect-version: Jaybird 3.0.5
affect-version: Jaybird 4
component: jdbc driver
fix-version: Jaybird 3.0.6
fix-version: Jaybird 4
priority: major
resolution: fixed
type: improvement
Submitted by: @mrotteveel
We're currently caching the prepared metadata statements for reuse, but we have not put any limits on the number of statements cached. Statements are only cleaned if the connection is closed, or DatabaseMetaData is 'closed' through the Jaybird specific FirebirdDatabaseMetaData.close() method. As some forms metadata methods may generate multiple statements depending on the values passed, this may grow.
We should change this to some form of LRU cache that only caches a limited number of statements, and closes statements if that limit is reached.
Commits: d7c04f3 ad5c487 9d76602 14caaa4
The text was updated successfully, but these errors were encountered: