[GROOVY-8082] Groovy sql.rows returns org.postgresql.util.PSQLException: No hstore extension installed

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.4.4
• Fix Version/s: 2.4.9
• Component/s: SQL processing
• Assignee: Paul King
• Reporter: Clessio Cunha Mendes
• Created: 08/Feb/17 02:09
• Updated: 28/Mar/17 02:54
• Resolved: 16/Feb/17 03:37

Description

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

Issue Links

• relates to: GROOVY-8128 Breaking change in 2.4.9 with Sql query with GString
• links to: GitHub Pull Request #495