[
https://issues.apache.org/jira/browse/GROOVY-8082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15860842#comment-15860842
]
Paul King commented on GROOVY-8082:
-----------------------------------
You could argue that this isn't a bug but a misuse of the api. However, having
said that, the error message when you supply the empty map is quite misleading,
so the proposed PR looks for the special case of an empty supplied map when no
parameter placeholders are found in the sql. It is then equivalent to calling
with the empty list.
> 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)
