Re: DB2 and XWIKI

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: DB2 and XWIKI

Ludovic Dubost-2

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/0306bhogal.html 
) 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

[hidden email] 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




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws