No data inserted when I use transaction [Archive]

liren

Jan 19th, 2005, 10:28 AM

Hi everyone:

I want to use HibernateTransaction in Spring. But it couldn't insert data into database.
my config file is:

<bean id="MyDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://127.0.0.1:3306/Hibernate?useUnicode=true&characterEncoding=gb2312</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>root</value>
</property>

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

</bean>

<bean id="MySessionFactory" class="org.springframework.orm.hibernate.LocalSessionFact oryBean">
<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>
</props>
</property>
<property name="dataSource"><ref bean="MyDataSource"/></property>
</bean>

<bean id="fproxy" class="lyo.hotmail.site.util.ForumProxy">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="viewSpringForumController" class="lyo.hotmail.site.action.ViewForumcontroller">
<property name="forumProxy">
<ref bean="fproxy"/>
</property>
</bean>
<bean id="rewriteURLController" class="lyo.hotmail.site.action.DispatchForumController">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="postArticleController" class="lyo.hotmail.site.action.PostArticleController">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="viewDetailController" class="lyo.hotmail.site.action.viewDetailController">
<property name="forumProxy">
<ref bean="fproxy"/>
</property>
</bean>
<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlH andlerMapping">
<property name="mappings">
<props>
<prop key="/oldForum.spring">viewSpringForumController</prop>
<prop key="/viewForum.spring">viewSpringForumController</prop>
<prop key="/detail.spring">viewDetailController</prop>
<prop key="/newPost.spring">rewriteURLController</prop>
<prop key="/post.spring">postArticleController</prop>
</props>
</property>

</bean>

<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResou rceViewResolver">
<property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property>
<property name="prefix"><value>/WEB-INF/forum/</value></property>
<property name="suffix"><value>.jsp</value></property>
</bean>
<bean id="formDao" class="lyo.hotmail.site.service.ForumDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
<property name="udao">
<ref bean="userDao"/>
</property>
</bean>
<bean id="userDao" class="lyo.hotmail.site.service.UserDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
</bean>
<bean id="msgDao" class="lyo.hotmail.site.service.MessageDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
<property name="messageDao">
<ref bean="msgDao"/>
</property>
</bean>

<bean id="myTransactionManager" class="org.springframework.orm.hibernate.HibernateTransac tionManager">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
</bean>
<bean id="myTransactionInterceptor" class="org.springframework.transaction.interceptor.Transa ctionInterceptor">
<property name="transactionManager">
<ref bean="myTransactionManager"/>
</property>
<property name="transactionAttributeSource">
<value>
lyo.hotmail.site.service.MessageDAOImpl.sendMsgTra nsaction=PROPAGATION_MANDATORY
</value>
</property>
</bean>

<bean id="myProductService" class="org.springframework.aop.framework.ProxyFactoryBean">
<property name="proxyInterfaces">
<value>lyo.hotmail.site.dao.MessageDAO</value>
</property>
<property name="interceptorNames">
<value>myTransactionInterceptor,msgDao</value>
</property>
</bean>

If I set :

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

Spring will report error:

Can't call commit when autoCommit is true.

So I set autoCommit to false(I don't know why ;-( ).

My class is:

public class MessageDAOImpl extends HibernateDaoSupport implements MessageDAO {
.................................................. ....................................
public boolean sendMsg(final Message msg,final Long userID) {
HibernateTemplate hibernateTemplate = new HibernateTemplate(this.getSessionFactory());
User user= (User) hibernateTemplate.execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
User user=(User)session.get(User.class,userID);
msg.setUser(user);
Set msgSet=user.getMessageSet();
if(null!=msgSet){
msgSet.add(msg);
}else{
msgSet=new HashSet();
msgSet.add(msg);
}
user.setMessageSet(msgSet);
session.update(user);
return null;
}
});

return true;
}

/***
* send message transaction */
public boolean sendMsgTransaction(final Message msg,final Long userID){
this.getMessageDao().sendMsg(msg,userID);
return true;
}
.................................................. .........................

MessageDao class:

public interface MessageDAO {
.................................................. ................................ public boolean sendMsg(Message msg,Long userID);
public boolean sendMsg(Message msg,String userName);
public boolean sendMsgTransaction(final Message msg,final Long userID);

}

When I run it in Tomcat ,console output :

.................................................. .....................
00:08:36,313 INFO SettingsFactory:103 - Use scrollable result sets: true
00:08:36,323 INFO SettingsFactory:106 - Use JDBC3 getGeneratedKeys(): true
00:08:36,323 INFO SettingsFactory:109 - Optimize cache for minimal puts: false
00:08:36,323 INFO SettingsFactory:115 - echoing all SQL to stdout
00:08:36,323 INFO SettingsFactory:118 - Query language substitutions: {no='N',
true=1, yes='Y', false=0}
00:08:36,323 INFO SettingsFactory:129 - cache provider: net.sf.hibernate.cache.
EhCacheProvider
00:08:36,323 INFO Configuration:1116 - instantiating and configuring caches
00:08:36,323 INFO SessionFactoryImpl:118 - building session factory
00:08:36,403 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI,
no JNDI name configured
00:08:46,587 INFO PropertyMessageResources:127 - Initializing, config='org.apac
he.struts.actions.LocalStrings', returnNull=true
00:08:46,607 INFO SQLErrorCodesFactory:197 - Looking up default SQLErrorCodes f
or DataSource
00:08:46,607 INFO SQLErrorCodesFactory:202 - Database product name found in cac
he for DataSource [org.apache.commons.dbcp.BasicDataSource@130c13 2]. Name is 'My
SQL'.
Hibernate: select user0_.USER_ID as USER_ID0_, user0_.USER_GRADE as USER_GRADE0_
, user0_.USER_NAME as USER_NAME0_, user0_.USER_PASSWORD as USER_PAS4_0_ from use
r user0_ where user0_.USER_ID=?
Hibernate: select messageset0_.USER_ID as USER_ID__, messageset0_.MESSAGE_ID as
MESSAGE_ID__, messageset0_.MESSAGE_ID as MESSAGE_ID0_, messageset0_.MESSAGE_CONT
ENT as MESSAGE_2_0_, messageset0_.MESSAGE_TITLE as MESSAGE_3_0_, messageset0_.SE
ND_TIME as SEND_TIME0_, messageset0_.SENDER as SENDER0_, messageset0_.USER_ID as
USER_ID0_ from message messageset0_ where messageset0_.USER_ID=?
Hibernate: insert into message (MESSAGE_CONTENT, MESSAGE_TITLE, SEND_TIME, SENDE
R, USER_ID, MESSAGE_ID) values (?, ?, ?, ?, ?, ?)

Not any exception happen,But no data inserted ! Why spring couldn't insert data into database? Thks

irbouho

Jan 19th, 2005, 11:58 PM

<bean id="myProductService" class="org.springframework.aop.framework.ProxyFactoryBean">
<property name="proxyInterfaces">
<value>lyo.hotmail.site.dao.MessageDAO</value>
</property>
<property name="interceptorNames">
<value>myTransactionInterceptor,msgDao</value>
</property>
</bean>
This declaration apply transaction demarcation to bean msgDao . However, I do not see where ou are using bean myProductService!!

<bean id="msgDao" class="lyo.hotmail.site.service.MessageDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
<property name="messageDao">
<ref bean="msgDao"/>
</property>
</bean>
Are you sure this declaration is correct?
HTH

liren

Jan 21st, 2005, 06:52 PM

Thank you for your reply.
I change the config file to the following,but it also can't insert data to database. :(

<?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="MyDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://127.0.0.1:3306/Hibernate?useUnicode=true&characterEncoding=gb2312</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>root</value>
</property>

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

</bean>

<bean id="MySessionFactory" class="org.springframework.orm.hibernate.LocalSessionFact oryBean">
<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>
</props>
</property>
<property name="dataSource"><ref bean="MyDataSource"/></property>
</bean>

<bean id="fproxy" class="lyo.hotmail.site.util.ForumProxy">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="viewSpringForumController" class="lyo.hotmail.site.action.ViewForumcontroller">
<property name="forumProxy">
<ref bean="fproxy"/>
</property>
</bean>
<bean id="rewriteURLController" class="lyo.hotmail.site.action.DispatchForumController">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="postArticleController" class="lyo.hotmail.site.action.PostArticleController">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="viewDetailController" class="lyo.hotmail.site.action.viewDetailController">
<property name="forumProxy">
<ref bean="fproxy"/>
</property>
</bean>
<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlH andlerMapping">
<property name="mappings">
<props>
<prop key="/oldForum.spring">viewSpringForumController</prop>
<prop key="/viewForum.spring">viewSpringForumController</prop>
<prop key="/detail.spring">viewDetailController</prop>
<prop key="/newPost.spring">rewriteURLController</prop>
<prop key="/post.spring">postArticleController</prop>
</props>
</property>

</bean>

<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResou rceViewResolver">
<property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property>
<property name="prefix"><value>/WEB-INF/forum/</value></property>
<property name="suffix"><value>.jsp</value></property>
</bean>
<bean id="formDao" class="lyo.hotmail.site.service.ForumDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
<property name="udao">
<ref bean="userDao"/>
</property>
</bean>
<bean id="userDao" class="lyo.hotmail.site.service.UserDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
</bean>
<bean id="msgDao" class="lyo.hotmail.site.service.MessageDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>

</bean>

<bean id="myTransactionManager" class="org.springframework.orm.hibernate.HibernateTransac tionManager">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
</bean>
<bean id="proxyService" class="org.springframework.transaction.interceptor.Transa ctionProxyFactoryBean">
<property name="transactionManager">
<ref bean="myTransactionManager"/>
</property>
<property name="target">
<ref local="msgDao"/>
</property>
<property name="transactionAttributes">

<props>

<prop key="sendMsg">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>

</property>
</bean>

</beans>

Why?

irbouho

Jan 21st, 2005, 10:06 PM

The controllers reference base dao classes. These daos do not use transactions, so no data will be persisted into the database since autocommit is set to false.
You need to reference a bean that is wrapped within / uses transactions. For example:

<bean id="viewDetailController" class="lyo.hotmail.site.action.viewDetailController">
<property name="proxyService">
<ref bean="proxyService"/>
</property>
</bean>
For more informations on using declarative transaction demarcation with Spring, please take a look at Chapter 7. Transaction management (http://www.springframework.org/docs/reference/transaction.html).
HTH.

liren

Jan 22nd, 2005, 12:10 AM

The controllers reference base dao classes. These daos do not use transactions, so no data will be persisted into the database since autocommit is set to false.
You need to reference a bean that is wrapped within / uses transactions. For example:

<bean id="viewDetailController" class="lyo.hotmail.site.action.viewDetailController">
<property name="proxyService">
<ref bean="proxyService"/>
</property>
</bean>
For more informations on using declarative transaction demarcation with Spring, please take a look at Chapter 7. Transaction management (http://www.springframework.org/docs/reference/transaction.html).
HTH.

But I don't use this dao in viewDetailController servlet. I use it in my struts Action. This Action is :

public final class DoMsgAction extends DispatchActionSupport {

/* send message * @see org.apache.struts.action.Action#execute(org.apache .struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
*/
public ActionForward send(ActionMapping arg0, ActionForm arg1,
HttpServletRequest arg2, HttpServletResponse arg3) throws Exception {
Message msg=new Message();
BeanUtils.copyProperties(msg,arg1);
msg.setSendTime(new java.util.Date());
HttpSession s=arg2.getSession();
User user=(User)s.getAttribute("user");
String username=user.getUserName();
msg.setSender(username);
String senderID=arg2.getParameter("senderID");
MessageDAO msgDao=(MessageDAO)this.getWebApplicationContext() .getBean("msgDao");
msgDao.sendMsg(msg,new Long(senderID));
return arg0.findForward("AfterSend");
}
.................................................. ...........................
}

The DispatchActionSupport is in the

org.springframework.web.struts.DispatchActionSuppo rt
How should I　　ｄｏ？

liren

Jan 22nd, 2005, 09:12 PM

I want to know whether I need have to use Spring Transaction if I "update" or "save" an Object.

I change my code to this. It also don't work :(

public class ForumDAOImpl extends HibernateDaoSupport implements ForumDAO {
.................................................. .........................................
public boolean insertArticle(final Article a,final User u) {

boolean obj_id = false;
User user=null;
Object o=null;
HibernateTemplate hibernateTemplate = new HibernateTemplate(this.getSessionFactory());
Boolean isup= (Boolean) hibernateTemplate.execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
Object o=null;
User user=null;
o = session.createQuery(
"from User u where u.userName='" + u.getUserName() + "'").uniqueResult();
if(null!=o){
log.info("Get o: "+o);
user=(User)o;
}
a.setUser(user);
Set articleSet=user.getArticleSet();

if(null!=articleSet){
articleSet.add(a);
}else{
articleSet=new HashSet();
articleSet.add(a);
}
user.setArticleSet(articleSet);

session.update(user);

return new Boolean(true);
}
});

return true;

}
..................... other methods ...................................
}

Config file change to this:

<?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="MyDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://127.0.0.1:3306/Hibernate?useUnicode=true&characterEncoding=gb2312</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>root</value>
</property>

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

</bean>

<bean id="MySessionFactory" class="org.springframework.orm.hibernate.LocalSessionFact oryBean">
<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>
</props>
</property>
<property name="dataSource"><ref bean="MyDataSource"/></property>
</bean>

<bean id="fproxy" class="lyo.hotmail.site.util.ForumProxy">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="viewSpringForumController" class="lyo.hotmail.site.action.ViewForumcontroller">
<property name="forumProxy">
<ref bean="fproxy"/>
</property>
</bean>
<bean id="rewriteURLController" class="lyo.hotmail.site.action.DispatchForumController">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="postArticleController" class="lyo.hotmail.site.action.PostArticleController">
<property name="fdao">
<ref bean="formDao"/>
</property>
</bean>
<bean id="viewDetailController" class="lyo.hotmail.site.action.viewDetailController">
<property name="forumProxy">
<ref bean="fproxy"/>
</property>
</bean>
<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlH andlerMapping">
<property name="mappings">
<props>
<prop key="/oldForum.spring">viewSpringForumController</prop>
<prop key="/viewForum.spring">viewSpringForumController</prop>
<prop key="/detail.spring">viewDetailController</prop>
<prop key="/newPost.spring">rewriteURLController</prop>
<prop key="/post.spring">postArticleController</prop>
</props>
</property>

</bean>

<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResou rceViewResolver">
<property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property>
<property name="prefix"><value>/WEB-INF/forum/</value></property>
<property name="suffix"><value>.jsp</value></property>
</bean>
<bean id="formDao" class="lyo.hotmail.site.service.ForumDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
<property name="udao">
<ref bean="userDao"/>
</property>
</bean>
<bean id="userDao" class="lyo.hotmail.site.service.UserDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
</bean>
<bean id="msgDao" class="lyo.hotmail.site.service.MessageDAOImpl">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>

</bean>

<bean id="myTransactionManager" class="org.springframework.orm.hibernate.HibernateTransac tionManager">
<property name="sessionFactory">
<ref bean="MySessionFactory"/>
</property>
</bean>
<bean id="proxyService" class="org.springframework.transaction.interceptor.Transa ctionProxyFactoryBean">
<property name="transactionManager">
<ref bean="myTransactionManager"/>
</property>
<property name="target">
<ref local="msgDao"/>
</property>
<property name="target">
<ref local="formDao"/>
</property>
<property name="transactionAttributes">

<props>

<prop key="send*">PROPAGATION_REQUIRED</prop>
<prop key="insert*">PROPAGATION_REQUIRED</prop>
</props>

</property>
</bean>
</beans>

Tomcat output:

11:07:46,442 INFO SQLErrorCodesFactory:197 - Looking up default SQLErrorCodes f
or DataSource
11:07:46,893 INFO SQLErrorCodesFactory:202 - Database product name found in cac
he for DataSource [org.apache.commons.dbcp.BasicDataSource@129645 a]. Name is 'My
SQL'.
Hibernate: select user0_.USER_ID as USER_ID, user0_.USER_GRADE as USER_GRADE, us
er0_.USER_NAME as USER_NAME, user0_.USER_PASSWORD as USER_PAS4_ from user user0_
where (user0_.USER_NAME='li' )
11:07:47,474 INFO ForumDAOImpl:175 - Get o: lyo.hotmail.site.bean.User@104a681[
id=622594]
Hibernate: select articleset0_.USER_ID as USER_ID__, articleset0_.ARTICLE_ID as
ARTICLE_ID__, articleset0_.ARTICLE_ID as ARTICLE_ID0_, articleset0_.ARTICLE_ICON
as ARTICLE_2_0_, articleset0_.ARTICLE_TITLE as ARTICLE_3_0_, articleset0_.ARTIC
LE_TIME as ARTICLE_4_0_, articleset0_.ARTICLE_CONTENT as ARTICLE_5_0_, articlese
t0_.ARTICLE_VIEWTIMES as ARTICLE_6_0_, articleset0_.USER_ID as USER_ID0_, articl
eset0_.ART_ARTICLE_ID as ART_ARTI8_0_, articleset0_.FORUM_ID as FORUM_ID0_ from
article articleset0_ where articleset0_.USER_ID=?
Hibernate: select forum0_.FORUM_ID as FORUM_ID0_, forum0_.FORUM_NAME as FORUM_NA
ME0_, forum0_.FORUM_DESC as FORUM_DESC0_, forum0_.CREATE_DATE as CREATE_D4_0_ fr
om forum forum0_ where forum0_.FORUM_ID=?
Hibernate: insert into article (ARTICLE_TITLE, ARTICLE_TIME, ARTICLE_CONTENT, AR
TICLE_VIEWTIMES, USER_ID, ART_ARTICLE_ID, FORUM_ID, ARTICLE_ID) values (?, ?, ?,
?, ?, ?, ?, ?)
11:07:48,705 INFO PostArticleController:72 - Saving article : true

My action:

public class PostArticleController implements Controller {
private Log log=LogFactory.getLog(PostArticleController.class) ;

/**
* @return Returns the fdao.
*/
public ForumDAO getFdao() {
return fdao;
}
/**
* @param fdao The fdao to set.
*/
public void setFdao(ForumDAO fdao) {
this.fdao = fdao;
}
private ForumDAO fdao;
public ModelAndView handleRequest(HttpServletRequest arg0,
HttpServletResponse arg1) throws Exception {
String title=arg0.getParameter("title");
String content=arg0.getParameter("EditorDefault");
String parentID=arg0.getParameter("parentID");
log.info("get title: "+title);
log.info("get content:"+content);
Article article=new Article();
String fid=arg0.getParameter("fid");
Forum f=(Forum)this.getFdao().loadObjectByID(Forum.class ,Long.valueOf(fid));
article.setForum(f);
article.setArticleTitle(title);
if(null!=parentID&&!"".equals(parentID.trim())&&!"null".equals(parentID.trim())){
log.info("get parentID >>> "+parentID);
Article p_article=(Article)this.getFdao().loadObjectByID(A rticle.class,Long.valueOf(parentID));
article.setArtArticle(p_article);
}
article.setArticleContent(content);
article.setArticleTime(new Date());
HttpSession session=arg0.getSession();
User user=(User)session.getAttribute("user");
boolean article_id=fdao.insertArticle(article,user);
log.info("Saving article : "+article_id);
return new ModelAndView("wait","fid",fid);
}

}

But it couldn't insert data to database.Is there any mistake in my config file? :( [/code]

liren

Jan 28th, 2005, 08:41 PM

What's meaning of the following statement?

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

When should I set the value to true? THks :(