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 Tue, 28 Mar 2017 02:54:42 GMT

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

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

Just an update that from 2.4.11, if you have a complex query (or multiline query in some cases
it seems) whereby your driver can't determine parameter metadata, then you might not be able
to supply an empty map of params and instead have to use the previously mentioned workaround.
This only seems to apply to some drivers, so you'll need to try this yourself. You'll see
some Groovy debug output at the FINE level if you are affected.

> 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)

Mime
View raw message