Uploaded image for project: 'Groovy'
  1. Groovy
  2. GROOVY-8082

Groovy sql.rows returns org.postgresql.util.PSQLException: No hstore extension installed

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4.4
    • Fix Version/s: 2.4.9
    • Component/s: SQL processing
    • Labels:
      None

      Description

      -> Steps to Reproduce

      1) create a simple sql string with no where clause
      2) pass an empty Map [:] as params to groovySql.rows(sql, params)

      PS: (as workargound, passing an empty List, instead of an empty map, as params behaves like expected)

      -> Expected Behaviour

      call postgres and run the sql passing no parameters

      -> Actual Behaviour

      Exception raised: No hstore extension installed.. Stacktrace follows:
      org.postgresql.util.PSQLException: No hstore extension installed.
      at org.postgresql.jdbc2.AbstractJdbc2Statement.setMap(AbstractJdbc2Statement.java:1707)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1910)
      at org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:36)
      at org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:47)

      -> Environment Information

      Operating System: Windows
      Grails Version: 2.5.4
      JDK Version: 1.7
      Container Version (If Applicable): N/A
      Database: Postgres 9.3.13

      -> Probable fix

      Method singletonList(Object item) at groovy.sql.SQL

      -> More information

      http://stackoverflow.com/q/39245870/1916198

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                paulk Paul King
                Reporter:
                clessiomendes Clessio Cunha Mendes
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: