7 Replies Latest reply on Sep 4, 2012 9:20 AM by Ramesh Reddy

    TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...

    michaelwan.plusone Newbie

      Dear All,


      I am trying to use Teiid 7.7.1 to link several MySQL database and present to the VDB users as 1 VDB.  However, I couldn't get it working and I couldn't figure out what's wrong/missing.  Please help.


      I have already include the MySQL driver to \jboss-as\server\default\lib\mysql-connector-java-5.1.20-bin.jar


      ============================================================================
      USER COMMAND:
      SELECT * FROM ViewCRM.customers

      ----------------------------------------------------------------------------
      OPTIMIZE:
      SELECT * FROM ViewCRM.customers

      ----------------------------------------------------------------------------
      GENERATE CANONICAL:
      SELECT * FROM ViewCRM.customers

      CANONICAL PLAN:
      Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})
        Source(groups=[ViewCRM.customers])


      ============================================================================
      EXECUTING PlaceAccess

      AFTER:
      Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})
        Access(groups=[ViewCRM.customers])
          Source(groups=[ViewCRM.customers])


      ============================================================================
      EXECUTING RaiseAccess

      AFTER:
      Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720})
        Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})
          Source(groups=[ViewCRM.customers])


      ============================================================================
      EXECUTING AssignOutputElements

      AFTER:
      Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})
        Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})
          Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})


      ============================================================================
      EXECUTING CalculateCost

      AFTER:
      Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})
        Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})
          Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_COL_STATS={ViewCRM.customers.CIFNo=[-1.0, -1.0], ViewCRM.customers.CustomerType=[-1.0, -1.0], ViewCRM.customers.IDType=[-1.0, -1.0], ViewCRM.customers.IDNumber=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})


      ============================================================================
      EXECUTING PlanSorts

      AFTER:
      Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})
        Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})
          Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_COL_STATS={ViewCRM.customers.CIFNo=[-1.0, -1.0], ViewCRM.customers.CustomerType=[-1.0, -1.0], ViewCRM.customers.IDType=[-1.0, -1.0], ViewCRM.customers.IDNumber=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})


      ============================================================================
      EXECUTING CollapseSource

      AFTER:
      Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber FROM ViewCRM.customers})


      ============================================================================
      CONVERTING PLAN TREE TO PROCESS TREE

      PROCESS PLAN =
      AccessNode(0) output=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber] SELECT g_0.CIFNo, g_0.CustomerType, g_0.IDType, g_0.IDNumber FROM ViewCRM.customers AS g_0

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

      ----------------------------------------------------------------------------
      OPTIMIZATION COMPLETE:
      PROCESSOR PLAN:
      AccessNode(0) output=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber] SELECT g_0.CIFNo, g_0.CustomerType, g_0.IDType, g_0.IDNumber FROM ViewCRM.customers AS g_0

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

      2012-08-31 17:30:31,889 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (Worker21_QueryProcessorQueue137) Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable: (java.lang.ClassNotFoundException: com.mysql.jdbc.Driver from BaseClassLoader@553bf378{vfsfile:/D:/srv/SOA-P/jboss-as/server/default/deploy/teiid/teiid-jboss-beans.xml}))
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:639)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:273)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:746)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
      at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:228)
      at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:56)
      at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:184)
      at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:207)
      at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)
      at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:232)
      at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)
      at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
      at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
      at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
      at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
      at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
      at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:375)
      at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)
      at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
      at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:240)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
      Caused by: org.jboss.resource.JBossResourceException: Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable: (java.lang.ClassNotFoundException: com.mysql.jdbc.Driver from BaseClassLoader@553bf378{vfsfile:/D:/srv/SOA-P/jboss-as/server/default/deploy/teiid/teiid-jboss-beans.xml})
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:489)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:206)
      ... 31 more
      Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver from BaseClassLoader@553bf378{vfsfile:/D:/srv/SOA-P/jboss-as/server/default/deploy/teiid/teiid-jboss-beans.xml}
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:477)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:474)
      ... 32 more
      2012-08-31 17:30:31,911 WARN  [org.teiid.CONNECTOR] (Worker21_QueryProcessorQueue137) Connector worker process failed for atomic-request=SIx3npSCPlQy.0.0.25
      org.teiid.translator.TranslatorException: Unable to get managed connection for ViewCRM; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for ViewCRM)
      at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:230)
      at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:56)
      at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:184)
      at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:207)
      at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)
      at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:232)
      at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)
      at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
      at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)
      at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
      at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
      at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
      at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:375)
      at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)
      at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
      at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:240)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
      Caused by: org.jboss.util.NestedSQLException: Unable to get managed connection for ViewCRM; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for ViewCRM)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
      at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:228)
      ... 21 more
      Caused by: javax.resource.ResourceException: Unable to get managed connection for ViewCRM
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
      ... 22 more
      Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable: (java.lang.ClassNotFoundException: com.mysql.jdbc.Driver from BaseClassLoader@553bf378{vfsfile:/D:/srv/SOA-P/jboss-as/server/default/deploy/teiid/teiid-jboss-beans.xml}))
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:639)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:273)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:746)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
      ... 26 more
      Caused by: org.jboss.resource.JBossResourceException: Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable: (java.lang.ClassNotFoundException: com.mysql.jdbc.Driver from BaseClassLoader@553bf378{vfsfile:/D:/srv/SOA-P/jboss-as/server/default/deploy/teiid/teiid-jboss-beans.xml})
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:489)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:206)
      ... 31 more
      Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver from BaseClassLoader@553bf378{vfsfile:/D:/srv/SOA-P/jboss-as/server/default/deploy/teiid/teiid-jboss-beans.xml}
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:477)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:474)
      ... 32 more
      2012-08-31 17:30:31,930 WARN  [org.teiid.PROCESSOR] (Worker21_QueryProcessorQueue137) Processing exception 'ViewCRM: Unable to get managed connection for ViewCRM; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for ViewCRM)' for request SIx3npSCPlQy.0.  Exception type org.teiid.core.TeiidProcessingException thrown from org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:477). Enable more detailed logging to see the entire stacktrace.
      2012-08-31 17:35:31,826 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (Thread-16) [com.arjuna.ats.arjuna.coordinator.TransactionReaper_18] - TransactionReaper::check timeout for TX -3f57fd9a:f1e9:50402e3e:3382 in state  RUN
      2012-08-31 17:35:31,858 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (Thread-17) [com.arjuna.ats.arjuna.coordinator.TransactionReaper_7] - TransactionReaper::doCancellations worker Thread[Thread-17,5,jboss] successfully canceled TX -3f57fd9a:f1e9:50402e3e:3382

        • 1. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...
          Van Halbert Master

          On the cover, it appears to be a data source setup issue.  If you can verify that the data source by trying the following, we can then determine if the problem is somehow related to Teiid:

           

          -  first, restart the server

          -  verify in the server log the datasource didn't have any issues

          -  then verify the mysql connection by using the bean:   jboss.jca:name=<jndiname>,service=ManagedConnectionPool

           

          Here you can test a connection to verify the datasource is setup correctly.

           

          Normally, if the datasource, which is managed by the server, is available, Teiid doesn't have an issue obtaining the connection from the connection pool.  So if you can verify this, it would be appreciated.

          1 of 1 people found this helpful
          • 2. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...
            Ramesh Reddy Master

            Are you using JBoss 5.1.0 with Teiid 7.7.1? Then what is your -ds.xml file for the datasource look like. From log it seems you have defined the data source inside "teiid-jboss-beans.xml" file. frankly I have never tried defining the data source in that file. For defining the data source using the -ds.xml file look in the examples directory for a template.

             

            Ramesh..

            • 3. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...
              michaelwan.plusone Newbie

              Thanks Van and Ramesh for the quick reply.

               

              Van, I am pretty new to Linux products, right now I am heavily relying on the JBoss Developer Studio to do all the setup job if possible.  Would you mind to elaborate more what I should do to test the connection?  I had successfully setup a text files / SOAP service by downloading those examples.  However, I couldn't find a step by step user guide to aid me to setup a connection with MySQL. I saw some articles talking about dynamic VDB but the guide has many pharses that I don't understand (I guess it is required more understanding in the AS in order to know if I have missed anything)

               

              After I have restarted my machine, there is improvement.  I am able to preview the data if I am using the Studio's preview function.  However, the VDB deployed to the AS still giving me a hard time. So there must be something I should do to the server before I can get my server to work just like what Studio do, I guess.  But I have no clue...

               

              2012-09-03 10:33:01,873 WARN  [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue7) Connector worker process failed for atomic-request=/BcGun0tB56O.1.0.2

              org.teiid.translator.TranslatorException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >)

                        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:230)

                        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:56)

                        at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:184)

                        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:207)

                        at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)

                        at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:232)

                        at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)

                        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

                        at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)

                        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)

                        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)

                        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)

                        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:375)

                        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

                        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

                        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

                        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:240)

                        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)

                        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)

                        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                        at java.lang.Thread.run(Unknown Source)

              Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >)

                        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)

                        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:228)

                        ... 21 more

              Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >

                        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:413)

                        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)

                        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)

                        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)

                        ... 22 more

              2012-09-03 10:33:01,878 WARN  [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue7) Processing exception 'ViewCRM: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >)' for request /BcGun0tB56O.1.  Exception type org.teiid.core.TeiidProcessingException thrown from org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:413). Enable more detailed logging to see the entire stacktrace.

              2012-09-03 10:33:31,740 INFO  [org.teiid.PROCESSOR] (New I/O server worker #2-1) Clearing prepared plan cache for vdb PREVIEW_b98d0b52-0022-4901-add7-6e59efbd50a9_DataServices_project.1

              2012-09-03 10:33:31,742 INFO  [org.teiid.PROCESSOR] (New I/O server worker #2-1) Clearing the resultset cache for vdb PREVIEW_b98d0b52-0022-4901-add7-6e59efbd50a9_DataServices_project.1

              2012-09-03 10:33:31,850 INFO  [org.teiid.PLANNER] (Worker2_QueryProcessorQueue14)

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

              USER COMMAND:

              SELECT * FROM ViewCRM.customers

               

               

              ----------------------------------------------------------------------------

              OPTIMIZE:

              SELECT * FROM ViewCRM.customers

               

               

              ----------------------------------------------------------------------------

              GENERATE CANONICAL:

              SELECT * FROM ViewCRM.customers

               

               

              CANONICAL PLAN:

              Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                Source(groups=[ViewCRM.customers])

               

               

               

               

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

              EXECUTING PlaceAccess

               

               

              AFTER:

              Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                Access(groups=[ViewCRM.customers])

                  Source(groups=[ViewCRM.customers])

               

               

               

               

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

              EXECUTING RaiseAccess

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                  Source(groups=[ViewCRM.customers])

               

               

               

               

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

              EXECUTING AssignOutputElements

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                  Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

               

               

               

               

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

              EXECUTING CalculateCost

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                  Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_COL_STATS={ViewCRM.customers.CIFNo=[-1.0, -1.0], ViewCRM.customers.CustomerType=[-1.0, -1.0], ViewCRM.customers.IDType=[-1.0, -1.0], ViewCRM.customers.IDNumber=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})

               

               

               

               

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

              EXECUTING PlanSorts

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                  Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_COL_STATS={ViewCRM.customers.CIFNo=[-1.0, -1.0], ViewCRM.customers.CustomerType=[-1.0, -1.0], ViewCRM.customers.IDType=[-1.0, -1.0], ViewCRM.customers.IDNumber=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})

               

               

               

               

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

              EXECUTING CollapseSource

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber FROM ViewCRM.customers})

               

               

               

               

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

              CONVERTING PLAN TREE TO PROCESS TREE

               

               

              PROCESS PLAN =

              AccessNode(0) output=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber] SELECT g_0.CIFNo, g_0.CustomerType, g_0.IDType, g_0.IDNumber FROM ViewCRM.customers AS g_0

               

               

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

               

               

              ----------------------------------------------------------------------------

              OPTIMIZATION COMPLETE:

              PROCESSOR PLAN:

              AccessNode(0) output=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber] SELECT g_0.CIFNo, g_0.CustomerType, g_0.IDType, g_0.IDNumber FROM ViewCRM.customers AS g_0

               

               

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

               

               

              2012-09-03 10:34:51,199 INFO  [org.teiid.PLANNER] (Worker2_QueryProcessorQueue19)

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

              USER COMMAND:

              SELECT * FROM ViewCRM.customers

               

               

              ----------------------------------------------------------------------------

              OPTIMIZE:

              SELECT * FROM ViewCRM.customers

               

               

              ----------------------------------------------------------------------------

              GENERATE CANONICAL:

              SELECT * FROM ViewCRM.customers

               

               

              CANONICAL PLAN:

              Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                Source(groups=[ViewCRM.customers])

               

               

               

               

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

              EXECUTING PlaceAccess

               

               

              AFTER:

              Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                Access(groups=[ViewCRM.customers])

                  Source(groups=[ViewCRM.customers])

               

               

               

               

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

              EXECUTING RaiseAccess

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                  Source(groups=[ViewCRM.customers])

               

               

               

               

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

              EXECUTING AssignOutputElements

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

                  Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber]})

               

               

               

               

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

              EXECUTING CalculateCost

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                  Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_COL_STATS={ViewCRM.customers.CIFNo=[-1.0, -1.0], ViewCRM.customers.CustomerType=[-1.0, -1.0], ViewCRM.customers.IDType=[-1.0, -1.0], ViewCRM.customers.IDNumber=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})

               

               

               

               

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

              EXECUTING PlanSorts

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                Project(groups=[ViewCRM.customers], props={PROJECT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0})

                  Source(groups=[ViewCRM.customers], props={OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_COL_STATS={ViewCRM.customers.CIFNo=[-1.0, -1.0], ViewCRM.customers.CustomerType=[-1.0, -1.0], ViewCRM.customers.IDType=[-1.0, -1.0], ViewCRM.customers.IDNumber=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})

               

               

               

               

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

              EXECUTING CollapseSource

               

               

              AFTER:

              Access(groups=[ViewCRM.customers], props={MODEL_ID=Schema name=ViewCRM, nameInSource=null, uuid=mmuuid:29e1f731-d209-4ed8-a96a-ba6c9df38720, OUTPUT_COLS=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber FROM ViewCRM.customers})

               

               

               

               

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

              CONVERTING PLAN TREE TO PROCESS TREE

               

               

              PROCESS PLAN =

              AccessNode(0) output=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber] SELECT g_0.CIFNo, g_0.CustomerType, g_0.IDType, g_0.IDNumber FROM ViewCRM.customers AS g_0

               

               

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

               

               

              ----------------------------------------------------------------------------

              OPTIMIZATION COMPLETE:

              PROCESSOR PLAN:

              AccessNode(0) output=[ViewCRM.customers.CIFNo, ViewCRM.customers.CustomerType, ViewCRM.customers.IDType, ViewCRM.customers.IDNumber] SELECT g_0.CIFNo, g_0.CustomerType, g_0.IDType, g_0.IDNumber FROM ViewCRM.customers AS g_0

               

               

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

               

               

              2012-09-03 10:34:51,208 WARN  [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue19) Connector worker process failed for atomic-request=/BcGun0tB56O.2.0.4

              org.teiid.translator.TranslatorException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >)

                        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:230)

                        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:56)

                        at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:184)

                        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:207)

                        at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)

                        at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:232)

                        at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)

                        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

                        at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)

                        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)

                        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)

                        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)

                        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:375)

                        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

                        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

                        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

                        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:240)

                        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)

                        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)

                        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                        at java.lang.Thread.run(Unknown Source)

              Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >)

                        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)

                        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:228)

                        ... 21 more

              Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >

                        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:413)

                        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)

                        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)

                        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)

                        ... 22 more

              2012-09-03 10:34:51,213 WARN  [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue19) Processing exception 'ViewCRM: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57fd9a:c335:50440fa7:3b1 status: ActionStatus.ABORTED >)' for request /BcGun0tB56O.2.  Exception type org.teiid.core.TeiidProcessingException thrown from org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:413). Enable more detailed logging to see the entire stacktrace.

               

              Ramesh, I am using JBoss SOA Platform: Embedded Server - Version 5.3.0.GA and Teiid 7.7.1.  I haven't defined anything in teiid-jboss-beans.xml, so I am not sure.

               

              I have a "plusonecrm-ds.xml", content as below.

              <?xml version="1.0" encoding="UTF-8"?>

               

              <datasources>

                <local-tx-datasource>

                  <jndi-name>plusonecrm</jndi-name>

                  <connection-url>jdbc:mysql://192.168.2.102:3306/plusonecrm</connection-url>

                  <driver-class>com.mysql.jdbc.Driver</driver-class>

                  <user-name>democrm</user-name>

                  <password>********</password>

                  <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>

                  <metadata>

                     <type-mapping>mySQL</type-mapping>

                  </metadata>

                </local-tx-datasource>

              </datasources>

              • 4. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...
                Ramesh Reddy Master

                Michael,

                 

                Do you have one source or more than one source you are working with? The error is different from your first one. It is complaining that there was no transaction found. This applies usually in scenario where two or more sources are involved. When there are more than single source involved, you either need to created XA based connections or turn off transactions (not recommended).  When single source is involved what you have with "local-tx-datasource"  in -ds.xml file is sufficient. Check to see in your log if there are any other errors.

                 

                Also, I am kind of confused when you say you are using JBoss SOA Platoform 5.3.0 and Teiid 7.7.1. If you are working with EDS product 5.3.0, you do not need to install the Teiid 7.7.1, it comes integrated. Also, if you a customer you can ask Redhat support for help too.

                 

                Ramesh..

                • 5. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...
                  michaelwan.plusone Newbie

                  Ramesh,

                   

                  Yes, I have downloaded the RedHat EDS 5.3 and doing an evaluation.  Since if a solution is sold to a client, they have an option to subscribe for support.  So at this moment, I am not a RedHat customer yet.  It is a hard time to get the things/demo working, by the time I get to make the demo works and able to connect a REST service by myself, the evaluation period is already expired.

                   

                  My goal is to make the vdb can read multiple sources of data and consolidate into 1 VDB for other applications to call (Also, I am going to massage the data a bit, just like my other thread which tried to calculate age).

                   

                  All I did is to use the developer studio to create a VDB, select the xmi (s) into it.  Then click deploy VDB to the server.  This is also one of the goal of the evaluation that many (almost all) tasks are done through developer studio.

                   

                  With the above scenario, do I have to make a -ds.xml?  Or it will auto generate a suitable one when I add more xmi (s) into the VDB with the aid of Developer Studio?

                   

                  Many Thanks

                  • 6. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...
                    michaelwan.plusone Newbie

                    Update of the status, I have done nothing but just simply restart my desktop PC again.

                     

                    Now it works.

                    1 of 1 people found this helpful
                    • 7. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...
                      Ramesh Reddy Master

                      Michael,

                       

                      BTW, when you download the evaluation version of the EDS from Redhat portal, I believe it comes with some level support included with it and lasts 60 days from date of download.  Hopefully somebody can clarify the details.

                       

                      Also, we are taking every step to make sure the users have all the information interms of examples and documents etc to help with their evaluations. Please provide feedback as to what Teiid/EDS teams can do more to ease into development of your usecase. We appreciate your feedback.

                       

                      Thank you.

                       

                      Ramesh..