Uploaded image for project: 'Spring Data JPA'
  1. Spring Data JPA
  2. DATAJPA-433

findAll(Iterable<ID> ids) not working on EclipseLink and Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.2 (Babbage SR1)
    • Component/s: Core
    • Labels:
      None
    • Environment:
      JPA Provider: EclipseLink 2.5.1
      Database: Oracle Version: Oracle Database 10g Release 10.2.0.1.0 - Production
      Driver: Oracle JDBC driver Version: 11.2.0.3.0
      Spring Data JPA: 1.4.2
    • Sprint:
      42 - 2014 Kickoff, 44 - Codd GA, 45 - Dijkstra M1, 46 - Codd SR2, 47 - Dijkstra RC1, 48 - Dijkstra GA

      Description

      On Oracle, I hit 'ORA-00907: missing right parenthesis' when using JpaRepository.findAll(Iterable<ID> ids).

      It appears to have something to do with the way how the IN query is being generated; Oracle doesn't seem to like the double parenthesis. Example sql being generated: SELECT * FROM table WHERE id IN ((?, ?, ?))

      The same also happens when using the In keyword in query methods.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              schauder Jens Schauder
              Reporter:
              philippn Philipp Nanz
              Last updater:
              Mark Paluch
              Votes:
              5 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: