[OPENJPA-1294] Nested JDBC calls fail for certain database

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0-M3
• Fix Version/s: 2.0.0-beta
• Component/s: jdbc, kernel, query, sql
• Environment: MySQL
• Assignee: Pinaki Poddar
• Reporter: Pinaki Poddar
• Created: 11/Sep/09 21:59
• Updated: 09/Mar/10 18:31
• Resolved: 12/Nov/09 06:38

Description

Some use cases require a new database connection to perform operation because the current connection is busy/open.
Typical use case is asking for size of the result set (obtained by a SELECT COUNT query) while the original result set is still being open.

Some databases (e.g. MySQL as per observation) do not allow the new COUNT query on the same connection because the original result set is still open.

A JDBCStore.getNewConnection() is added – but use it with caution, remember to close it and use it only when required.