groovy-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul King (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (GROOVY-8082) Groovy sql.rows returns org.postgresql.util.PSQLException: No hstore extension installed
Date Wed, 08 Feb 2017 13:02:41 GMT

    [ https://issues.apache.org/jira/browse/GROOVY-8082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15857954#comment-15857954
] 

Paul King commented on GROOVY-8082:
-----------------------------------

The Sql api doesn't have a rows(String, Map) variant. Do any of these work:
{code}
groovySql.rows(sql, *params)
groovySql.rows(params, sql)
groovySql.rows(sql, [params])
{code}

> 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
>            Priority: Minor
>
> -> 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)

Mime
View raw message