Uploaded image for project: 'Spring Framework'
  1. Spring Framework
  2. SPR-13582

Spring JDBC not correctly processing Postgresql ?-contained operator

    Details

      Description

      Postgresql has many functional operators such as ? (for example JSONB operators).

      Spring JDBC processing for this case is not correct. When running the following SQL:

      SELECT '["1","2","3"]'::jsonb ? '4'
      

      ... I see exceptions like this:

      class org.springframework.dao.InvalidDataAccessApiUsageException
      SQL [SELECT '["1","2","3"]'::jsonb ? '4']: given 1 parameters but expected 0
      

      In pgjdbc this bug was fixed in 2014 (https://github.com/pgjdbc/pgjdbc/pull/227).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                juergen.hoeller Juergen Hoeller
                Reporter:
                arturgspb Artur Geraschenko
                Last updater:
                Juergen Hoeller
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 30 weeks, 1 day ago