PivotTable is using database specific SQL #6
Description
What steps will reproduce the problem?
1. Configure ActivityInfo in order to use a PostgreSQL database
2. Go to the "tables" page
3. Select any indicator
4. Click "Refresh Preview"
What is the expected output? What do you see instead?
A table featuring the selected indicators should be displayed.
Instead a popup state that an error occured.
Server-side, the following error is logged:
org.hibernate.exception.SQLGrammarException: error executing work
[...]
Caused by: org.postgresql.util.PSQLException: ERREUR: l'opérateur n'existe pas
: boolean = integer
Indice : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
Position : 654
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at org.sigmah.server.dao.hibernate.PivotHibernateDAO$1.execute(PivotHibernateDAO.java:459)
at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1873)
... 88 more
Original issue reported on code.google.com by raphael....@gmail.com on 5 Oct 2010 at 10:11