[
https://issues.apache.org/jira/browse/GROOVY-8082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15860838#comment-15860838
]
ASF GitHub Bot commented on GROOVY-8082:
----------------------------------------
GitHub user paulk-asert opened a pull request:
https://github.com/apache/groovy/pull/495
GROOVY-8082: Groovy sql.rows returns org.postgresql.util.PSQLExceptio…
…n: No hstore extension installed
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/paulk-asert/groovy groovy8082
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/groovy/pull/495.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #495
----
commit b34b47623d18372241f0d5242bb780963c0278ab
Author: paulk <[email protected]>
Date: 2017-02-10T06:46:33Z
GROOVY-8082: Groovy sql.rows returns org.postgresql.util.PSQLException: No
hstore extension installed
----
> 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)
