Hibernate + Spring connection problem

asked 2007-01-08 17:07:29 +0800

admin
18691 ● 1 ● 10 ● 130

Orignial message at:
https://sourceforge.net/forum/message.php?msg_id=4092003

By: matteo_barbieri

Hi,
I've a problem using Hibernate and Spring (and, of course, ZK).
I make some query using hibernate, and after those queries are executed, all connections are still open.
In a short time max_connections is reached and the program got an exception
(org.hibernate.exception.JDBCConnectionException: Cannot open connection).
I read all Smalltalks, but I think I missed some configuration...
This is my zk.xml:

<zk>
<listener>
<description>Spring TransactionSynchronizationManager handler</description>
<listener-class>org.zkoss.zkplus.spring.SpringTransactionSynchronizationList
ener</listener-class>
</listener>
</zk>

And my applicationContext.xml:

<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
destroy-method="close">
... database settings ...
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource" />
</property>
<property name="mappingResources">
... resource files ...
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLInnoDBDialect
</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.current_session_context_class">thread</prop>
<prop key="hibernate.transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory
</prop>
</props>
</property>

It seems that connection are not closed after query execution... Must I add other configurations in zk.xml?

Please help :(

Thank you,
bye