|Title|Could not commit transaction: Can't call commit when autocommit=true with jspwiki.userdatabase =com.ecyrd.jspwiki.auth.user.JDBCUserDatabase
|Date|03-Jul-2007 02:41:07 EEST
|Version|JSPWiki v2.4.102
|Submitter|85.102.153.115
|[Bug criticality]|CriticalBug
|Browser version|firefox
|[Bug status]|WontFixBug
|[PageProvider] used|jspwiki.pageProvider =VersioningFileProvider
|Servlet Container|Tomcat 5.0.28
|Operating System|fedora 7 x86_64
|URL|
|Java version|1.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 StandardWrapperValve[jsp]: 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