[jboss-user] [JBoss Seam] - Re: Problems using multiple datasources
bmcgovern
do-not-reply at jboss.com
Tue Jul 10 18:05:31 EDT 2007
I'm getting the exact same error only I'm using an XA-datasource. Im using SQL Server 2005. Any ideas?
One Data Source, the other is configured same just different DB instance.
| <datasources>
| <xa-datasource>
| <jndi-name>jdbc/myronepjndi</jndi-name>
| <use-java-context>false</use-java-context>
| <track-connection-by-tx/>
| <!--<xa-datasource-property name="URL">jdbc:jtds:sqlserver://192.168.100.9:1433;databasename=MyronEP5;tds=8.0;lastupdatecount=true</xa-datasource-property>-->
| <xa-datasource-property name="ServerName">localhost</xa-datasource-property>
| <xa-datasource-property name="DatabaseName">MyronEP5</xa-datasource-property>
| <xa-datasource-property name="SelectMethod">cursor</xa-datasource-property>
|
| <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
| <!--<xa-datasource-property name="User">myronep5</xa-datasource-property>
| <xa-datasource-property name="Password">myronep5</xa-datasource-property>-->
| <user-name>myron</user-name>
| <password>myron</password>
| <metadata>
| <type-mapping>MS SQLSERVER2000</type-mapping>
| </metadata>
|
| </xa-datasource>
| </datasources>
|
SPRING BEAN DEFINITION
| <bean id="myronTransactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">
| <property name="userTransactionName" value="UserTransaction" />
| <!--<property name="userTransactionName" >null></null></property>
| <property name="transactionManager">
| <ref bean="jndiTransactionManager" />
| </property>-->
| </bean>
|
|
| <bean id="txProxyTemplate" abstract="true"
| class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
| <property name="transactionManager">
| <ref bean="myronTransactionManager" />
| </property>
| <property name="transactionAttributes">
| <props>
| <prop key="add*">PROPAGATION_REQUIRED</prop>
| <prop key="set*">PROPAGATION_REQUIRED</prop>
| <prop key="reset*">PROPAGATION_REQUIRED</prop>
| <prop key="update*">PROPAGATION_REQUIRED</prop>
| <prop key="save*">PROPAGATION_REQUIRED</prop>
| <prop key="remove*">PROPAGATION_REQUIRED</prop>
| <prop key="delete*">PROPAGATION_REQUIRED</prop>
| <prop key="process*">PROPAGATION_REQUIRED</prop>
| <prop key="exist*">PROPAGATION_REQUIRED</prop>
| <prop key="checkout">PROPAGATION_NEVER</prop>
| <prop key="getCartByCustomerSession">PROPAGATION_REQUIRED</prop>
| <prop key="releaseOrderShipment">
| PROPAGATION_NEVER
| </prop>
| <prop key="getNextOrderNumber">
| PROPAGATION_REQUIRES_NEW,ISOLATION_SERIALIZABLE
| </prop>
| <prop key="*">PROPAGATION_SUPPORTS,readOnly</prop>
| </props>
| </property>
|
| <property name="preInterceptors">
| <ref bean="servicePreInterceptors"/>
| </property>
| </bean>
|
|
STACK TRACE
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Using transaction object [org.springframework.transaction.jta.JtaTransactionObject at 5971c3]
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Initializing transaction synchronization
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for com.elasticpath.service.customer.CustomerSessionService.findByGuid
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Bound value [org.springframework.orm.hibernate3.SessionHolder at 3bf5e8] for key [org.hibernate.impl.SessionFactoryImpl at 261ac7] to thread [http-127.0.0.1-8080-1]
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder at 3bf5e8] for key [org.hibernate.impl.SessionFactoryImpl at 261ac7] bound to thread [http-127.0.0.1-8080-1]
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder at 3bf5e8] for key [org.hibernate.impl.SessionFactoryImpl at 261ac7] bound to thread [http-127.0.0.1-8080-1]
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Invoking commit for transaction on com.elasticpath.service.customer.CustomerSessionService.findByGuid
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Triggering beforeCommit synchronization
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Triggering beforeCompletion synchronization
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Removed value [org.springframework.orm.hibernate3.SessionHolder at 3bf5e8] for key [org.hibernate.impl.SessionFactoryImpl at 261ac7] from thread [http-127.0.0.1-8080-1]
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Triggering afterCommit synchronization
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Triggering afterCompletion synchronization
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Clearing transaction synchronization
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Using transaction object [org.springframework.transaction.jta.JtaTransactionObject at 4976d6]
| 2007-07-10 17:52:01,796 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Creating new transaction with name [com.elasticpath.service.customer.CustomerSessionService.update]
| 2007-07-10 17:52:01,812 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Initializing transaction synchronization
| 2007-07-10 17:52:01,812 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for com.elasticpath.service.customer.CustomerSessionService.update
| 2007-07-10 17:52:01,812 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Bound value [org.springframework.orm.hibernate3.SessionHolder at 11701fd] for key [org.hibernate.impl.SessionFactoryImpl at 261ac7] to thread [http-127.0.0.1-8080-1]
| 2007-07-10 17:52:01,812 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder at 11701fd] for key [org.hibernate.impl.SessionFactoryImpl at 261ac7] bound to thread [http-127.0.0.1-8080-1]
| 2007-07-10 17:52:01,812 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Invoking commit for transaction on com.elasticpath.service.customer.CustomerSessionService.update
| 2007-07-10 17:52:01,812 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Triggering beforeCommit synchronization
| 2007-07-10 17:52:01,828 [http-127.0.0.1-8080-1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
| 2007-07-10 17:52:01,828 [http-127.0.0.1-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >))
| 2007-07-10 17:52:01,828 [http-127.0.0.1-8080-1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
| 2007-07-10 17:52:01,828 [http-127.0.0.1-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >))
| 2007-07-10 17:52:01,828 [http-127.0.0.1-8080-1] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
| org.hibernate.exception.GenericJDBCException: Cannot open connection
| at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:318)
| at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:93)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
| at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2163)
| at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
| at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
| at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
| at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
| at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
| at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
| at org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:130)
| at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:707)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:523)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:510)
| at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:310)
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
| at $Proxy63.update(Unknown Source)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.findOrCreateCustomerSession(WebCustomerSessionServiceImpl.java:138)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.handleFilterRequest(WebCustomerSessionServiceImpl.java:61)
| at com.elasticpath.sfweb.filters.CustomerSessionFilter.doFilter(CustomerSessionFilter.java:67)
| at com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at com.elasticpath.commons.filter.impl.EncodingFilter.handleFilter(EncodingFilter.java:137)
| at com.elasticpath.commons.filter.impl.EncodingFilter.doFilter(EncodingFilter.java:80)
| 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:128)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
| at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
| at java.lang.Thread.run(Thread.java:595)
| Caused by: org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >))
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
| at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:315)
| ... 50 more
| Caused by: org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >)
| at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
| ... 52 more
| Caused by: javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.checkEnlisted(TxConnectionManager.java:744)
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:577)
| at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337)
| ... 56 more
| 2007-07-10 17:52:01,843 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Triggering beforeCompletion synchronization
| 2007-07-10 17:52:01,843 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Removed value [org.springframework.orm.hibernate3.SessionHolder at 11701fd] for key [org.hibernate.impl.SessionFactoryImpl at 261ac7] from thread [http-127.0.0.1-8080-1]
| 2007-07-10 17:52:01,843 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Initiating transaction rollback on commit exception
| org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
| Caused by:
| org.hibernate.exception.GenericJDBCException: Cannot open connection
| at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:318)
| at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:93)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
| at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2163)
| at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
| at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
| at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
| at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
| at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
| at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
| at org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:130)
| at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:707)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:523)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:510)
| at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:310)
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
| at $Proxy63.update(Unknown Source)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.findOrCreateCustomerSession(WebCustomerSessionServiceImpl.java:138)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.handleFilterRequest(WebCustomerSessionServiceImpl.java:61)
| at com.elasticpath.sfweb.filters.CustomerSessionFilter.doFilter(CustomerSessionFilter.java:67)
| at com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at com.elasticpath.commons.filter.impl.EncodingFilter.handleFilter(EncodingFilter.java:137)
| at com.elasticpath.commons.filter.impl.EncodingFilter.doFilter(EncodingFilter.java:80)
| 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:128)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
| at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
| at java.lang.Thread.run(Thread.java:595)
| Caused by: org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >))
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
| at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:315)
| ... 50 more
| Caused by: org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >)
| at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
| ... 52 more
| Caused by: javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.checkEnlisted(TxConnectionManager.java:744)
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:577)
| at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337)
| ... 56 more
| 2007-07-10 17:52:01,843 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.jta.JtaTransactionManager - Triggering afterCompletion synchronization
| 2007-07-10 17:52:01,843 [http-127.0.0.1-8080-1] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Clearing transaction synchronization
| 2007-07-10 17:52:01,843 [http-127.0.0.1-8080-1] FATAL com.elasticpath.commons.filter.impl.EncodingFilter - Exception caught in EncodingFilter:
| org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
| Caused by:
| org.hibernate.exception.GenericJDBCException: Cannot open connection
| at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:318)
| at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:93)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
| at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2163)
| at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
| at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
| at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
| at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
| at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
| at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
| at org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:130)
| at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:707)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:523)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:510)
| at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:310)
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
| at $Proxy63.update(Unknown Source)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.findOrCreateCustomerSession(WebCustomerSessionServiceImpl.java:138)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.handleFilterRequest(WebCustomerSessionServiceImpl.java:61)
| at com.elasticpath.sfweb.filters.CustomerSessionFilter.doFilter(CustomerSessionFilter.java:67)
| at com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at com.elasticpath.commons.filter.impl.EncodingFilter.handleFilter(EncodingFilter.java:137)
| at com.elasticpath.commons.filter.impl.EncodingFilter.doFilter(EncodingFilter.java:80)
| 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:128)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
| at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
| at java.lang.Thread.run(Thread.java:595)
| Caused by: org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >))
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
| at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:315)
| ... 50 more
| Caused by: org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >)
| at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
| ... 52 more
| Caused by: javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.checkEnlisted(TxConnectionManager.java:744)
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:577)
| at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337)
| ... 56 more
| 2007-07-10 17:52:01,843 [http-127.0.0.1-8080-1] ERROR org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/myron].[jsp] - Servlet.service() for servlet jsp threw exception
| javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f579bfb:55f:4693ff55:3e status: ActionStatus.ABORT_ONLY >
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.checkEnlisted(TxConnectionManager.java:744)
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:577)
| at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399)
| 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:81)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:315)
| at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:93)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
| at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2163)
| at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
| at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
| at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
| at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
| at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
| at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
| at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
| at org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:130)
| at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:707)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:523)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:510)
| at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:310)
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
| at $Proxy63.update(Unknown Source)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.findOrCreateCustomerSession(WebCustomerSessionServiceImpl.java:138)
| at com.elasticpath.sfweb.service.WebCustomerSessionServiceImpl.handleFilterRequest(WebCustomerSessionServiceImpl.java:61)
| at com.elasticpath.sfweb.filters.CustomerSessionFilter.doFilter(CustomerSessionFilter.java:67)
| at com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:137)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at com.elasticpath.commons.filter.impl.EncodingFilter.handleFilter(EncodingFilter.java:137)
| at com.elasticpath.commons.filter.impl.EncodingFilter.doFilter(EncodingFilter.java:80)
| 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:128)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
| at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
| at java.lang.Thread.run(Thread.java:595)
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4062709#4062709
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4062709
More information about the jboss-user
mailing list