3 Aug
2006
3 Aug
'06
11:21 a.m.
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@linkchoose.co.uk]
Sent: Thursday, 3 August 2006 4:53 AM
To: xwiki-users(a)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