Hi Gerard, I've never used postgre SQL but it's possible it requires some tuning with the xwiki.hbm.xml files. I thought we had some already tuned files but apparently not. Maybe some current postgre sql users can help? You could also try searching the mail archives as I'm pretty sure that's been covered in the past. Thanks -Vincent On Sep 6, 2007, at 9:53 AM, Geert Verhaag wrote:
Hoi Vincent,
Thanks for your response! I indeed followed the installation instructions as presented on www.xwiki.org, but maybe did something wrong.
The strange thing is that at the beginning saving the layout and preferences has been working properly!
The WEB-INF/hibernate.cfg.xml applied contains this part among other things:
<property name="connection.url">jdbc:postgresql://localhost:5432/xwiki</ property> .... <property name="connection.driver_class">org.postgresql.Driver</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionPro vider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
<mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/>
I indeed am a bit in doubt about whether this is correct or not!
Regards, Gerard
[email protected] 06/09/2007 09:22 >>> Hi Gerard,
On Sep 4, 2007, at 2:30 PM, Geert Verhaag wrote:
Dear XWiki Users,
[snip]
When trying to save the layout I get (Windows XP) a popup window appears displaying the message: An error occurred while trying to save the panel layout!
Clicking the OK button of this popup displayes an exception error that starts as:
Wrapped Exception: Invocation of method 'save' in class com.xpn.xwiki.api.Document threw exception com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences. ......
In addition when I want to save my preferences while being administrator I get the following error (part!):
Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc (XWikiHibernateStore.java:314) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:100) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:94) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:914).....
By the way saving preferences as well as a new panel layout has been working properly on this instance of XWiki!
Has anybody any idea? How can I start saving my new panel definitions/preferences again? By the way, I use XWiki version 1.0.3342 in combination with PostgreSQL-8.2, TomCat 5.5 and jdk-6u2! Thanks!
Are you using the Postgre SQL HBM files as indicated in the installation notes?
If not that would explain the errors.
Thanks -Vincent