OpenJPA
  1. OpenJPA
  2. OPENJPA-1294

Nested JDBC calls fail for certain database

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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.

        Activity

          People

          • Assignee:
            Pinaki Poddar
            Reporter:
            Pinaki Poddar
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development