-
Jul 26th, 2007, 12:42 PM
#1
JBoss hanging:org.hibernate.jdbc.ConnectionManager] opening JDBC connection
We are using a combination of Spring, Hibernate, and a JBoss cluster of 4 nodes. Occasionally we have a node hang with the server.log ending as so:
2007-07-26 11:08:59,464 INFO [application] User submission of Form Bean (Login) validation was successful.
2007-07-26 11:08:59,464 DEBUG [org.springframework.orm.hibernate3.HibernateTransa ctionManager] Using transaction object [org.springframework.orm.hibernate3.HibernateTransa ctionManager$HibernateTransactionObject@e3fad3]
2007-07-26 11:08:59,464 DEBUG [org.springframework.orm.hibernate3.HibernateTransa ctionManager] Creating new transaction with name [com.innovis.service.IUserService.getUserByUsername]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly
2007-07-26 11:08:59,464 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4855654561644544
2007-07-26 11:08:59,464 DEBUG [org.springframework.orm.hibernate3.HibernateTransa ctionManager] Opened new Session [org.hibernate.impl.SessionImpl@1686457] for Hibernate transaction
2007-07-26 11:08:59,464 DEBUG [org.springframework.orm.hibernate3.HibernateTransa ctionManager] Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@1686457]
2007-07-26 11:08:59,465 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
Here is what our Spring application context xml file looks like:
<!-- DataSource Definition -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" abstract="false" singleton="true" lazy-init="default" autowire="default" dependency-check="default">
<property name="driverClassName">
<value>net.sourceforge.jtds.jdbc.Driver</value>
</property>
<property name="url">
<value>@jdbc.driver.url@</value>
</property>
<property name="username">
<value>@server.db.username@</value>
</property>
<property name="password">
<value>@server.db.password@</value>
</property>
</bean>
<!-- Hibernate SessionFactory Definition -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSes sionFactoryBean">
<property name="mappingResources">
<list>
<value>com/innovis/domain/User.hbm.xml</value>
<value>com/innovis/domain/Order.hbm.xml</value>
<value>com/innovis/domain/PasswordHistory.hbm.xml</value>
<value>com/innovis/domain/PasswordRecall.hbm.xml</value>
<value>com/innovis/domain/SessionTracking.hbm.xml</value>
<value>com/innovis/domain/ConsumerLock.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLS erverDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">tru e</prop>
<prop key="hibernate.cache.provider_class">org.hibernate .cache.HashtableCacheProvider</prop>
<prop key="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'</prop>
</props>
</property>
<property name="dataSource">
<ref bean="dataSource"/>
</property></bean>
<!-- Spring Data Access Exception Translator Defintion -->
<bean id="jdbcExceptionTranslator" class="com.innovis.util.InnovisSQLErrorCodeSLQExce ptionTranslator">
<property name="dataSource"><ref bean="dataSource"/></property>
<property name="snmpService" ref="snmpService" />
</bean>
<!-- Hibernate Template Defintion -->
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.Hibernat eTemplate">
<property name="sessionFactory"><ref bean="sessionFactory"/></property>
<property name="jdbcExceptionTranslator"><ref bean="jdbcExceptionTranslator"/></property>
</bean>
***********************************************
We thought that it might be a database pooling issue, but not sure, can anyone give us an idea? The other 3 nodes of the cluster continue to work, but this one will not do anything until restarted.
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules