18 Oct
2006
18 Oct
'06
6:38 a.m.
Hi,
I am trying to get XWiki installed with SQL Server for the first time. When I try to
access WebHome...it gives me this error
javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.XWikiUsers
Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiUsers
Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiUsers
Wrapped Exception: JDBC rollback failed
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
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(SetCharacterEncodingFilter.java:127
Please help.
Thanks in advance
Renny
18 Oct
18 Oct
6:43 a.m.
New subject: [xwiki-users] Trouble setting up xWiki with SQL Server
Hi,
you mean with Microsoft SQL server?
I haven't try with it.
jeremi
On 10/18/06, renny.samuel(a)ge.com <renny.samuel(a)ge.com> wrote:
Hi,
I am trying to get XWiki installed with SQL Server for the first time. When I try to
access WebHome...it gives me this error
javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.XWikiUsers
Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiUsers
Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiUsers
Wrapped Exception: JDBC rollback failed
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
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(SetCharacterEncodingFilter.java:127
Please help.
Thanks in advance
Renny
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
jeremi
6:47 a.m.
New subject: [xwiki-users] Trouble setting up xWiki with SQL Server
Yup it is a Microsoft SQL Server...
Does that error look familiar?? Any kind of help will be appreciated.
Thanks.
Renny
6:51 a.m.
New subject: [xwiki-users] Trouble setting up xWiki with SQL Server
Hi,
i've never seen this one. there is a problem with the rollback.
JDBC rollback failed
jeremi
On 10/18/06, renny.samuel(a)ge.com <renny.samuel(a)ge.com> wrote:
Yup it is a Microsoft SQL Server...
Does that error look familiar?? Any kind of help will be appreciated.
Thanks.
Renny
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
jeremi
7:14 a.m.
New subject: [xwiki-users] Trouble setting up xWiki with SQL Server
To give you a little more info about the error. THe catalina.out showed
14:30:26,900 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/Main/WebHome
XWikiHibernateStore:updateSchema:177 - Schema update for wiki xwiki
14:30:53,682 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/Main/WebHome
JDBCExceptionReporter:logExceptions:71 - SQL Error: 0, SQLState: HY000
14:30:53,682 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/Main/WebHome
JDBCExceptionReporter:logExceptions:72 - [Microsoft][SQLServer 2000 Driver for JDBC]The
DBMS returned an unspecified error.
14:30:53,916 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/Main/WebHome
AbstractFlushingEventListener:performExecutions:277 - Could not synchronize database state
with session
org.hibernate.exception.GenericJDBCException: could not update:
[com.xpn.xwiki.doc.XWikiDocument#495778886]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:1990)
at
org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:1899)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2139)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:75)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:726)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty(XWikiHibernateStore.java:1266)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateStore.java:1169)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:521)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:561)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
at com.xpn.xwiki.XWiki.getUserClass(XWiki.java:1352)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:406)
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:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Thankyou.
Renny
7:22 a.m.
New subject: [xwiki-users] Trouble setting up xWiki with SQL Server
Hi,
have you checked if the tables are created?
I think there is few things like for oracle to adapt xwiki to msql server.
jeremi
On 10/18/06, renny.samuel(a)ge.com <renny.samuel(a)ge.com> wrote:
To give you a little more info about the error. THe
catalina.out showed
14:30:26,900 ERROR http-8080-Processor25
http://localhost:8080/xwiki/bin/view/Main/WebHome XWikiHibernateStore:updateSchema:177 -
Schema update for wiki xwiki
14:30:53,682 WARN http-8080-Processor25
http://localhost:8080/xwiki/bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:71 -
SQL Error: 0, SQLState: HY000
14:30:53,682 ERROR http-8080-Processor25
http://localhost:8080/xwiki/bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:72 -
[Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
14:30:53,916 ERROR http-8080-Processor25
http://localhost:8080/xwiki/bin/view/Main/WebHome
AbstractFlushingEventListener:performExecutions:277 - Could not synchronize database state
with session
org.hibernate.exception.GenericJDBCException: could not update:
[com.xpn.xwiki.doc.XWikiDocument#495778886]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:1990)
at
org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:1899)
at
org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2139)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:75)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:726)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClassProperty(XWikiHibernateStore.java:1266)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiClass(XWikiHibernateStore.java:1169)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:521)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:561)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
at com.xpn.xwiki.XWiki.getUserClass(XWiki.java:1352)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:406)
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:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Thankyou.
Renny
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
jeremi
6604
days inactive
6604
days old
5 comments
2 participants
participants (2)
-
jeremi joslin -
renny.samuel＠ge.com