17008oracle,hibernate - JDBCExceptionReporter-SQL错误：17008，SQLState：08003 - 堆栈内存溢出...

我在获取记录和零星记录时遇到错误，它可以通过重新启动服务器或在一段时间后自行修复。 我正在使用Struts 2，Oracle 11g，Hibernate 3。

错误

2014-05-06 13:38:51 WARN JDBCExceptionReporter:100 - SQL Error: 17002, SQLState: 08006

2014-05-06 13:38:51 ERROR JDBCExceptionReporter:101 - IO Error: Connection timed out

2014-05-06 13:38:51 ERROR Dispatcher:38 - Exception occurred during processing request: null

java.lang.NullPointerException

at com.tai.dao.UsersTaiImplDAO.listUser(UsersTaiImplDAO.java:37)

at com.tai.web.UsersTaiAction.userLogin(UsersTaiAction.java:55)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)

at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

at

C3P0属性

4

100

20

0

10

300

1000

65

false

8

1

码

public List listUser(String userName, String password) {

_logger.debug("listUser");

List usersTai = null;

String name= userName.substring(userName.indexOf('@')).trim();

try {

Session session = HibernateUtil.getSessionFactory().getCurrentSession();

session.beginTransaction();

usersTai = session.createQuery("from UsersTai where username='" + userName +"' or username= '"+name + "' and USERPASSWORD='"+ password +"'").list();

session.getTransaction().commit();