[
https://issues.apache.org/jira/browse/OPENJPA-1294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Donald Woods updated OPENJPA-1294:
----------------------------------
Affects Version/s: (was: 2.0.0-beta)
(was: 2.0.0)
Fix Version/s: (was: 2.0.0)
> Nested JDBC calls fail for certain database
> -------------------------------------------
>
> Key: OPENJPA-1294
> URL: https://issues.apache.org/jira/browse/OPENJPA-1294
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc, kernel, query, sql
> Affects Versions: 2.0.0-M3
> Environment: MySQL
> Reporter: Pinaki Poddar
> Assignee: Pinaki Poddar
> Fix For: 2.0.0-beta
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
