Hi All,
I am getting following error
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not inspect
JDBC autocommit mode; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.); nested exception is org.jboss.util.NestedSQLException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.ew.esp.dao.impl.WindowDataProviderDaoImpl.persist(WindowDataProviderDaoImpl.java:78)
at com.ew.esp.service.impl.QuoteDBListener.update(QuoteDBListener.java:28)
at com.espertech.esper.core.StatementResultServiceImpl.processDispatch(StatementResultServiceImpl.java:221)
at com.espertech.esper.core.StatementResultServiceImpl.execute(StatementResultServiceImpl.java:197)
at com.espertech.esper.core.UpdateDispatchViewBase.execute(UpdateDispatchViewBase.java:75)
at com.espertech.esper.core.UpdateDispatchFutureSpin.execute(UpdateDispatchFutureSpin.java:85)
at com.espertech.esper.dispatch.DispatchServiceImpl.dispatchFromQueue(DispatchServiceImpl.java:57)
at com.espertech.esper.dispatch.DispatchServiceImpl.dispatch(DispatchServiceImpl.java:31)
at com.espertech.esper.core.EPRuntimeImpl.dispatch(EPRuntimeImpl.java:1053)
at com.espertech.esper.core.EPRuntimeImpl.processWrappedEvent(EPRuntimeImpl.java:411)
at com.espertech.esper.core.EPRuntimeImpl.processEvent(EPRuntimeImpl.java:380)
at com.espertech.esper.core.EPRuntimeImpl.sendEvent(EPRuntimeImpl.java:210)
at com.ew.esp.service.impl.StatementRepositoryImpl.sendEvent(StatementRepositoryImpl.java:59)
at com.ew.esp.service.impl.AbstractQuoteParser.sendQuote(AbstractQuoteParser.java:57)
at com.ew.esp.service.impl.FlatRatePremiumParser.parseQuote(FlatRatePremiumParser.java:31)
at com.ew.esp.service.impl.AbstractQuoteParser.update(AbstractQuoteParser.java:42)
at com.espertech.esper.core.StatementResultServiceImpl.processDispatch(StatementResultServiceImpl.java:221)
at com.espertech.esper.core.StatementResultServiceImpl.execute(StatementResultServiceImpl.java:197)
at com.espertech.esper.core.UpdateDispatchViewBase.execute(UpdateDispatchViewBase.java:75)
at com.espertech.esper.core.UpdateDispatchFutureSpin.execute(UpdateDispatchFutureSpin.java:85)
at com.espertech.esper.dispatch.DispatchServiceImpl.dispatchFromQueue(DispatchServiceImpl.java:57)
at com.espertech.esper.dispatch.DispatchServiceImpl.dispatch(DispatchServiceImpl.java:31)
at com.espertech.esper.core.EPRuntimeImpl.dispatch(EPRuntimeImpl.java:1053)
at com.espertech.esper.core.EPRuntimeImpl.processWrappedEvent(EPRuntimeImpl.java:411)
at com.espertech.esper.core.EPRuntimeImpl.processEvent(EPRuntimeImpl.java:380)
at com.espertech.esper.core.EPRuntimeImpl.sendEvent(EPRuntimeImpl.java:210)
at com.ew.esp.service.impl.StatementRepositoryImpl.sendEvent(StatementRepositoryImpl.java:59)
at com.ew.esp.service.impl.CommodityQuoteListener.update(CommodityQuoteListener.java:35)
at com.espertech.esper.core.StatementResultServiceImpl.processDispatch(StatementResultServiceImpl.java:221)
at com.espertech.esper.core.StatementResultServiceImpl.execute(StatementResultServiceImpl.java:197)
at com.espertech.esper.core.UpdateDispatchViewBase.execute(UpdateDispatchViewBase.java:75)
at com.espertech.esper.core.UpdateDispatchFutureSpin.execute(UpdateDispatchFutureSpin.java:85)
at com.espertech.esper.dispatch.DispatchServiceImpl.dispatchFromQueue(DispatchServiceImpl.java:57)
at com.espertech.esper.dispatch.DispatchServiceImpl.dispatch(DispatchServiceImpl.java:31)
at com.espertech.esper.core.EPRuntimeImpl.dispatch(EPRuntimeImpl.java:1053)
at com.espertech.esper.core.EPRuntimeImpl.processWrappedEvent(EPRuntimeImpl.java:411)
at com.espertech.esper.core.EPRuntimeImpl.processEvent(EPRuntimeImpl.java:380)
at com.espertech.esper.core.EPRuntimeImpl.sendEvent(EPRuntimeImpl.java:210)
at com.ew.esp.service.impl.StatementRepositoryImpl.sendEvent(StatementRepositoryImpl.java:59)
at com.ew.esp.service.impl.McxTcpSubscriber.pushData(McxTcpSubscriber.java:147)
at com.ew.esp.service.impl.McxTcpSubscriber.access$100(McxTcpSubscriber.java:26)
at com.ew.esp.service.impl.McxTcpSubscriber$3.run(McxTcpSubscriber.java:94)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.jboss.util.NestedSQLException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
at $Proxy278.isClosed(Unknown Source)
at org.hibernate.jdbc.ConnectionManager.isAutoCommit(ConnectionManager.java:189)
at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:243)
at org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:417)
at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1166)
at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:334)
at com.ew.esp.dao.impl.WindowDataProviderDaoImpl$3.doInHibernate(WindowDataProviderDaoImpl.java:80)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 46 more
Caused by: javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:487)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
... 56 more
so need to understand where is the problem and what is the solution for this.
Please help me .