org.postgresql.util.PSQLException: No hstore extension installed.


Solutions on the web

Solution icon of stackoverflow
No hstore extension installed.

Solution icon of web
via JIRA by Charlie Sharpsteen, 7 months ago
No hstore extension installed.

Solution icon of stackoverflow
No hstore extension installed.

Stack trace

org.postgresql.util.PSQLException: No hstore extension installed.
	at org.postgresql.jdbc.PgPreparedStatement.setMap(PgPreparedStatement.java:553)
	at org.postgresql.jdbc.PgPreparedStatement.setObject(PgPreparedStatement.java:1036)
	at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.setObject(PreparedStatementJavassistProxy.java)
	at groovy.sql.Sql.setObject(Sql.java:4134)
	at groovy.sql.Sql.setParameters(Sql.java:4099)
	at groovy.sql.Sql.getPreparedStatement(Sql.java:4360)
	at groovy.sql.Sql.getPreparedStatement(Sql.java:4436)
	at groovy.sql.Sql.executeUpdate(Sql.java:2863)
	at groovy.sql.Sql.executeUpdate(Sql.java:2885)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

9 times, 7 months ago