Spring.Data.NHibernate12:::Application not closing database connection(Getting max connection pool

Posted by anupam3m on Stack Overflow See other posts from Stack Overflow or by anupam3m
Published on 2010-05-31T05:40:27Z Indexed on 2010/05/31 5:42 UTC
Read the original article Hit count: 414

Filed under:
|

Even after successful transaction.Application connection with the database persist.in Nhibernate log it shows Nhibernate Log

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - executing flush

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.ConnectionManager [(null)] <

(null)> - registering flush begin

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.ConnectionManager [(null)] <

(null)> - registering flush end

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> -

post flush

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> -

before transaction completion

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.ConnectionManager [(null)] <

(null)> - aggressively releasing database connection

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Connection.ConnectionProvider

[(null)] <(null)> - Closing connection

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> -

transaction completion

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Transaction.AdoTransaction [(null)] <

(null)> - running AdoTransaction.Dispose()

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> -

closing session

2010-05-21 14:45:08,428 [Worker] [0] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> -

running BatcherImpl.Dispose(true)

Underneath given is my dataconfiguration file

< ?xml version="1.0" encoding="utf-8" ?> < objects

    xmlns="http://www.springframework.net" 

    xmlns:db="http://www.springframework.net/database"

    xmlns:tx="http://www.springframework.net/tx">

<property name="CacheSettings" ref="CacheSettings"/>

type="Risco.Rsp.Ac.AMAC.CacheMgmt.Utilities.UpdateEntityCacheHelper, 

Risco.Rsp.Ac.AMAC.CacheMgmt.Utilities" singleton="false"/>

< object type="Spring.Objects.Factory.Config.PropertyPlaceholderConfigurer, Spring.Core"> > < property name="ConfigSections" value="databaseSettings"/> >

< db:provider id="AMACDbProvider" provider="OracleClient-2.0"

connectionString="Data Source=RISCODEVDB;User ID=amacdevuser; Password=amacuser1234;"/>

< object id="NHibernateSessionFactory"

type="Spring.Data.NHibernate.LocalSessionFactoryObject,Spring.Data.NHibernate12">

> < property name="DbProvider" ref="AMACDbProvider"/> >

 <value> Risco.Rsp.Ac.AMAC.CacheMappings</value>

</property>

  <dictionary>
    <
      entry key="hibernate.connection.provider"

          value="NHibernate.Connection.DriverConnectionProvider"
     />
    <entry key="hibernate.dialect"

> value="NHibernate.Dialect.Oracle9Dialect"/> > value="NHibernate.Driver.OracleClientDriver"/> > > > >

singleton="false">

<property name="SessionFactory"

  ref="NHibernateSessionFactory" />

<property name="TemplateFlushMode" value="Auto" />

<property name="CacheQueries" value="true" />

<property name="EntityInterceptor" ref="AuditLogger"/>

type="Spring.Data.NHibernate.HibernateTransactionManager, >Spring.Data.NHibernate12">  

<property name="DbProvider" ref="AMACDbProvider"/>

<property name="SessionFactory" ref="NHibernateSessionFactory"/>

<property name="EntityInterceptor" ref="AuditLogger"/>

type="Spring.Transaction.Interceptor.TransactionProxyFactoryObject,Spring.Data">

<property name="PlatformTransactionManager" ref="transactionManager"/>

<property name="Target" ref="EventPubSubDAO"/>

<property name="TransactionAttributes">

<name-values>

    <add key="Save*" value="PROPAGATION_REQUIRES_NEW"/>

    <add key="Delete*" value="PROPAGATION_REQUIRED"/>

  </name-values>

</property>

> > type="Risco.Rsp.Ac.AMAC.DAO.EventPubSubMgmt.EventPubSubDAO, > Risco.Rsp.Ac.AMAC.DAO.EventPubSubMgmt"> > > > < /object>

< tx:attribute-driven/> < /objects>

Please help me out with this issue.Thanks

© Stack Overflow or respective owner

Related posts about nhibernate

Related posts about spring.net