[
https://issues.apache.org/jira/browse/GROOVY-8082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15857954#comment-15857954
]
Paul King edited comment on GROOVY-8082 at 2/8/17 1:21 PM:
-----------------------------------------------------------
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}
Actually, I just tried them and there doesn't seem to be a useful workaround
apart from the empty list as you suggest or perhaps more intuitively:
{code}
def result = params ? groovySql.rows(sql, params) : groovySql.rows(sql)
{code}
was (Author: paulk):
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)
