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