Hi,
Thanks for the compliments on xwiki ! Well, database porting should be
discussed on the developers list (
http://forge.objectweb.org/mail/?group_id=170 ) and added to the xwiki
page on databases (
http://www.xwiki.org/xwiki/bin/view/Dev/Database+Porting )
Concerning your errors, it doesn't look good.. it seems hibernate is
chocking while looking at the capabilities of the DB2 driver.. However
when I look at this (
http://www-128.ibm.com/developerworks/db2/library/techarticle/0306bhogal/03…
) it seems it should work.
Maybe it fails on something specific in the mapping.. So you might want
to remove each column from the xwiki.hbm.xml file until it works to see
what is the cause. Maybe a simple change in the mapping can make it work
with B2 without breaking xwiki..
Ludovic
jhammonds(a)purina.com wrote:
Hello,
We just started an XWIKI installation in our group, and are pretty impressed
with its capabilities. Typically, we are a DB2 shop; so, I have begun a
migration of XWIKI to DB2 from MySQL. I finally got the databases in sync,
and attempted to configure XWIKI to run against DB2 by doing the following:
* I added the DB2 driver file to the \shared\lib directory.
* I modified the "hibernate.cfg.xml" file based on what I thought it
should be (see attached).
I am using DB2 v7.2.2 and Tomcat v5.5.9.
From what I see, I believe I am getting a connect
to the database, but am
failing with the following exception (see below).
I appreciate any help that you might have to offer. Also, I tried to find a
place to post this problem to a general audience, but don't know where to do
that. If you could direct me to that place I would appreciate it.
Thanks,
Johnnie Hammonds
<<hibernate.cfg.xml>> <<stderr_20050811.log>>
----------------------------------------------------------------------------
-----
type Exception report
message
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception
javax.servlet.ServletException: Servlet execution threw an exception
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi
lter.java:127)
root cause
java.lang.AbstractMethodError:
COM.ibm.db2.jdbc.app.DB2DatabaseMetaData.supportsResultSetType(I)Z
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:75)
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1509)
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1054)
com.xpn.xwiki.store.XWikiHibernateStore.initHibernate(XWikiHibernateStore.ja
va:124)
com.xpn.xwiki.store.XWikiHibernateStore.checkHibernate(XWikiHibernateStore.j
ava:258)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.jav
a:570)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:123)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:565)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:599)
com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:1019)
com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:1014)
com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:422)
com.xpn.xwiki.XWiki.initXWiki(XWiki.java:397)
com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi
lter.java:127)
note The full stack trace of the root cause is available in the Apache
Tomcat/5.5.9 logs.
_____
--
Ludovic Dubost
XPertNet:
http://www.xpertnet.fr/
Blog:
http://www.ludovic.org/blog/
XWiki:
http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic