Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1294

Nested JDBC calls fail for certain database

    Details

    • 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
    • Labels:
      None
    • Environment:
      MySQL

      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.

        Attachments

          Activity

            People

            • Assignee:
              ppoddar@apache.org Pinaki Poddar
              Reporter:
              ppoddar@apache.org Pinaki Poddar
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: