I'm using: <property name="hibernate.query.substitutions">true 1, false 0</property> In my hibernate.cfg.xml successfully when running against an Oracle database (9iR2 or 10g2) and using XWiki version 0.9.840. Maybe the behaviour is different in the PostgreSQL environment? JT -----Original Message----- From: David Goodenough [mailto:david.goodenough@linkchoose.co.uk] Sent: Thursday, 3 August 2006 7:22 PM To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] SQL Schema problem 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: