I needed another JPA query to populate a drop down listbox in my JSF.  The 
table exists in a different DB than the original @Factory method query that 
populates the main form dataTable.

soooooooooo............

Is it "legal" to inject the EntityManager more than once in the case of 
multiple persistence units for multiple DB's?  If not, can I create another 
SFSB and use the new EntityManager object for the new DB and inject it into the 
origianl SFSB?  Assuming the context should stay the same for both 
(conversation scope).

How can I do this using SMPC if it doesn't have the persistence unit element in 
the @In attribute for it?  How does SMPC know what DB it's connected/configured 
to?  I want to use FlushModeType.MANUAL to ensure there are no premature 
updates issued to the DB table(s).

SFSB code:

@PersistenceContext(unitName="boIcomsSecurityAudit", 
type=PersistenceContextType.EXTENDED)
  |     private EntityManager emICOMS;
  |     
  |     @PersistenceContext(unitName="coxIMDatasource", 
type=PersistenceContextType.EXTENDED)
  |     private EntityManager emCoxIM;
  | 
  |     @Begin(join=true, flushMode=FlushModeType.MANUAL)   // <-- use this 
with SMPC
  |     //@Begin(join=true)
  |     @Factory("myAuditList")
  |     public void findAuditList()
  |     {               
  |             
  |             Boolean hardCodeEmployeeId = 
Boolean.parseBoolean(SecurityAuditProperties.getProperty(SecurityAuditConstants.HARD_CODE_EMPLOYEE_ID));
  |             int employeeId;
  |             
  |             if (hardCodeEmployeeId) {  //if true in props file then we're 
testing only...
  |                     employeeId = 900050881; //using btkach id for now;
  |             }
  |             else {
  |                     log.info("in getAuditList(): user.getUserId() = " + 
user.getUserId() + " user.getBillingId() = " + user.getBillingId());        
  |                 
  |                     employeeId = getEmployeeId();
  |             
  |             }       
  |                     myAuditList = emICOMS.createQuery("SELECT gem, tsaw "+
  |                                                                             
"FROM TblSecurityAuditWorking tsaw, "+                                  
  |                                                                             
"GlobalEmployeeMaster gem "+                            
  |                                                                             
"WHERE tsaw.id.siteId           = gem.id.siteId "+
  |                                                                             
"AND tsaw.id.employeeNumber = gem.id.employeeNumber "+                          
  |                                                                             
"AND tsaw.reportToId            = :employeeId " +
  |                                                                             
"ORDER BY tsaw.id.employeeNumber ASC")
  |                                                                             
.setParameter("employeeId", employeeId)
  |                                                                             
.getResultList();       
  |                 
  |                     //instantiate null valued noteList
  |             noteAction.initialize(myAuditList);
  |                     
  |             log.info("in findAuditList(): myAuditList.size() = " + 
myAuditList.size());
  |             
  |             noteLoadList = emICOMS.createQuery("SELECT saw.id.siteId, 
saw.id.employeeNumber, "+
  |                                                                     "("+
  |                                                                     "SELECT 
count(san) as AcctApprovedNoteCount "+
  |                                                                     "FROM 
TblSecurityAuditNote san "+
  |                                                                     "WHERE 
san.siteId = saw.id.siteId "+
  |                                                                     "AND 
san.employeeNumber = saw.id.employeeNumber "+
  |                                                                     "AND 
san.noteType = 'accountApproved' "+
  |                                                                     ") as 
AcctApprovedCount, "+
  |                                                                     "("+
  |                                                                     "SELECT 
count(san) as secLevelApprovedNoteCount "+
  |                                                                     "FROM 
TblSecurityAuditNote san "+
  |                                                                     "WHERE 
san.siteId = saw.id.siteId "+
  |                                                                     "AND 
san.employeeNumber = saw.id.employeeNumber "+
  |                                                                     "AND 
san.noteType = 'secLevelApproved' "+
  |                                                                     ") as 
secLevelApprovedCount, "+
  |                                                                     "("+
  |                                                                     "SELECT 
count(san) as adjLimitApprovedNoteCount "+
  |                                                                     "FROM 
TblSecurityAuditNote san "+
  |                                                                     "WHERE 
san.siteId = saw.id.siteId "+
  |                                                                     "AND 
san.employeeNumber = saw.id.employeeNumber "+
  |                                                                     "AND 
san.noteType = 'adjLimitApproved' "+
  |                                                                     ") as 
adjLimitApprovedCount "+
  |                                                                     "FROM 
TblSecurityAuditWorking saw")
  |                                                                     
.getResultList();
  |             
  |             
  |             
  |             log.info("in findAuditList(): noteLoadList.size() = " + 
noteLoadList.size());
  |             
  |             
  |             
  |     }
  |     
  |     @Factory("peerList")
  |     public void getPeerList() {
  |     
  |             int employeeId = getEmployeeId();
  |             
  |             myAuditList = emCoxIM.createQuery("SELECT user1 "+
  |                             "FROM User user1 "+                             
        
  |                             "WHERE user1.hierarchyPath in "+
  |                             "(SELECT user2.hierarchyPath "+
  |                             "FROM User user2 "+
  |                             "WHERE user2.employeeId = :employeeId) "+
  |                             "ORDER BY user1.firstName ASC")
  |                             .setParameter("employeeId", employeeId)
  |                             .getResultList();  
  |             
  |             log.info("in getPeerList(): peerList.size() = " + 
peerList.size());
  |     }
  |     
  | 
  | 

I am getting the following exception when the newly added @Factory("peerList") 
method is executed:

javax.ejb.EJBTransactionRolledbackException: 
org.hibernate.exception.GenericJDBCException: Cannot open connection
  |     at org.jboss.ejb3.tx.Ejb3TxPolicy.handleInCallerTx(Ejb3TxPolicy.java:87)
  |     at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:130)
  |     at 
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:83)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
  |     at 
org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.ejb3.stateful.StatefulContainer.localInvoke(StatefulContainer.java:206)
  |     at 
org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:119)
  |     at $Proxy110.getPeerList(Unknown Source)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  |     at java.lang.reflect.Method.invoke(Unknown Source)
  |     at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
  |     at 
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
  |     at 
org.jboss.seam.intercept.ClientSideInterceptor$1.proceed(ClientSideInterceptor.java:76)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
  |     at 
org.jboss.seam.ejb.RemoveInterceptor.aroundInvoke(RemoveInterceptor.java:41)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:106)
  |     at 
org.jboss.seam.intercept.ClientSideInterceptor.invoke(ClientSideInterceptor.java:54)
  |     at 
org.javassist.tmp.java.lang.Object_$$_javassist_1.getPeerList(Object_$$_javassist_1.java)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  |     at java.lang.reflect.Method.invoke(Unknown Source)
  |     at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
  |     at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:125)
  |     at org.jboss.seam.Component.callComponentMethod(Component.java:2074)
  |     at org.jboss.seam.Component.getInstanceFromFactory(Component.java:1918)
  |     at org.jboss.seam.Component.getInstance(Component.java:1855)
  |     at org.jboss.seam.Component.getInstance(Component.java:1832)
  |     at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
  |     at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
  |     at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:166)
  |     at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:53)
  |     at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
  |     at 
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
  |     at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
  |     at 
org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
  |     at 
com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
  |     at javax.faces.component.UISelectItems.getValue(UISelectItems.java:130)
  |     at 
com.sun.faces.renderkit.RenderKitUtils.getSelectItems(RenderKitUtils.java:323)
  |     at 
com.sun.faces.renderkit.html_basic.MenuRenderer.getOptionNumber(MenuRenderer.java:675)
  |     at 
com.sun.faces.renderkit.html_basic.MenuRenderer.renderSelect(MenuRenderer.java:793)
  |     at 
com.sun.faces.renderkit.html_basic.MenuRenderer.encodeEnd(MenuRenderer.java:335)
  |     at 
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:836)
  |     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:896)
  |     at javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
  |     at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
  |     at 
org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
  |     at 
org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
  |     at 
org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:199)
  |     at 
org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:194)
  |     at 
org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:121)
  |     at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
  |     at 
com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:271)
  |     at 
com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:117)
  |     at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
  |     at 
com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:271)
  |     at 
com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:242)
  |     at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
  |     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
  |     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
  |     at 
com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
  |     at 
org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
  |     at 
org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:216)
  |     at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
  |     at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
  |     at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
  |     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
  |     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  |     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  |     at jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:118)
  |     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.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:68)
  |     at 
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  |     at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
  |     at 
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  |     at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
  |     at 
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  |     at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:44)
  |     at 
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  |     at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
  |     at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
  |     at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
  |     at 
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  |     at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
  |     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:230)
  |     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  |     at 
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
  |     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
  |     at 
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
  |     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  |     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  |     at 
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
  |     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  |     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
  |     at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  |     at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  |     at 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
  |     at java.lang.Thread.run(Unknown Source)
  | Caused by: javax.persistence.PersistenceException: 
org.hibernate.exception.GenericJDBCException: Cannot open connection
  |     at 
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
  |     at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)
  |     at 
com.cox.beans.session.SecurityAuditAction.getPeerList(SecurityAuditAction.java:209)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  |     at java.lang.reflect.Method.invoke(Unknown Source)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
  |     at 
org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
  |     at 
com.cox.beans.interceptor.ProfilingInterceptor.profile(ProfilingInterceptor.java:23)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  |     at java.lang.reflect.Method.invoke(Unknown Source)
  |     at 
org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  |     at 
com.cox.beans.interceptor.LoggerInterceptor.profile(LoggerInterceptor.java:19)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  |     at java.lang.reflect.Method.invoke(Unknown Source)
  |     at 
org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  |     at 
org.jboss.seam.intercept.EJBInvocationContext.proceed(EJBInvocationContext.java:44)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
  |     at 
org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.persistence.ManagedEntityIdentityInterceptor.aroundInvoke(ManagedEntityIdentityInterceptor.java:48)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.core.ConversationInterceptor.aroundInvoke(ConversationInterceptor.java:65)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.persistence.EntityManagerProxyInterceptor.aroundInvoke(EntityManagerProxyInterceptor.java:26)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.persistence.HibernateSessionProxyInterceptor.aroundInvoke(HibernateSessionProxyInterceptor.java:27)
  |     at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  |     at 
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:106)
  |     at 
org.jboss.seam.intercept.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:50)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  |     at java.lang.reflect.Method.invoke(Unknown Source)
  |     at 
org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  |     at 
org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:71)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at 
org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
  |     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  |     at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
  |     ... 118 more
  | Caused by: org.hibernate.exception.GenericJDBCException: Cannot open 
connection
  |     at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
  |     at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
  |     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:426)
  |     at 
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
  |     at 
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
  |     at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
  |     at org.hibernate.loader.Loader.doQuery(Loader.java:673)
  |     at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
  |     at org.hibernate.loader.Loader.doList(Loader.java:2220)
  |     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
  |     at org.hibernate.loader.Loader.list(Loader.java:2099)
  |     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
  |     at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
  |     at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
  |     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
  |     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
  |     at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
  |     ... 169 more
  | 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: 
a2e0522:f0c:47685fc3:44 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: 
a2e0522:f0c:47685fc3:44 status: ActionStatus.ABORT_ONLY >))
  |     at 
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
  |     at 
org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
  |     at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
  |     ... 183 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: 
a2e0522:f0c:47685fc3:44 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)
  |     ... 185 more
  | Caused by: javax.transaction.SystemException: java.lang.Throwable: Unabled 
to enlist resource, see the previous warnings. tx=TransactionImple < ac, 
BasicAction: a2e0522:f0c:47685fc3:44 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)
  |     ... 189 more



View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4114028#4114028

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4114028
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to