[xwiki-users] SQL Schema problem

[David Goodenough]

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:david.goodenough at linkchoose.co.uk]
> Sent: Thursday, 3 August 2006 4:53 AM
> To: xwiki-users at objectweb.org
> 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