1 Reply Latest reply on Dec 11, 2012 2:07 AM by rpraveenkumar

    TransactionImpl: XAException using Hibernate

    Chris M Newbie

      Hi,

      We are currently are fazing out our own persitence layer based on DAO's and a custom Connection Pool in favor of Hibernate and the JBoss - Datasource. But now we ran into a strange exception. We will also be posting this request to the Hibernate forum since we are puzzled were it comes from ... sorry.

      Rationale :
      ----------------
      We opted for Hibernate Synchronizer to generate our new DAO's for us and it works like a charm ...
      however ... sometimes after a long period of working OK we get a peculiar error message and we don't know
      what/where it is going wrong. We found a lot of tips on a lot of forums and postings but none of them seems to do the trick.
      Since it transverses a lot of layers, any help or tips what else we could do would be appreciated a lot!

      Our platform :
      --------------------
      Linux 2.4.20
      JBoss 3.2.3
      MySQL 4.0.21-Max
      JSDK 1.4.2_05
      Hibernate 2.1.6 using JBoss datasource (see mysql-ds.xml below)

      The reduced error messages : (see below for full trace please)
      --------------------------------------

      08:40:57,372 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=s7000//191, BranchQual=] errorCode=XA_UNKNOWN(0)
      org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream
      java.io.IOException: Unexpected end of input stream
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1405)
      ...
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:708)
      ...
      Caused by: org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

      =====================================================================

      These tips didn't seem to fix the problem :

      mysql-ds.xml
      -------------------

      <datasources>
       <local-tx-datasource>
       <jndi-name>MySqlCCDS</jndi-name>
       <connection-url>jdbc:mysql://localhost:3306/xxx?autoReconnect=true&autoReconnectForPools=true&connectTimeout=0</connection-url>
       <driver-class>com.mysql.jdbc.Driver</driver-class>
       <user-name>xxx</user-name>
       <password>xxx</password>
      
       <!-- TIP: duplicated since we couln't find the one and only correct way to do it -->
       <autoReconnectForPools>true</autoReconnectForPools>
       <autoReconnect>true</autoReconnect>
       <maxReconnects>10</maxReconnects>
      
       <connectTimeout>0</connectTimeout>
       <min-pool-size>5</min-pool-size>
       <max-pool-size>15</max-pool-size>
      
       <!-- TIP: increased these values just to be sure -->
       <blocking-timeout-millis>5000</blocking-timeout-millis>
       <idle-timeout-minutes>1000</idle-timeout-minutes>
      
       </local-tx-datasource>
      </datasources>


      hibernate-cfg.xml
      ------------------------

      ...
      <property name="hibernate.connection.datasource">java:/MySqlCCDS</property>
      <property name="hibernate.transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
      <property name="hibernate.transaction.manager_lookup_class">net.sf.hibernate.transaction.JBossTransactionManagerLookup</property>
      
      <!-- Common Settings -->
      <property name="hibernate.connection.username">xxx</property>
      <property name="hibernate.connection.password">xxx</property>
      <property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
      <property name="hibernate.show_sql">false</property>
      <property name="hibernate.use_outer_join">true</property>
      
      <!-- TIP: "to tackle the loss of sessions problem" -->
      <property name="connection.autoReconnect">true</property>
      <property name="connection.autoReconnectForPools">true</property>
      <property name="connection.is-connection-validation-required">true</property>
      ...


      _BaseRootDAO.java generated by Hibernate Synchronizer
      ---------------------------
      ...
       public static Session createSession(String configFile) throws HibernateException {
       java.util.Stack sessionStack = (java.util.Stack) threadedSessions.get();
       Session session = null;
       if (null == sessionStack) {
       sessionStack = new java.util.Stack();
       threadedSessions.set(sessionStack);
       }
       if (sessionStack.size() > 0) {
       Object[] arr = (Object[]) sessionStack.peek();
       String cf = (String) arr[0];
       if (null == cf) {
       session = (Session) arr[1];
       }
       else if (null != cf && null != configFile) {
       if (cf.equals(configFile)) session = (Session) arr[1];
       }
       if (null == session || !session.isOpen()) { //TIP: to handle sessions...
       session = getSessionFactory(configFile).openSession();
       arr = new Object[2];
       arr[0] = configFile;
       arr[1] = session;
       sessionStack.push(arr);
       }
      
       }
       else {
       session = getSessionFactory(configFile).openSession();
       Object[] arr = new Object[2];
       arr = new Object[2];
       arr[0] = configFile;
       arr[1] = session;
       sessionStack.push(arr);
       }
       return session;
       }
      
      
       /**
       * Begin the transaction related to the session
       */
       public Transaction beginTransaction(Session s) throws HibernateException {
       return s.beginTransaction();
       }
      
       /**
       * Commit the given transaction
       */
       public void commitTransaction(Transaction t) throws HibernateException {
       t.commit();
       }
      
       /**
       * Used by the base DAO classes but here for your modification
       * Persist the given transient instance, first assigning a generated identifier.
       * (Or using the current value of the identifier property if the assigned generator is used.)
       */
       protected Serializable save(Object obj) throws HibernateException {
       Transaction t = null;
       Session s = null;
       try {
       s = getSession();
       t = beginTransaction(s);
       Serializable rtn = save(obj, s);
       commitTransaction(t);
       return rtn;
       }
       catch (HibernateException e) {
       if (null != t) t.rollback();
       throw e;
       }
       finally {
       closeSession();
       }
       }
      
      ...


      The full error messages :
      --------------------------------
      8< -------------
      08:40:57,372 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=s7000//191, BranchQual=] errorCode=XA_UNKNOWN(0)
      org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

      ** BEGIN NESTED EXCEPTION **

      java.io.IOException
      MESSAGE: Unexpected end of input stream

      STACKTRACE:

      java.io.IOException: Unexpected end of input stream
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1405)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1775)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
      at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1070)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2027)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1996)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1977)
      at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:654)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:149)
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:704)
      at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1148)
      at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:636)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:455)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:208)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:614)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)


      ** END NESTED EXCEPTION **

      ))
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:708)
      at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1148)
      at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:636)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:455)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:208)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:614)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

      ** BEGIN NESTED EXCEPTION **

      java.io.IOException
      MESSAGE: Unexpected end of input stream

      STACKTRACE:

      java.io.IOException: Unexpected end of input stream
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1405)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1775)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
      at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1070)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2027)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1996)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1977)
      at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:654)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:149)
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:704)
      at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1148)
      at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:636)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:455)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:208)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:614)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)


      ** END NESTED EXCEPTION **

      )
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:546)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:156)
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:704)
      ... 69 more
      Caused by: java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

      ** BEGIN NESTED EXCEPTION **

      java.io.IOException
      MESSAGE: Unexpected end of input stream

      STACKTRACE:

      java.io.IOException: Unexpected end of input stream
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1405)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1775)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
      at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1070)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2027)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1996)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1977)
      at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:654)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:149)
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:704)
      at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1148)
      at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:636)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:455)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:208)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:614)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)


      ** END NESTED EXCEPTION **


      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1527)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1775)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
      at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1070)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2027)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1996)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:1977)
      at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:654)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:149)
      ... 70 more
      08:40:57,391 INFO [TxConnectionManager] Could not enlist in transaction on entering meta-aware object!
      javax.transaction.SystemException: enlistResource failed
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:468)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:208)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:614)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)
      08:40:57,396 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
      08:40:57,397 ERROR [JDBCExceptionReporter] Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed; - nested throwable: (javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed)
      08:40:57,398 ERROR [JDBCExceptionReporter] Cannot open connection
      org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed; - nested throwable: (javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:126)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:208)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:614)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:348)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      ... 62 more
      08:40:57,399 ERROR [SessionImpl] Could not synchronize database state with session
      net.sf.hibernate.JDBCException: Cannot open connection
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
      at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
      at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
      at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:208)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:614)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed; - nested throwable: (javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:126)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
      ... 60 more
      Caused by: javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:348)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      ... 62 more
      08:40:57,443 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=s7000//191, BranchQual=] errorCode=XA_UNKNOWN(0)
      org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=s7000//191, BranchQual=1]
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:827)
      at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1664)
      at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:458)
      at org.jboss.tm.TxManager.rollback(TxManager.java:264)
      at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.rollback(ServerVMClientUserTransaction.java:134)
      at net.sf.hibernate.transaction.JTATransaction.rollback(JTATransaction.java:85)
      at com.cc.be.integration.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:618)
      at com.cc.be.integration.hibernate.base.BaseAdvertisementDAO.save(BaseAdvertisementDAO.java:60)
      at com.cc.be.integration.dao.mysql.MySqlAdCompositeDAO.insertEventAdComposite(MySqlAdCompositeDAO.java:122)
      at com.cc.be.presentation.modules.input.CMDAdForm.execute(CMDAdForm.java:183)
      at com.cc.be.presentation.AbstractFrontController.processRequest(AbstractFrontController.java:113)
      at com.cc.be.presentation.AbstractFrontController.doPost(AbstractFrontController.java:186)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:534)
      08:40:57,445 ERROR [MySqlAdCompositeDAO] insertEventAdComposite Hibernate Exception encountered: net.sf.hibernate.JDBCException: Cannot open connection

      --------------- >8

      Any ideas?

      C.