Hibernate 和 Tomcat的问题

xharry 2007-12-09 04:07:36
我用MyEclipse加入Hibernate的支持，MyEclipse会自动加入一段代码，如下：

----
package com.amd;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html }.
*/
public class HibernateSessionFactory {

/**
* Location of hibernate.cfg.xml file.
* Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file.
* The default classpath location of the hibernate config file is
* in the default package. Use #setConfigFile() to update
* the location of the configuration file for the current session.
*/
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;

static {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}

/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();

if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}

return session;
}

/**
* Rebuild hibernate session factory
*
*/
public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}

/**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);

if (session != null) {
session.close();
}
}

/**
* return session factory
*
*/
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}

/**
* return session factory
*
* session factory will be rebuilded in the next call
*/
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}

/**
* return hibernate configuration
*
*/
public static Configuration getConfiguration() {
return configuration;
}

}
-----


然后我写了一个类用来读取数据如下

---
package com.amd;

import java.util.*;
import java.io.*;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class BizB {
public ArrayList test() {
ArrayList l = new ArrayList();

SessionFactory sessionFactory = HibernateSessionFactory
.getSessionFactory();
Session s = sessionFactory.openSession();
Transaction tx = s.beginTransaction();
try {

Query q = s.createQuery("from com.amd.User");

tx.commit();

for (int i=0; i<q.list().size(); ++i)
{
User user = (User) q.list().get(i);
l.add(user.getName());
}


} catch (HibernateException e) {
e.printStackTrace();
tx.rollback();
} finally {
s.close();
}

return l;
}
}

---

在jsp页面中，我这么调用

<%
BizB foo1 = new BizB();
ArrayList bar1 = foo1.test();

for (int i = 0; i < bar1.size(); ++i) {
out.println(bar1.get(i));
}


%>


问题是，刚部署好，一切正常，过了很长时间后，就不起作用了，比如我昨天部署的，今天访问一下页面，发现不行了


，有人遇到过类似的问题么？？？
...全文
144 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
yilinhust 2007-12-16
  • 打赏
  • 举报
 回复
for (int i=0; i <q.list().size(); ++i)
{
User user = (User)q.list().get(i);
l.add(user.getName());
}

Query的list()方法执行查询,这段代码查询了很多次吧

不是告诉你出错在 at com.amd.BizB.test(BizB.java:27)这行代码了么?
yuanpolo 2007-12-16
  • 打赏
  • 举报
 回复
有可能是Hibernate-config.xml里面的问题!它里有好像有个什么属性可能有设置的!你查查相关资料吧!
xharry 2007-12-16
  • 打赏
  • 举报
 回复
大概就是Socket出错，有遇到的朋友么
xharry 2007-12-15
  • 打赏
  • 举报
 回复
错误代码如下



STACKTRACE:



java.sql.SQLException: Communication link failure: java.net.SocketTimeoutException, underlying cause: Read timed out



** BEGIN NESTED EXCEPTION ** 



java.net.SocketTimeoutException

MESSAGE: Read timed out



STACKTRACE:



java.net.SocketTimeoutException: Read timed out

	at java.net.SocketInputStream.socketRead0(Native Method)

	at java.net.SocketInputStream.read(Unknown Source)

	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1392)

	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1539)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930)

	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)

	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)

	at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)

	at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)

	at com.mysql.jdbc.Connection.execSQL(Connection.java:2237)

	at com.mysql.jdbc.Connection.execSQL(Connection.java:2218)

	at com.mysql.jdbc.Connection.commit(Connection.java:1155)

	at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)

	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)

	at com.amd.BizB.test(BizB.java:27)

	at org.apache.jsp.index_jsp._jspService(index_jsp.java:109)

	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)

	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)

	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)

	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

	at java.lang.Thread.run(Unknown Source)





** END NESTED EXCEPTION **





	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1714)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930)

	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)

	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)

	at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)

	at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)

	at com.mysql.jdbc.Connection.execSQL(Connection.java:2237)

	at com.mysql.jdbc.Connection.execSQL(Connection.java:2218)

	at com.mysql.jdbc.Connection.commit(Connection.java:1155)

	at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)

	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)

	at com.amd.BizB.test(BizB.java:27)

	at org.apache.jsp.index_jsp._jspService(index_jsp.java:109)

	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)

	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)

	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)

	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

	at java.lang.Thread.run(Unknown Source)





** END NESTED EXCEPTION **





	at com.mysql.jdbc.Connection.checkClosed(Connection.java:2508)

	at com.mysql.jdbc.Connection.commit(Connection.java:1147)

xharry 2007-12-10
  • 打赏
  • 举报
 回复
sorry, 很久没有贴代码了，当时没有发现有这个功能，后来我想改，发现改自己发的帖子也需要权限，我暂时没有权限改，晕
FredWorks 2007-12-09
  • 打赏
  • 举报
 回复
这种情况一般都是数据库连接泄漏造成的。你检查一下你使用session的代码，最后操作结束或者出现异常的时候有没有关闭session。从你贴出来的这段代码看来，好像sesion是关掉了。你检查一下其他类似的地方。

还有，你的q.list()不应该放在for循环的里面，应该拿到for循环的外面。

最后，论坛是提供了贴代码的功能的，你为什么不用呢？你现在贴出来的代码好乱，都看不清楚...
xharry 2007-12-09
  • 打赏
  • 举报
 回复
那个jsp页面什么错误都不报，只是不打印东西出来而已，但是该jsp的其他部分都是正常的
xharry 2007-12-09
  • 打赏
  • 举报
 回复
我还没有把log4j加入project中，所以现在看不到，我稍后会加入的，不知道有人是否遇到类似的问题
洪泉 2007-12-09
  • 打赏
  • 举报
 回复
那是报的什么错啊？
xharry 2007-12-09
  • 打赏
  • 举报
 回复
只要重启了，就会正常，也就是说能从数据库里面取到值
hibernate 3.1＋tomcat 5.5.x(配置jndi)
hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)hibernate 3.1＋tomcat 5.5.x(配置jndi)
Hibernate使用Tomcat连接池.doc
Hibernate使用Tomcat连接池.doc
Struts+Hibernate+MyEclipse+Tomcat+MySQL的乱码之解决篇
Struts Hibernate MyEclipse Tomcat MySQL JSP 乱码 编码出错 内码设定
Tomcat配置hibernate xml模板
Tomcat配置hibernate xml模板 Tomcat配置hibernate xml模板
Tomcat下配置Hibernate
Tomcat下配置Hibernate,供大家参考...
Java EE

67,513

社区成员

225,878

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章