hello,
I'm trying to install xwiki version 1.7rc1 on the postgres 8.3 using
jdbc - postgresql-8.3-603.jdbc3.jar.
After configuration hibernate have problem with database:
2008-12-03 17:00:54,551
[
http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6]
INFO .AbstractXWikiMigrationManager - New storage version is now [7351]
2008-12-03 17:00:58,749 [Lucene index rebuilder thread] [Lucene Index
Rebuilder] WARN util.JDBCExceptionReporter - SQL Error: 0,
SQLState: 42883
2008-12-03 17:00:58,750 [Lucene index rebuilder thread] [Lucene Index
Rebuilder] ERROR util.JDBCExceptionReporter - ERROR: operator does
not exist: boolean <> integer
2008-12-03 17:00:58,768 [Lucene index rebuilder thread] [Lucene Index
Rebuilder] WARN lucene.IndexRebuilder - Error getting
document names for wiki [xwiki]. Internal error is: $s
2008-12-03 17:00:59,153
[
http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6]
WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42883
2008-12-03 17:00:59,159
[
http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6]
ERROR util.JDBCExceptionReporter - ERROR: operator does not exist:
boolean <> integer
2008-12-03 17:00:59,169
[
http://xxx.com/xwiki-enterprise-web-1.7-rc-1/bin/view/Main/] [qtp0-6]
ERROR scheduler.SchedulerPlugin - Failed to initialize the scheduler
com.xpn.xwiki.plugin.scheduler.SchedulerPluginException: Error number
90009 in 5: com.xpn.xwiki.plugin.scheduler.SchedulerPlugin: Failed to
restore existing scheduler jobs
Wrapped Exception: Error number 3223 in 3: Exception while searching
documents with SQL [select distinct doc.space, doc.name from
XWikiDocument as doc , BaseObject as obj where (doc.hidden <> 1 or doc.hid
den is null) and doc.web='Scheduler' and obj.name=doc.fullName and
obj.className='XWiki.SchedulerJobClass']
Wrapped Exception: could not execute query
at
com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.restoreExistingJobs(SchedulerPlugin.java:282)
at
com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.init(SchedulerPlugin.java:130)
at
com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:155)
at
com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:92)
at
com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:120)
at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1007)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:728)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:656)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:316)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:387)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1121)
at com.xpn.xwiki.plugin.webdav.DavFilter.doFilter(DavFilter.java:68)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112)
at
com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:96)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112)
at
com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:287)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363)
at
org.mortbay.jetty.security.ConstraintsSecurityHandler.handle(ConstraintsSecurityHandler.java:220)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:822)
at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:305)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:229)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:113)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:550)
at
org.mortbay.jetty.ajp.Ajp13Connection.access$2800(Ajp13Connection.java:44)
at
org.mortbay.jetty.ajp.Ajp13Connection$RequestHandler.headerComplete(Ajp13Connection.java:232)
at org.mortbay.jetty.ajp.Ajp13Parser.parseNext(Ajp13Parser.java:498)
at
org.mortbay.jetty.ajp.Ajp13Parser.parseAvailable(Ajp13Parser.java:151)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:407)
at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:235)
at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
...
Wrapped Exception:
org.postgresql.util.PSQLException: ERROR: operator does not exist:
boolean <> integer
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal(XWikiHibernateStore.java:2262)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2235)
at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2708)
at
com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:251)
at
com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.restoreExistingJobs(SchedulerPlugin.java:263)
at
com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.init(SchedulerPlugin.java:130)
at
com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:155)
at
com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:92)
at
com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:120)
Anybody know how to solve this problem?
Thx for help and Greetings,
Bart
--
Bartłomiej Radziszewski
mobile: +48 509 561 540
e-mail: br(a)debian.linux.pl
JID: br(a)debian.linux.pl
ICQ: #305569725