Jboss 下 Hibernate 的连接错误

最新推荐文章于 2021-01-19 20:37:16 发布
最新推荐文章于 2021-01-19 20:37:16 发布
阅读量206 收藏
点赞数
分类专栏： J2ee 文章标签： JBoss Hibernate Java Security UI

spring+hibernate的工程从tomcat5.5移植到JBoss4.2.2。

    spring  2.5.4

    hibernate 3.2

在tomcat下均正常。但是在JBoss下执行如下查询的时候出现错误：

 

 

   private final static SessionFactory sessionFactory;

   private static final ThreadLocal threadSession = new ThreadLocal();

   private static final ThreadLocal threadTransaction = new ThreadLocal();
   
   
   public static void beginTransaction() throws DaoException {
      Transaction tx = (Transaction) threadTransaction.get();
      try {
         if (tx == null) {
            tx = getSession(true).beginTransaction();
            threadTransaction.set(tx);
         }
      } catch (HibernateException ex) {
         log.error("Fail to begin transaction", ex);
         throw new DaoException("Fail to begin transaction", ex);
      }
   }
    

   public static Session getSession(boolean openSession) throws DaoException {
      Session s = (Session) threadSession.get();
      //if (openSession) {            //2008-12-17
      if ((openSession)&&(s==null)) {
    	  
         try {
            if (s == null) {
               s = sessionFactory.openSession();
               threadSession.set(s);
            }
         } catch (HibernateException ex) {
            log.error("Fail to open session", ex);
            throw new DaoException("Fail to open session", ex);
         }
      }
      return s;
   }
   
    public List findByCriterions(Class clazz, List restrictions)
      throws DaoException {
      List objs = new ArrayList();
      
      try {
         Session session = this.openSession();
         beginTransaction();
         Criteria criteria = session.createCriteria(clazz);
         Iterator it = restrictions.iterator();
         while (it.hasNext())
            criteria.add((Criterion) it.next());
         objs = criteria.list();
         if (autoCommit)
            commitTransaction();
      } catch (HibernateException ex) {
         rollbackTransaction();
         log.error("Fail to find objects by criterions", ex);
         throw new DaoException("Fail to find objects by criterions", ex);
      } finally {
         if (autoCloseSession)
            closeSession();
      }
      return objs;
   }

 

tx = getSession(true).beginTransaction();
 出错

 

错误信息如下： 

14:54:25,781 INFO  [CachedConnectionManager] Closing a connection for you.  Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@1a0df30
java.lang.Throwable: STACKTRACE
 at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
 at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
 at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
 at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
 at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
 at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
 at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
 at com.testprj.common.dao.HibernateSessionManager.beginTransaction(HibernateSessionManager.java:120)
 at com.testprj.common.dao.HibernateDaoImpl.beginTransaction(HibernateDaoImpl.java:149)
 at com.testprj.common.dao.HibernateDaoImpl.findByCriterions(HibernateDaoImpl.java:372)
 at com.testprj.persistence.ss.dao.hbmimpl.MenuDAOImpl.findByRowID(MenuDAOImpl.java:59)
 at com.testprj.domain.base.service.MenuServiceImpl.findByRowID(MenuServiceImpl.java:73)
 at com.testprj.ui.base.ss.WinMenuEdit.getTMenuById(WinMenuEdit.java:311)
 at com.testprj.ui.base.ss.WinMenuEdit.loadMenu(WinMenuEdit.java:173)
 at com.testprj.ui.base.ss.WinMenuEdit.afterCompose(WinMenuEdit.java:73)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:557)
 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:481)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 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.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
 at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
 at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:109)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.webapp.DefaultLoginPageGeneratingFilter.doFilterHttp(DefaultLoginPageGeneratingFilter.java:86)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
 at java.lang.Thread.run(Unknown Source)

 

奇怪的是并非每次执行都有错误，偶尔也会成功！

 

 

目前采用的是webserver的JNDI连接池。

 

 搜了很久，有兄弟建议用c3p0连接池，http://bjzhanghao.cnblogs.com/archive/2004/12/10/75145.html  19楼。

于是修改spring-hibernate配置如下：

	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="dataSource"><ref bean="dataSource" /></property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.DB2Dialect</prop>
				<prop key="hibernate.show_sql">false</prop>
				<!-- add for c3p0 连接池 -->
				<prop key="hibernate.c3p0.min_size">5</prop> 
				<prop key="hibernate.c3p0.max_size">20</prop> 
				<prop key="hibernate.c3p0.timeout">1800</prop> 
				<prop key="hibernate.c3p0.max_statements">50</prop> 
			</props>
		</property>
		<property name="configLocation" value="classpath:/config/hibernate/hibernate.cfg.xml"/>
	</bean>
	<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory" ref="sessionFactory"></property></bean>
	<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory">
			<ref bean="sessionFactory" />
		</property>
	</bean>
	<tx:annotation-driven transaction-manager="transactionManager" />

    依然没有解决，错误依旧。

    更有兄弟说只是调试信息，没影响。http://hbird.vicp.net/viewthread.php?action=printable&tid=2157

 

    求指点！

 

-----------------------------------------------------------------------------------

 

已解决：

我试了一下，如果不用JNDI，直接在spring里写datasource的配置，则不会出现该错误。

 

rain2005 (中级程序员) 2008-12-18

的解决方法：

       现在使用的是JBOSS的dataSource，不是使用的c3p0当然报错拉

 

两种方式：

1、采用c3p0数据源配置连接池：

     

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"  
        destroy-method="close">  
        <property name="driverClass">  
            <value>com.ibm.db2.jcc.DB2Driver</value>  
        </property>  
        <property name="jdbcUrl">  
            <value>jdbc:db2://172.21.21.2:50000/HOSPDB</value>  
        </property>  
        <property name="user">  
            <value>db2admin</value>  
        </property>  
        <property name="password">  
            <value>dhcc</value>  
        </property>     
     ......   
</bean>

2、如果使用JNDI的话，transactionManager也得改成jboss提供的事务管理器。具体配置可以参考spring文档中的JTA事务管理。

afeigoo
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
jboss服务器上搭建Hibernate项目出现的validator问题解决办法
弱水三千，只取一瓢
09-08 1233
问题：同样的Hibernate项目在tomcat中部署后运行成功，但是部署在jboss-4.2.3.GA时发生以下异常： Caused by: java.lang.NoSuchMethodException: org.hibernate.validator.ClassValidator.(java.lang.Class, java.util.ResourceBundle, org.hiberna
spring4.3.3 整合 Hibernate5.2.4 jar包冲突问题 org.jboss.logging.Logger.debugf(Ljava/lang/String;I)V
Kshatriya_的专栏
12-02 5453
有 IOC 容器 生成 sessionfactory 的时候， 提示 缺少 org.jboss.logging.Logger.debugf(Ljava/lang/String;I)V 方法， 详细的 exception 如下： 警告: Exception encountered during context initialization - cancelling refresh attempt:
jboss mysql 连接超时_jboss 数据库连接问题
weixin_35750747的博客
01-19 288
18:05:04,793 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@1266732java.lang.Throwable: STACKTRACEat org.jbo...
jboss Closing a connection for you
任香980101
05-10 214
jboss 报了如下的错   [CachedConnectionManager] Closing a connection for you.  Please close them yourself: org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@785d564b   项目里面用了spring管理事物，  但用的是注释的...
Hibernate 4.2.1
11-06
在Eclipse环境下安装Hibernate 4.2.1插件，可以通过Update Site进行，这正是“Hibernate JBoss 4.2.1 Update Release”标签所指的内容。首先，需要在Eclipse的“Help” -> “Install New Software”中添加更新站点，...
jboss、eclipse的jpa连接mysql不成熟的例子
02-03
在本例中，标题提到的"jboss、eclipse的jpa连接mysql不成熟的例子"可能指的是在尝试配置Eclipse开发环境，使用JPA与JBoss应用服务器连接MySQL数据库时遇到了问题。Eclipse是一个强大的Java集成开发环境，提供了对JPA...
hibernate3.6相关jar包
07-12
6. **jboss-logging.jar**：日志处理库，Hibernate使用它进行各种调试和错误信息的记录。 7. **其他依赖库**：如dom4j、slf4j、cglib、asm等，它们是Hibernate运行时需要的辅助库，分别用于XML处理、日志服务、动态...
Hibernate的jar包
11-06
5. **数据库驱动**: 根据你所使用的数据库（如MySQL、Oracle、PostgreSQL等），你需要相应的JDBC驱动jar包，以便Hibernate能连接到数据库。 6. **cglib** 和 **asm**: 这两个库用于动态代理和字节码操作，Hibernate...
JBOSS启动顺序、JBOSS占用的端口
10-25
3. **服务初始化**：JBoss根据配置文件加载并初始化各种服务，如EJB容器、Web服务器（ Undertow 或 Tomcat ）、JMS消息队列、持久化服务（Hibernate）等。 4. **模块加载**：JBoss模块系统会加载应用所需的类库和...
Jboss加载不到数据库驱动问题解决过程记录
热门推荐
李坤 大米时代 第五期
03-13 1万+
错误日志:22:41:44,320 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 48) MSC000001: Failed to start service jboss.persistenceunit."itoo-exam-systemmanage-dictionary-ear.ear/itoo-exam-api
jboss 数据库连接管理的一个问题
那一抹云
04-22 4354
工作中遇到了一个问题，google了一篇，原文地址：http://blog.csdn.net/xumiao19871129/archive/2009/10/14/4669898.aspx转载如下： 1[CachedConnectionManager] Closing a connection for you.  Please close them yourself: org.j
JBoss部署时版本冲突一例
bulargy-zone
03-21 190
自己做一些小例子玩，部署到tomcat和jetty上都能正常工作。但是部署到JBoss里的时候问题就来了，这也找不到，那也找不到。报的错也看起来找不着北，说什么自动写入失败啊，bean加载失败啊，弄了半天也没弄明白。 上网到处找找，由于报的错实在太普片了，所以和大海捞针一样的。但是我发现大部的JBoss问题都是由于这个包不对啊，那个包不兼容啊又或是冲突了之类。 于是我就对比JBoss默认的包和...
jboss配置数据源问题CachedConnectionManager]
feng_224的专栏
11-04 1089
最近出现了个问题困扰好几天CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@c75442java.lang....解决办法仅修改jboss_home/de
java.langThrowable:STACKTRACE
weixin_34351321的博客
03-01 1765
Jboss版本是4.2.0.GA代码运行完后总报错 但是程序的运行结果没问题 请问下这是什么原因2009-12-11 01:53:26,611 INFO  [org.jboss.resource.connectionmanager.CachedConnectionManager] (http-127.0.0.1-8080-1) Closing a connection for you.  Plea...
jboss下配置虚拟主机
liuliliujian
01-27 238
refer to: http://skyuck.iteye.com/blog/564592 1.先在你发布的项目的WEB-INF目录下建一个jboss-web.xml的文件,内容如下: Java代码 / www.unis.com 2.修改jboss的server.xml配...
解决JBoss与Hibernate中的Oracle BrokenPipe错误
"这篇文档是关于在使用JBOSS服务器时遇到的常见问题，特别是针对Hibernate操作Oracle数据库时出现的BrokenPipe错误的解决方案。" 在Java应用服务器如JBOSS中，开发者和管理员经常会遇到数据库连接问题，尤其是当与...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值