Do you have in your xwiki.cfg xwiki.store.hibernate.updateschema=1 Normally additional fields should be created automatically Ludovic Fabian Gorsler a écrit :
Hi Vincent,
thanks for your fast reply. :)
The migration is described in the Release Notes and I've just linked it from the installation page this morning.
The tasks described in the Release Notes don't work for my problem. At the moment I'm not able to display anything with XWiki, I just receive exceptions.
Ha, that would be a problem. We need to track this as this is supposed to be the way to upgrade. What errors are you getting?
org.postgresql.util.PSQLException: ERROR: column xwikidocum0_.xwd_title does not exist
This exception led me to assume that Hibernate mappings have changed. The dump I've set up on my database for testing is identical to the live system which serves the old XWiki.
(The whole log with more exceptions and details is here: http://www.der-moloch.de/files/xwiki-ml/xwiki_stdout.log)
Don't do it manually!
:)
We thought it would work seamlessly but it seems it doesn’t in your case so we need to find out what's not working. Let's work together to resolve this.
This sounds really great. Perhaps I should pass you my whole configuration at first:
- OS: Windows XP SP 2 - Tomcat 5.5.20 - JVM: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03) - DB: PostgreSQL 8.1.5 (JDBC: postgresql-8.1-408.jdbc3.jar) / UTF-8
The things I did:
- I downloaded xwiki-1.0-beta-1.war and deployed it via Tomcat Manager. - Stopped Tomcat. - Renamed xwiki-1.0-beta-1/ to xwiki/ in webapps-folder of Tomcat. - Added Postgres-JDBC-driver to xwiki/WEB-INF/lib. - Edited hibernate.cfg.xml: Removed MySQL entries, pasted our configuration of the old XWiki and reconfigured some connection settings. - Started Tomcat and tried to open http://localhost:8080/xwiki/bin/view/Main/WebHome.
The connection settings from hibernate.cfg.xml: <property name="connection.url">jdbc:postgresql://localhost/xwikidb</property> <property name="connection.username">xwiki</property> <property name="connection.password">topsecret</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>
Connections to the Postgres-DB are opened and data is transferred. The connection seems to be ok.
Which information do you need additionally? What should I try to do?
Thanks in advance for your help! :)
Best regards, Fabian.
------------------------------------------------------------------------
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- Ludovic Dubost Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost AIM: nvludo Yahoo: ludovic