On Thursday 03 August 2006 23:41, Ludovic Dubost wrote:
Hi,
XWiki is creating/updating it's schema using SchemaUpdate with the
"xwiki.hibernate.updateschema=1" property in xwiki.cfg
Now creating the schema is not really enough for xwiki. A default
database with some data is quite useful.
Somebody did port a database to postgres. Maybe it can be upgraded by
xwiki to the right schema for the SVN version.
Well it may be trying to update it
schema, but my experience with the
SVN version is that it is not succeeding. The startup kept on failing
with missing columns, so obviously the schema has not been updated.
Yes I understand that the new columns will have no data, but the
error indicated (and psql confirmed this) that the column was not
being created.
David
Another option is to use the import/export facility to import the
default database available in SVN as XML files into postgres
(
http://www.xwiki.org/xwiki/bin/view/AdminGuide/Backup )
Ludovic
David Goodenough a écrit :
> On Wednesday 02 August 2006 19:52, David Goodenough wrote:
>> 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
>
> Following up on my own question, I understand that Hibernate has the
> facility to update the DB schema on the fly. Would it not be sense to
> use net.sf.hibernate.tool.hbm2ddl.SchemaUpdate to do this. I understand
> that this is designed to be used from an Ant task, but I suppose it may
> also be callable from the startup code.
>
> David
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the xwiki-users(a)objectweb.org
> mailing list. To unsubscribe:
> mailto:xwiki-users-unsubscribe@objectweb.org
> For general help: mailto:sympa@objectweb.org?subject=help
> ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws