[jira] [Resolved] (GROOVY-8082) Groovy sql.rows returns org.postgresql.util.PSQLException: No hstore extension installed

["Paul King (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GROOVY-8082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul King resolved GROOVY-8082.
-------------------------------
       Resolution: Fixed
         Assignee: Paul King
    Fix Version/s: 2.4.9

Proposed PR merged. From 2.4.9, you can now supply an empty map if you want to - provided you have no placeholders you are trying to fill of course.

> Groovy sql.rows returns org.postgresql.util.PSQLException: No hstore extension installed
> ----------------------------------------------------------------------------------------
>
>                 Key: GROOVY-8082
>                 URL: https://issues.apache.org/jira/browse/GROOVY-8082
>             Project: Groovy
>          Issue Type: Bug
>          Components: SQL processing
>    Affects Versions: 2.4.4
>            Reporter: Clessio Cunha Mendes
>            Assignee: Paul King
>            Priority: Minor
>             Fix For: 2.4.9
>
>
> -> 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



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)