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
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
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@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
-- Ludovic Dubost XPertNet: http://www.xpertnet.fr/ Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost AIM: nvludo Yahoo: ludovic
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@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
participants (2)
-
David Goodenough -
Ludovic Dubost