[xwiki-users] SQL Schema problem

[Ludovic Dubost]

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.

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 at objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>   


-- 
Ludovic Dubost
XPertNet: http://www.xpertnet.fr/
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic