Can't insert data using HibernateTemplate?

[liren]

Hi everyone:

I come across a odd problem. I want to save a record in databse using this code:

public String insertObject(Object o){
    	return (String)this.getHibernateTemplate().save(o);
    	
    }

Spring report error:

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:181)
	org.springframework.orm.hibernate.HibernateTemplate.save(HibernateTemplate.java:298)
	lyo.hotmail.site.service.ForumDAOImpl.insertObject(ForumDAOImpl.java:57)
	lyo.hotmail.site.action.PostArticleController.handleRequest(PostArticleController.java:57)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:495)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:321)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

I use MySQL4.01. InnoDB.
Why this exception happen? Thks!

[liren]

If I change code to this:

 public String insertObject(Object o){
    	//don't work why? :(
    	//return (String)this.getHibernateTemplate().save(o);
    	Session s=SessionFactoryUtils.getSession(this.getSessionFactory(),false);
    	String obj_id=null;
    	try{
    		obj_id=(String)s.save(o);
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	return obj_id;
    }

It report exception:

java.lang.IllegalStateException: No Hibernate session bound to thread, and configuration does not allow creation of new one here
	org.springframework.orm.hibernate.SessionFactoryUtils.getSession(SessionFactoryUtils.java:320)
	org.springframework.orm.hibernate.SessionFactoryUtils.getSession(SessionFactoryUtils.java:182)
	lyo.hotmail.site.service.ForumDAOImpl.insertObject(ForumDAOImpl.java:61)
	lyo.hotmail.site.action.PostArticleController.handleRequest(PostArticleController.java:59)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:495)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:321)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

Why there isn't a session in current thread?

[irbouho]

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

try to turn autoCommit off in your datasource configuration.

HTH

[liren]

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

try to turn autoCommit off in your datasource configuration.

HTH

Thks for your reply.But it seems don't work too .

My config file change to this:

<bean id="MySessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
   <property name="mappingResources">
      <list>
        <value>lyo/hotmail/site/bean/Article.hbm.xml</value>
        <value>lyo/hotmail/site/bean/Forum.hbm.xml</value>
        <value>lyo/hotmail/site/bean/Message.hbm.xml</value>
        <value>lyo/hotmail/site/bean/User.hbm.xml</value>
        <value>lyo/hotmail/site/bean/UserDetail.hbm.xml</value>
      </list>
   </property>
   <property name="hibernateProperties">
      <props>
        <prop key="hibernate.dialect">net.sf.hibernate.dialect.MySQLDialect</prop>
        <prop key="hibernate.query.substitutions">true=1 false=0</prop>
        <prop key="hibernate.show_sql">true</prop>
        <prop key="hibernate.use_outer_join">false</prop>
		<prop key="hibernate.autocommit">false</prop>
      </props>
   </property>
   <property name="dataSource"><ref bean="MyDataSource"/></property>
</bean>

It also report the same exception. why?

[irbouho]

liren,

Could you set autoCommit to false at your dataSource bean definition instead of HibernateLocalSessionDefinition?

[liren]

I try it . But it don't work:

<bean id="MyDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <!-- results in a setDriverClassName&#40;String&#41; call -->
        <property name="driverClassName">
            <value>com.mysql.jdbc.Driver</value>
        </property>
        <property name="url">
            <value>jdbc&#58;mysql&#58;//127.0.0.1&#58;3306/Hibernate</value>
        </property>
        <property name="username">
            <value>root</value>
        </property>
		<property name="password">
            <value></value>
        </property>
		<property name="autoCommit">
            <value>false</value>
        </property>
		
    </bean>

Spring report error:

07:26:53,981  INFO DefaultListableBeanFactory:409 - Destroying singletons in fac
tory {org.springframework.beans.factory.support.DefaultListableBeanFactory defin
ing beans [MyDataSource,MySessionFactory,fproxy,viewSpringForumController,rewrit
eURLController,postArticleController,urlMapping,viewResolver,formDao]; Root of B
eanFactory hierarchy}
07:26:53,981 ERROR DispatcherServlet:208 - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'MyDataSource' defined in resource [/WEB-INF/springmodal-servlet.xml] of
ServletContext: Error setting property values; nested exception is org.springfra
mework.beans.NotWritablePropertyException: Invalid property 'autoCommit' of bean
 class [org.apache.commons.dbcp.BasicDataSource]: Property 'autoCommit' is not w
ritable
org.springframework.beans.NotWritablePropertyException: Invalid property 'autoCo
mmit' of bean class [org.apache.commons.dbcp.BasicDataSource]: Property 'autoCom
mit' is not writable
        at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrappe
rImpl.java:666)
        at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrappe
rImpl.java:588)
        at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrappe
rImpl.java:720)
        at org.springframework.beans.BeanWrapperImpl.setPropertyValues(BeanWrapp
.....................................................................................
...............................................................

This bean don't has this option?

[irbouho]

I am sorry for the confusion

<property name="defaultAutoCommit">
  <value>false</value>
</property>

I can see from the log that you did not configure any transaction management for your DAOs, did you? basically, HibernateTransactionManager should set autoCommit to false.

[liren]

Thks. It would work if I change my code to this:

public Object insertObject(Object o){
                
    	return this.getHibernateTemplate().save(o);		
    }

It doesn't work!
It means that should I have to use the more complex code in MySQL database?

How to make this code "return this.getHibernateTemplate().save(o);" work property? I mean that if I want to use the later code how to do it?