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

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

michaelwan.plusone Aug 31, 2012 6:02 AM

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

============================================================================
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 Aug 31, 2012 7:03 AM (in response to michaelwan.plusone)

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
Actions
2. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...

rareddy Aug 31, 2012 9:26 AM (in response to michaelwan.plusone)

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..
Actions
3. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...

michaelwan.plusone Sep 2, 2012 10:39 PM (in response to michaelwan.plusone)

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>
Actions
4. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...

rareddy Sep 3, 2012 6:31 PM (in response to michaelwan.plusone)

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..
Actions
5. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...

michaelwan.plusone Sep 3, 2012 9:46 PM (in response to michaelwan.plusone)

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
Actions
6. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...

michaelwan.plusone Sep 4, 2012 5:36 AM (in response to michaelwan.plusone)

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
Actions
7. Re: TEIID - Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable...

rareddy Sep 4, 2012 9:20 AM (in response to michaelwan.plusone)

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..
Actions

Go to original post