OpenJPA
  1. OpenJPA
  2. OPENJPA-1054

Large result sets do not work with MySQL

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.3.0, 2.0.0-M2
    • Component/s: jdbc
    • Labels:
      None
    • Patch Info:
      Patch Available

      Description

      Large result sets do not work as documented. I did some googling around [1] and found a number of posts talking about how setFetchSize on the JDBC driver isn't being honored, some dating back as far as 2002. The MySQL docs [2] state "When using versions of the JDBC driver earlier than 3.2.1, and connected to server versions earlier than 5.0.3, the setFetchSize() method has no effect, other than to toggle result set streaming as described above.". The doc outlines some additional instructions on how to create a statement that is going to allow a streaming result set.

      I spoke with Fey and she provided me with a patch that will allow us to use LRS with some limitations. I'm in the process of updating the docs and adding tests for the patch that Fey provided.

      [1] Google "mysql jdbc setFetchSize"
      [2]http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-implementation-notes.html

        Activity

        Rick Curtis created issue -
        Rick Curtis made changes -
        Field Original Value New Value
        Attachment OPENJPA-1054.patch [ 12406811 ]
        Donald Woods made changes -
        Patch Info [Patch Available]
        Michael Dick made changes -
        Assignee Michael Dick [ mikedd ]
        Michael Dick made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 1.3.0 [ 12313326 ]
        Resolution Fixed [ 1 ]
        Donald Woods made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Michael Dick
            Reporter:
            Rick Curtis
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development