6 Sep
2007
6 Sep
'07
10:03 a.m.
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
>> vincent(a)massol.net 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