I tried this, but it does not seem to work. My hibernate.cfg.xml reads:- <property name="connection.url">jdbc:postgresql://localhost/xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="hibernate.query.substitutions">true 1, false 0</property> The precise form of the last tag I got from Chapter 11 of the Hibernate doc at http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html but I get the error:- column "xwp_unmodifiable" is of type smallint but expression is of type boolean This is using the binary version 0.9.840. Any further ideas? David On Wednesday 02 August 2006 22:22, Turner, John wrote:
You can use the "hibernate.query.substitutions" option in your hibernate.cfg.xml configuration file to map boolean values to int values.
JT
-----Original Message----- From: David Goodenough [mailto:[email protected]] Sent: Thursday, 3 August 2006 4:53 AM To: [email protected] Subject: [xwiki-users] SQL Schema problem
I am trying to install xwiki with postgresql 8.1. The binary version does not work as it tries to set an int field with a boolean value (or was it the other way around - I forget).
So I pulled the SVN version in case this had been fixed, and it would seem that this problem no longer exists, but then I hit another problem, the schema that the was with the binary version is not right. But in the SVN version I can not find the new schema. Does anyone have it, or can it be generated?
Regards
David