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/030... ) 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 [email protected] 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
participants (1)
-
Ludovic Dubost