xwiki hibernate problem jboss 4 postgres
Hi, I haven't been able to install xwiki due to issues with hibernate. I'm running CentOS 4.4, Jboss 4.0.5.GA, Postgres 8.1.5, xWiki.0.9.840, j2sdk 1.4.2_13 and postgresql-8.1-407.jdbc3.jar. I configured my hibernate.cfg.xml for postgres, put the necessary postgres jdbc jar file in the server/default/lib directory. The hibernate configuration is working because it successfully starts reading from the postgres database, until this call - see stack trace is made and I get a objectnotfoundexception: no row with the given identifier exists. I enabled sql statement logging, so the sql statement is shown above the stack trace. I applied the: xwiki.pg.dml.sql xwiki.pg.ddl.sql xwiki-db-0.9.2-pgsql.sql files with the psql -f filename xwiki This is my postgres schema: xwiki=# \d List of relations Schema | Name | Type | Owner --------+-------------------------+-------+---------- public | xwikiattachment | table | postgres public | xwikiattachment_archive | table | postgres public | xwikiattachment_content | table | postgres public | xwikibooleanclasses | table | postgres public | xwikiclasses | table | postgres public | xwikiclassesprop | table | postgres public | xwikidateclasses | table | postgres public | xwikidates | table | postgres public | xwikidblistclasses | table | postgres public | xwikidoc | table | postgres public | xwikidouble | table | postgres public | xwikidoubles | table | postgres public | xwikifloats | table | postgres public | xwikiintegers | table | postgres public | xwikilargestrings | table | postgres public | xwikilistitems | table | postgres public | xwikilists | table | postgres public | xwikilock | table | postgres public | xwikilongs | table | postgres public | xwikinumberclasses | table | postgres public | xwikiobjects | table | postgres public | xwikiproperties | table | postgres public | xwikislistclasses | table | postgres public | xwikistatsdoc | table | postgres public | xwikistatsreferer | table | postgres public | xwikistatsvisit | table | postgres public | xwikistringclasses | table | postgres public | xwikistrings | table | postgres (28 rows) Anybody know what is wrong here? Thanks in advance! -matt 20:32:48,335 INFO [STDOUT] Hibernate: select xwikidocum0_.XWD_ID as XWD1_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD4_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD6_0_0_, xwikidocum0_.XWD_DATE as XWD7_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD8_0_0_, xwikidocum0_.XWD_AUTHOR as XWD9_0_0_, xwikidocum0_.XWD_CREATOR as XWD10_0_0_, xwikidocum0_.XWD_WEB as XWD11_0_0_, xwikidocum0_.XWD_CONTENT as XWD12_0_0_, xwikidocum0_.XWD_ARCHIVE as XWD13_0_0_,xwikidocum0_.XWD_VERSION as XWD14_0_0_, xwikidocum0_.XWD_PARENT as XWD15_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=? 20:32:48,339 INFO [DefaultLoadEventListener] Error performing load command org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.xpn.xwiki.doc.XWikiDocument#-1363070189] at org.hibernate.ObjectNotFoundException.throwIfNull( ObjectNotFoundException.java:27) at org.hibernate.event.def.DefaultLoadEventListener.load( DefaultLoadEventListener.java:118) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad( DefaultLoadEventListener.java:167) at org.hibernate.event.def.DefaultLoadEventListener.onLoad( DefaultLoadEventListener.java:79) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc( XWikiHibernateStore.java:575) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc( XWikiCacheStore.java:123) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:565) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:599) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:617) at com.xpn.xwiki.plugin.TablePlugin.init(TablePlugin.java:82) at com.xpn.xwiki.plugin.TablePlugin.<init>(TablePlugin.java:53) at jrockit.reflect.NativeConstructorInvoker.newInstance([ Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source) at java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;J)Ljava.lang.Object;(Unknown Source) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin( XWikiPluginManager.java:58) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins( XWikiPluginManager.java:77) at com.xpn.xwiki.plugin.XWikiPluginManager.<init>( XWikiPluginManager.java:41) at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:422) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:397) at com.xpn.xwiki.XWiki.<init>(XWiki.java:343) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) at org.apache.struts.action.RequestProcessor.processActionPerform( RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java :1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java :397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:252) 20:32:48,346 INFO [DBCPConnectionProvider] active: 0 (max: 50) idle: 1(max: 5) 20:32:48,415 INFO [DBCPConnectionProvider] active: 1 (max: 50) idle: 0(max: 5) -- -- Matthew Ma http://www.lightspoke.com Lightspoke Web Based Database
participants (1)
-
Matthew Ma