Вызвано: java.sql.sqlexception: соединение не связано с Managed Connection.org.jboss.resource.ada ⇐ JAVA

[Anonymous]

У меня есть приложение с Jboss, Seam, Hibernate и H2. Я написал простое действие для импорта данных в базу данных из внешнего файла. < /P>

@Name("importAction")
@AutoCreate
@Scope(ScopeType.CONVERSATION)
@Transactional
public class ImportCosAction extends AbstractAction {

saveOrUpdate(member);

protected void saveOrUpdate(AbstractEntity entity) {
final Session session = getSession();
session.saveOrUpdate(entity);
flushSession();
}
< /code>

Он работает, как и ожидалось, однако в какой -то момент я получаю следующее исключение: < /p>

16:50:13,558 ERROR [JDBCExceptionReporter] Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@3c4b0529
16:50:13,558 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: C o u l d n o t e x e c u t e J D B C b a t c h u p d a t e < b r / > a t o r g . h i b e r n a t e . e x c e p t i o n . S Q L S t a t e C o n v e r t e r . h a n d l e d N o n S p e c i f i c E x c e p t i o n ( S Q L S t a t e C o n v e r t e r . j a v a : 1 2 6 ) < b r / > a t o r g . h i b e r n a t e . e x c e p t i o n . S Q L S t a t e C o n v e r t e r . c o n v e r t ( S Q L S t a t e C o n v e r t e r . j a v a : 1 1 4 ) < b r / > a t o r g . h i b e r n a t e . e x c e p t i o n . J D B C E x c e p t i o n H e l p e r . c o n v e r t ( J D B C E x c e p t i o n H e l p e r . j a v a : 6 6 ) < b r / > a t o r g . h i b e r n a t e . j d b c . A b s t r a c t B a t c h e r . e x e c u t e B a t c h ( A b s t r a c t B a t c h e r . j a v a : 2 7 5 ) < b r / > a t o r g . h i b e r n a t e . j d b c . A b s t r a c t B a t c h e r . p r e p a r e S t a t e m e n t ( A b s t r a c t B a t c h e r . j a v a : 1 1 4 ) < b r / > a t o r g . h i b e r n a t e . j d b c . A b s t r a c t B a t c h e r . p r e p a r e S t a t e m e n t ( A b s t r a c t B a t c h e r . j a v a : 1 0 9 ) < b r / > a t o r g . h i b e r n a t e . j d b c . A b s t r a c t B a t c h e r . p r e p a r e B a t c h S t a t e m e n t ( A b s t r a c t B a t c h e r . j a v a : 2 4 4 ) < b r / > a t o r g . h i b e r n a t e . p e r s i s t e r . e n t i t y . A b s t r a c t E n t i t y P e r s i s t e r . i n s e r t ( A b s t r a c t E n t i t y P e r s i s t e r . j a v a : 2 2 5 2 ) < b r / > a t o r g . h i b e r n a t e . p e r s i s t e r . e n t i t y . A b s t r a c t E n t i t y P e r s i s t e r . i n s e r t ( A b s t r a c t E n t i t y P e r s i s t e r . j a v a : 2 6 8 8 ) < b r / > a t o r g . h i b e r n a t e . a c t i o n . E n t i t y I n s e r t A c t i o n . e x e c u t e ( E n t i t y I n s e r t A c t i o n . j a v a : 7 9 ) < b r / > a t o r g . h i b e r n a t e . e n g i n e . A c t i o n Q u e u e . e x e c u t e ( A c t i o n Q u e u e . j a v a : 2 7 9 ) < b r / > a t o r g . h i b e r n a t e . e n g i n e . A c t i o n Q u e u e . e x e c u t e A c t i o n s ( A c t i o n Q u e u e . j a v a : 2 6 3 ) < b r / > a t o r g . h i b e r n a t e . e n g i n e . A c t i o n Q u e u e . e x e c u t e A c t i o n s ( A c t i o n Q u e u e . j a v a : 1 6 7 ) < b r / > a t o r g . h i b e r n a t e . e v e n t . d e f . A b s t r a c t F l u s h i n g E v e n t L i s t e n e r . p e r f o r m E x e c u t i o n s ( A b s t r a c t F l u s h i n g E v e n t L i s t e n e r . j a v a : 3 2 1 ) < b r / > a t o r g . h i b e r n a t e . e v e n t . d e f . D e f a u l t F l u s h E v e n t L i s t e n e r . o n F l u s h ( D e f a u l t F l u s h E v e n t L i s t e n e r . j a v a : 5 0 ) < b r / > a t o r g . h i b e r n a t e . i m p l . S e s s i o n I m p l . f l u s h ( S e s s i o n I m p l . j a v a : 1 0 2 7 ) < b r / > a t o r g . j b o s s . s e a m . p e r s i s t e n c e . H i b e r n a t e S e s s i o n P r o x y . f l u s h ( H i b e r n a t e S e s s i o n P r o x y . j a v a : 1 8 7 ) < b r / > a t c o m . c a p e c a p i t a l . d e a l m a r k e t . u s e c a s e . A b s t r a c t A c t i o n . f l u s h S e s s i o n ( A b s t r a c t A c t i o n . j a v a : 4 3 4 ) < b r / > a t c o m . c a p e c a p i t a l . d e a l m a r k e t . u s e c a s e . r e g i s t r a t i o n . A b s t r a c t R e g i s t r a t i o n A c t i o n . c r e a t e N e w A c c o u n t ( A b s t r a c t R e g i s t r a t i o n A c t i o n . j a v a : 2 5 1 ) < b r / > a t c o m . c a p e c a p i t a l . d e a l m a r k e t . u s e c a s e . r e g i s t r a t i o n . R e g i s t r a t i o n A c t i o n . p r i m R e g i s t e r ( R e g i s t r a t i o n A c t i o n . j a v a : 7 1 ) < b r / > a t c o m . c a p e c a p i t a l . d e a l m a r k e t . u s e c a s e . r e g i s t r a t i o n . A b s t r a c t R e g i s t r a t i o n A c t i o n . r e g i s t e r ( A b s t r a c t R e g i s t r a t i o n A c t i o n . j a v a : 1 4 6 ) < b r / > a t c o m . c a p e c a p i t a l . d e a l m a r k e t . u s e c a s e . i m p o r t C o S . I m p o r t C o s A c t i o n . r e g i s t e r ( I m p o r t C o s A c t i o n . j a v a : 4 0 1 ) < b r / > a t c o m . c a p e c a p i t a l . d e a l m a r k e t . u s e c a s e . i m p o r t C o S . I m p o r t C o s A c t i o n . e x e c u t e ( I m p o r t C o s A c t i o n . j a v a : 1 5 4 ) < b r / > a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e 0 ( N a t i v e M e t h o d ) < b r / > a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e ( N a t i v e M e t h o d A c c e s s o r I m p l . j a v a : 3 9 ) < b r / > a t s u n . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e ( D e l e g a t i n g M e t h o d A c c e s s o r I m p l . j a v a : 2 5 ) < b r / > a t j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e ( M e t h o d . j a v a : 5 9 7 ) < b r / > a t o r g . j b o s s . s e a m . u t i l . R e f l e c t i o n s . i n v o k e ( R e f l e c t i o n s . j a v a : 2 2 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . R o o t I n v o c a t i o n C o n t e x t . p r o c e e d ( R o o t I n v o c a t i o n C o n t e x t . j a v a : 3 2 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . S e a m I n v o c a t i o n C o n t e x t . p r o c e e d ( S e a m I n v o c a t i o n C o n t e x t . j a v a : 5 6 ) < b r / > a t o r g . j b o s s . s e a m . t r a n s a c t i o n . R o l l b a c k I n t e r c e p t o r . a r o u n d I n v o k e ( R o l l b a c k I n t e r c e p t o r . j a v a : 2 8 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . S e a m I n v o c a t i o n C o n t e x t . p r o c e e d ( S e a m I n v o c a t i o n C o n t e x t . j a v a : 6 8 ) < b r / > a t o r g . j b o s s . s e a m . t r a n s a c t i o n . T r a n s a c t i o n I n t e r c e p t o r $ 1 . w o r k ( T r a n s a c t i o n I n t e r c e p t o r . j a v a : 9 7 ) < b r / > a t o r g . j b o s s . s e a m . u t i l . W o r k . w o r k I n T r a n s a c t i o n ( W o r k . j a v a : 4 7 ) < b r / > a t o r g . j b o s s . s e a m . t r a n s a c t i o n . T r a n s a c t i o n I n t e r c e p t o r . a r o u n d I n v o k e ( T r a n s a c t i o n I n t e r c e p t o r . j a v a : 9 1 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . S e a m I n v o c a t i o n C o n t e x t . p r o c e e d ( S e a m I n v o c a t i o n C o n t e x t . j a v a : 6 8 ) < b r / > a t o r g . j b o s s . s e a m . c o r e . M e t h o d C o n t e x t I n t e r c e p t o r . a r o u n d I n v o k e ( M e t h o d C o n t e x t I n t e r c e p t o r . j a v a : 4 4 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . S e a m I n v o c a t i o n C o n t e x t . p r o c e e d ( S e a m I n v o c a t i o n C o n t e x t . j a v a : 6 8 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . R o o t I n t e r c e p t o r . i n v o k e ( R o o t I n t e r c e p t o r . j a v a : 1 0 7 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . J a v a B e a n I n t e r c e p t o r . i n t e r c e p t I n v o c a t i o n ( J a v a B e a n I n t e r c e p t o r . j a v a : 1 8 5 ) < b r / > a t o r g . j b o s s . s e a m . i n t e r c e p t . J a v a B e a n I n t e r c e p t o r . i n v o k e ( J a v a B e a n I n t e r c e p t o r . j a v a : 1 0 3 ) < b r / > a t c o m . c a p e c a p i t a l . d e a l m a r k e t . u s e c a s e . i m p o r t C o S . I m p o r t C o s A c t i o n _ $ $ _ j a v a s s i s t _ s e a m _ 1 8 . e x e c u t e ( I m p o r t C o s A c t i o n _ $ $ _ j a v a s s i s t _ s e a m _ 1 8 . j a v a ) < b r / > a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e 0 ( N a t i v e M e t h o d ) < b r / > a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e ( N a t i v e M e t h o d A c c e s s o r I m p l . j a v a : 3 9 ) < b r / > a t s u n . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e ( D e l e g a t i n g M e t h o d A c c e s s o r I m p l . j a v a : 2 5 ) < b r / > a t j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e ( M e t h o d . j a v a : 5 9 7 ) < b r / > a t o r g . j b o s s . e l . u t i l . R e f l e c t i o n U t i l . i n v o k e M e t h o d ( R e f l e c t i o n U t i l . j a v a : 3 3 5 ) < b r / > a t o r g . j b o s s . e l . u t i l . R e f l e c t i o n U t i l . i n v o k e M e t h o d ( R e f l e c t i o n U t i l . j a v a : 2 8 0 ) < b r / > a t o r g . j b o s s . e l . p a r s e r . A s t M e t h o d S u f f i x . g e t V a l u e ( A s t M e t h o d S u f f i x . j a v a : 5 9 ) < b r / > a t o r g . j b o s s . e l . p a r s e r . A s t M e t h o d S u f f i x . i n v o k e ( A s t M e t h o d S u f f i x . j a v a : 6 5 ) < b r / > a t o r g . j b o s s . e l . p a r s e r . A s t V a l u e . i n v o k e ( A s t V a l u e . j a v a : 9 6 ) < b r / > a t o r g . j b o s s . e l . M e t h o d E x p r e s s i o n I m p l . i n v o k e ( M e t h o d E x p r e s s i o n I m p l . j a v a : 2 7 6 ) < b r / > a t c o m . s u n . f a c e l e t s . e l . T a g M e t h o d E x p r e s s i o n . i n v o k e ( T a g M e t h o d E x p r e s s i o n . j a v a : 6 8 ) < b r / > a t j a v a x . f a c e s . c o m p o n e n t . M e t h o d B i n d i n g M e t h o d E x p r e s s i o n A d a p t e r . i n v o k e ( M e t h o d B i n d i n g M e t h o d E x p r e s s i o n A d a p t e r . j a v a : 8 8 ) < b r / > a t c o m . s u n . f a c e s . a p p l i c a t i o n . A c t i o n L i s t e n e r I m p l . p r o c e s s A c t i o n ( A c t i o n L i s t e n e r I m p l . j a v a : 1 0 2 ) < b r / > a t j a v a x . f a c e s . c o m p o n e n t . U I C o m m a n d . b r o a d c a s t ( U I C o m m a n d . j a v a : 3 8 7 ) < b r / > a t o r g . a j a x 4 j s f . c o m p o n e n t . A j a x V i e w R o o t . p r o c e s s E v e n t s ( A j a x V i e w R o o t . j a v a : 3 2 9 ) < b r / > a t o r g . a j a x 4 j s f . c o m p o n e n t . A j a x V i e w R o o t . b r o a d c a s t E v e n t s F o r P h a s e ( A j a x V i e w R o o t . j a v a : 3 0 4 ) < b r / > a t o r g . a j a x 4 j s f . c o m p o n e n t . A j a x V i e w R o o t . p r o c e s s P h a s e ( A j a x V i e w R o o t . j a v a : 2 6 1 ) < b r / > a t o r g . a j a x 4 j s f . c o m p o n e n t . A j a x V i e w R o o t . p r o c e s s A p p l i c a t i o n ( A j a x V i e w R o o t . j a v a : 4 7 4 ) < b r / > a t o r g . o p e n f a c e s . a j a x . r i c h f a c e s . A 4 J A j a x V i e w R o o t . a c c e s s $ 3 0 1 ( A 4 J A j a x V i e w R o o t . j a v a : 2 8 ) < b r / > a t o r g . o p e n f a c e s . a j a x . r i c h f a c e s . A 4 J A j a x V i e w R o o t $ 1 . p a r e n t P r o c e s s A p p l i c a t i o n ( A 4 J A j a x V i e w R o o t . j a v a : 5 1 ) < b r / > a t o r g . o p e n f a c e s . a j a x . C o m m o n A j a x V i e w R o o t . p r o c e s s A p p l i c a t i o n ( C o m m o n A j a x V i e w R o o t . j a v a : 1 9 7 ) < b r / > a t o r g . o p e n f a c e s . a j a x . r i c h f a c e s . A 4 J A j a x V i e w R o o t . p r o c e s s A p p l i c a t i o n ( A 4 J A j a x V i e w R o o t . j a v a : 1 1 2 ) < b r / > a t c o m . s u n . f a c e s . l i f e c y c l e . I n v o k e A p p l i c a t i o n P h a s e . e x e c u t e ( I n v o k e A p p l i c a t i o n P h a s e . j a v a : 8 2 ) < b r / > a t c o m . s u n . f a c e s . l i f e c y c l e . P h a s e . d o P h a s e ( P h a s e . j a v a : 1 0 0 ) < b r / > a t c o m . s u n . f a c e s . l i f e c y c l e . L i f e c y c l e I m p l . e x e c u t e ( L i f e c y c l e I m p l . j a v a : 1 1 8 ) < b r / > a t j a v a x . f a c e s . w e b a p p . F a c e s S e r v l e t . s e r v i c e ( F a c e s S e r v l e t . j a v a : 2 6 5 ) < b r / > a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . i n t e r n a l D o F i l t e r ( A p p l i c a t i o n F i l t e r C h a i n . j a v a : 2 9 0 ) < b r / > a t o r g . a p a c h e . c a t a l i n a . c o re.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openfaces.util.ResourceFilter.doFilter(ResourceFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
at org.jboss.seam.web.RewriteFilter.doFilter(RewriteFilter.java:63)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at com.capecapital.dealmarket.filter.UserAgentFilter.doFilter(UserAgentFilter.java:46)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at com.capecapital.dealmarket.filter.DealmarketExceptionFilter.doFilter(DealmarketExceptionFilter.java:72)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:42)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at com.capecapital.dealmarket.filter.RequestLoggingFilter.doFilter(RequestLoggingFilter.java:90)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
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:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@3c4b0529
at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)
at org.jboss.resource.adapter.jdbc.WrappedStatement.lock(WrappedStatement.java:64)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:767)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 117 more


Подробнее здесь: https://stackoverflow.com/questions/159 ... managed-co