[xwiki-users] SQL Schema problem

[Turner, John]

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 at linkchoose.co.uk] 
Sent: Thursday, 3 August 2006 7:22 PM
To: xwiki-users at 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:
> 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