TitleCould not commit transaction: Can't call commit when autocommit=true with jspwiki.userdatabase =com.ecyrd.jspwiki.auth.user.JDBCUserDatabase
Date03-Jul-2007 02:41:07 EEST
VersionJSPWiki v2.4.102
Submitter85.102.153.115
Bug criticalityCriticalBug
Browser versionfirefox
Bug statusWontFixBug
PageProvider usedjspwiki.pageProvider =VersioningFileProvider
Servlet ContainerTomcat 5.0.28
Operating Systemfedora 7 x86_64
URL
Java version1.5

very INSERT, UPDATE action related with jdbc user authentications (signup, Install.jsp) throws below exception, however records are inserted in db . below db schema is used.


CREATE TABLE `users` ( `email` varchar(100) character set latin1 default NULL, `full_name` varchar(100) character set latin1 default NULL, `login_name` varchar(100) character set latin1 NOT NULL, `password` varchar(100) character set latin1 default NULL, `wiki_name` varchar(100) character set latin1 default NULL, `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `modified` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`login_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `role` ( `login_name` varchar(100) character set latin1 NOT NULL, `role` varchar(100) character set latin1 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8


2007-07-03 02:23:27 StandardWrapperValvejsp: Servlet.service() for servlet jsp threw exception com.ecyrd.jspwiki.auth.WikiSecurityException: Could not commit transaction: Can't call commit when autocommit=true at com.ecyrd.jspwiki.auth.user.JDBCUserDatabase.commit(JDBCUserDatabase.java:232) at com.ecyrd.jspwiki.ui.Installer.createAdministrator(Installer.java:135) at org.apache.jsp.Install_jsp._jspService(Install_jsp.java:100) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.ecyrd.jspwiki.ui.WikiServletFilter.doFilter(WikiServletFilter.java:100) at com.ecyrd.jspwiki.ui.WikiJSPFilter.doFilter(WikiJSPFilter.java:82) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:595)


best regards, rustam bogubaev


Could you please use http://bugs.jspwiki.org for filing these reports? That allows us to do proper bug tracking and assignment...

--JanneJalkanen, 03-Jul-2007

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-3) was last changed on 19-Feb-2008 14:16 by HarryMetske