<b><u>Please help to resolve this error</u></b>


org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [Can't call commit when autocommit=true]; nested exception is java.sql.SQLException: Can't call commit when autocommit=true
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:94)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:281)
org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:249)
org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:231)
org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:233)
org.springframework.orm.hibernate.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:387)
com.simpleapp.book.BooksFacade.saveBook(BooksFacade.java:24)
com.simpleapp.web.InsertBookSubmitController.onSubmit(InsertBookSubmitController.java:46)
org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:297)
org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:272)
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:223)
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:237)
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:532)
org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:366)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:326)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

<hr color="yellow">
<b><u>This is the simpleapp-servlet.xml file</u></b>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>

<bean id="firstController" class="com.simpleapp.web.FirstController"/>
<bean id="insertBookFormController" class="com.simpleapp.web.InsertBookFormController"/>
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost/test</value>
</property>
<property name="username">
<value>root</value>
</property>
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="mappingResources">
<value>com/simpleapp/book/Books.hbm.xml</value>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
net.sf.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>


<bean id="booksService" class="com.simpleapp.book.BooksFacade">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>

<bean id="booksValidator" class="com.simpleapp.book.BooksValidator"/>

<bean id="insertBookSubmitController" class="com.simpleapp.web.InsertBookSubmitController">
<property name="sessionForm"><value>true</value></property>
<property name="commandName"><value>book</value></property>
<property name="commandClass"><value>com.simpleapp.book.Books</value></property>
<property name="validator"><ref bean="booksValidator"/></property>
<property name="formView"><value>insertForm</value></property>
<property name="successView"><value>insertSuccess.html</value></property>
<property name="facade"><ref local="booksService"/></property>
</bean>

<bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">
<property name="basename"><value>messages</value></property>
</bean>

<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<property name="mappings">
<props>
<prop key="/index.html">firstController</prop>
<prop key="/insertForm.html">insertBookFormController</prop>
<prop key="/insertSuccess.html">insertBookSubmitController</prop>
</props>
</property>
</bean>

<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property>
<property name="prefix"><value>/WEB-INF/jsp/</value></property>
<property name="suffix"><value>.jsp</value></property>
</bean>

</beans>

have you tried to set the hibernate.connection.autocommit property to false?

Ivan

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost/test</value>
</property>
<property name="username">
<value>root</value>
</property>
</bean>

I changed that to

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost/test?relaxAutoCommit=true</value>
</property>
<property name="username">
<value>root</value>
</property>
</bean>