Select Your Language

Infrastructure and Management

Cloud Computing

Storage

Runtimes

Integration and Automation

  • Comments
  • XA connection destroyed

    Posted on

    I have an MDB that uses an Oracle db as XA Data source. Config is as follows:

                    
                        
                            ${hif-db-url}
                        
                        OracleJDBCDriver
                        
                            uifsmgr
                            u_pick_it
                        
                        
                            false
                            false
                          false                      
                        
                        
                            false
                            0
                            0
                            0
                            0
                            0
                            0
                        
                        
                            true
                        
                    
    

    After a while of idle time then get an mdb onMessage call, attempting to post to the database generates the following exception:

        Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@178ff382[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@70289860 connection handles=0 lastReturned=1506796773697 lastValidated=1506796773525 lastCheckedOut=1506947349429 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@5968abc8 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@83405c5[pool=HIF-BannerPU] xaResource=XAResourceWrapperImpl@2168086b[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@70289860 pad=false overrideRmValue=null productName=Oracle productVersion=Oracle Database 12c Enterprise Edition Release 1
    

    How to remedy this? should I set to true? or other validation connection pooling setting?

    Thanks

    by

    points

    Responses

    Red Hat LinkedIn YouTube Facebook X, formerly Twitter

    Quick Links

    Help

    Site Info

    Related Sites

    © 2025 Red Hat