异常求助200分，在线等。

[blackdreamzg]

javax.servlet.ServletException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
cn.zg.filter.EncodingFilter.doFilter(EncodingFilter.java:35)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)


root cause

org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:606)
org.springframework.transaction.support.AbstractPlatformTransactionManager.doRollbackOnCommitException(AbstractPlatformTransactionManager.java:633)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:528)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:473)
org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:267)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
$Proxy8.login(Unknown Source)
cn.zg.action.ShaolinAdminAction.login(ShaolinAdminAction.java:40)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
cn.zg.filter.EncodingFilter.doFilter(EncodingFilter.java:35)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

[blackdreamzg]

那行我查了，没有问题，本地运行都没有问题，在服务器上运行一阵子之后会出现这个问题。
感觉与spring的hibernate事务管理有关系。但不知道问题在那里。

[blackdreamzg]

贴哪层的代码？

[interpb]

这个事务所在的代码

[blackdreamzg]

贴一个流程登陆的吧
================action======================
public class ShaolinAdminAction extends DispatchAction {

private ShaolinAdminManagerI manager = null;

public void setShaolinAdminManagerI(ShaolinAdminManagerI manager) {
this.manager = manager;
}
public ActionForward login(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
ActionMessages errors = new ActionMessages();
DynaValidatorForm df = (DynaValidatorForm) form;
String userName = df.getString("userName");
String password = df.getString("password");
String login = manager.login(userName, password, request
.getRemoteAddr());
if (StringUtils.isNotEmpty(login)) {
request.getSession().setAttribute("ADMIN_NAME", login);
return mapping.findForward(SUCCESS);
} else {
errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage(
"errors.login"));
saveErrors(request, errors);
return mapping.getInputForward();
}
}
}
====================对应的配置文件====================
<bean name="/login" class="cn.zg.action.ShaolinAdminAction"
singleton="false">
<property name="shaolinAdminManagerI">
<ref bean="shaolinAdminManager" />
</property>
</bean>

======================service===========================
public class ShaolinAdminManager extends BaseManager implements
ShaolinAdminManagerI {

protected ShaolinAdminDAOI dao;

public void setShaolinAdminDAOI(ShaolinAdminDAOI dao) {
this.dao = dao;
}

public String login(String userName, String password, String ip) {
ShaolinAdmin shaolinAdmin = dao.login(userName, password, ip);
if (shaolinAdmin != null) {
dao.updateObject(shaolinAdmin);
return shaolinAdmin.getAdminName();
}
return null;
}
}
===================dao======================
public class ShaolinAdminDAO extends BaseDAO implements ShaolinAdminDAOI {

public ShaolinAdmin login(String userName, String password, String ip) {
String hql = "select obj from ShaolinAdmin obj where obj.adminName='"
+ userName + "' and obj.adminPass='" + password + "'";
List l = getObjects(hql, 0, 1);
if (l != null && l.size() > 0) {
ShaolinAdmin shaolinAdmin = (ShaolinAdmin) l.get(0);
shaolinAdmin.setLastLogin(new Date());
shaolinAdmin.setLastIp(ip);
return shaolinAdmin;
}
return null;
}
}

[treeroot]

up

[blackdreamzg]

/*
*@作者：赵刚 2006-6-14
*/
package cn.zg.dao.impl;

import java.io.Serializable;
import java.util.List;

import org.hibernate.Query;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import cn.zg.dao.BaseDAOI;

public class BaseDAO extends HibernateDaoSupport implements BaseDAOI {
protected int count = 0;

public void setCount(String hql) {
Query query = getHibernateTemplate().getSessionFactory().openSession()
.createQuery(hql);
this.count = Integer.parseInt(query.uniqueResult().toString());
}

public List getObjects(String hql, int start, int range) {
Query query = getHibernateTemplate().getSessionFactory().openSession()
.createQuery(hql);
query.setFirstResult(start);
if (range > 0) {
query.setMaxResults(range);
}
return query.list();
}

public Integer saveObject(Object o) {
Integer i = (Integer) getHibernateTemplate().save(o);
System.out.println(i);
//getSession().beginTransaction().commit();
return i;
}

public void removeObject(Object o) {
getHibernateTemplate().delete(o);
}

public void updateObject(Object o) {
getHibernateTemplate().update(o);
}

public Object getObject(Class clazz, Serializable id) {
return getHibernateTemplate().load(clazz, id, null);
}

public int getCount() {
return this.count;
}

}

[洪泉]

cn.zg.action.ShaolinAdminAction.login(ShaolinAdminAction.java:40)

[blackdreamzg]

<bean id="mySessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="configLocation">
<value>classpath:/hibernate.cfg.xml</value>
</property>
</bean>

<!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
<bean id="myTransactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="mySessionFactory" />
</property>
</bean>

[blackdreamzg]

up

[blackdreamzg]

跟数据库的设置有关希吗？

[rickhunterchen]

你用的什么数据库，什么服务器？

[blackdreamzg]

linux mysql innodb

[interpb]

数据库操作过程中, 建议打印调试信息

[blackdreamzg]

楼上的能说的再详细一些吗？谢谢。

[blackdreamzg]

up

[rickhunterchen]

可能跟服务器有关，因为你本地没事。

[quanquan626]

up

[aywrenyue]

学习

[zhmt]

up!

mark!

[yqj2065]

帮顶