Hi, I am new to XWiki and am currently trying to set up a local test system. I downloaded the latest war and mysql -dump, did all the configuration and even the troubleshootinghints (copying jars to tomcat/common) but I still get this error: I guess the key is "could get JDBC batch update" ... Its mysql 4.1.15 as it comes with ubuntu dapper an tomcat 5.5.16 on JRE5 (1.5.06) Anyone with an idea? tia Jan HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception 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.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update 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) root cause com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.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(SetCharacterEncodingFilter.java:127)
Is it possible that you are not able to make DB connection using mysql driver? Did you edit hibernate.cfg.xml with relevent JDBC url entries, username and password? Did you populate the tables uner xwiki schema in mysql etc.? (Just double checking). You may want to start with log entries in Tomcat stdout/stderr logs and xwiki.log file in tomcat\bin directory. There is also a log4j.properties file in WEB-INF\classes. You may set entries all the entries 'debug' (note: it will produce a LOT of log) to debug. HTH, Srini On 6/23/06, Jan Galinski <[email protected]> wrote:
Hi,
I am new to XWiki and am currently trying to set up a local test system. I downloaded the latest war and mysql -dump, did all the configuration and even the troubleshootinghints (copying jars to tomcat/common) but I still get this error:
I guess the key is "could get JDBC batch update" ...
Its mysql 4.1.15 as it comes with ubuntu dapper an tomcat 5.5.16 on JRE5 (1.5.06)
Anyone with an idea? tia Jan
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
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.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update 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)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) org.apache.struts.action.RequestProcessor.processActionPerform( RequestProcessor.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( SetCharacterEncodingFilter.java:127)
-- You receive this message as a subscriber of the [email protected] list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Thanks Srini,
Is it possible that you are not able to make DB connection using mysql driver? Did you edit hibernate.cfg.xml with relevent JDBC url entries, username and password? Did you populate the tables uner xwiki schema in mysql etc.? (Just double checking).
I triple and quadruple checked everything. I wrote a TestClass that connects to the successfuly database, I have the latest versions of mysql.jar, commons-*.jar in tomcat/commons or xwik/lib, I even set up a different db on a remote system, it wot work. I have mysql 4.1.15, Tomcat 5.5.16 and Java 5 (1.5.06) on a Ubuntu Dapper (6.06) System. I have a db xwiki and a user xwiki(pw: xwiki) and the db contains teh example content. I can contact the db with my Testclass using java.sql or the mysql cli-client with the given user details and read/write information to the db. When I change the user/password values to wrong data, I get "couldnt create pool", when I have the right values I get "could not open connection".
You may want to start with log entries in Tomcat stdout/stderr logs and xwiki.log file in tomcat\bin directory.
There is also a log4j.properties file in WEB-INF\classes. You may set entries all the entries 'debug' (note: it will produce a LOT of log) to debug.
tomcat log says nothing, xwiki log (though everything is set to debug) just writes the stacktrace I already saw on the browser screen. I'm getting frustrated on this, I dont want to switch from MySQL, I dont wont to install an other wiki system but I cannot see what else to try (except maybe voodoo ot). Is there anyone out there willing to check my config or just try to setup an xwiki system based on Ubuntu Dapper? BTW: I recall encountering one Problem during installation: the mysql import refused to run through due to a "syntax error". Seems like the demo db uses Mysql 4.1.* features, so the "also works with 4.0.*) on the install page should be removed. Anyhelp appreciated, gladly offer vbs (virtual beers) or iidtd (imaginary i do the dishes) in exchange ... regards Jan
HTH, Srini
On 6/23/06, Jan Galinski <[email protected]> wrote:
Hi,
I am new to XWiki and am currently trying to set up a local test system. I downloaded the latest war and mysql -dump, did all the configuration and even the troubleshootinghints (copying jars to tomcat/common) but I still get this error:
I guess the key is "could get JDBC batch update" ...
Its mysql 4.1.15 as it comes with ubuntu dapper an tomcat 5.5.16 on JRE5 (1.5.06)
Anyone with an idea? tia Jan
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
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.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update
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)
root cause
com.xpn.xwiki.XWikiException : Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWiki.getMainXWiki (XWiki.java:142) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
org.apache.struts.action.RequestProcessor.processActionPerform (RequestProcessor.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 (SetCharacterEncodingFilter.java:127)
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto: [email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Hi, can you try to add : ?useServerPrepStmts=false at the end of your connection url in hibernate.cfg.xml example for me: <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false</property> It's a problem with ubuntu, i don't know why. Jérémi On 6/23/06, Jan Galinski <[email protected]> wrote:
Hi,
I am new to XWiki and am currently trying to set up a local test system. I downloaded the latest war and mysql -dump, did all the configuration and even the troubleshootinghints (copying jars to tomcat/common) but I still get this error:
I guess the key is "could get JDBC batch update" ...
Its mysql 4.1.15 as it comes with ubuntu dapper an tomcat 5.5.16 on JRE5 (1.5.06)
Anyone with an idea? tia Jan
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
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.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update 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)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.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(SetCharacterEncodingFilter.java:127)
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- jeremi
Jérémi, you are my hero!
can you try to add : ?useServerPrepStmts=false at the end of your connection url in hibernate.cfg.xml
I tried and it works.
It's a problem with ubuntu, i don't know why.
Me neither, but now that it works ... I will move the DB from my local system to a debian sarge server in a few weeks, maybe than no more fixes are required. Until then: I owe you. I suppose you are from France? I am sitting in Hamburg, Germany so neither you coming around for a beer nor me coming to down to help in the kitchen will work, but a million thanks anyway. Jan
On 6/29/06, Jan Galinski <[email protected]> wrote:
Jérémi, you are my hero!
can you try to add : ?useServerPrepStmts=false at the end of your connection url in hibernate.cfg.xml
I tried and it works.
It's a problem with ubuntu, i don't know why.
Me neither, but now that it works ... I will move the DB from my local system to a debian sarge server in a few weeks, maybe than no more fixes are required.
Until then: I owe you. I suppose you are from France? I am sitting in Hamburg, Germany so neither you coming around for a beer nor me coming to down to help in the kitchen will work, but a million thanks anyway.
Thanks, you're welcome. I'm french, but i'm in china until the begining of september. Ok for the beer, German beer is really better than chinese one ;-) -- jeremi
participants (3)
-
Jan Galinski -
jeremi joslin -
Srinivasa Pulugurtha