[teiid-issues] [JBoss JIRA] Commented: (TEIID-1127) java.lang.ClassCastException Executing Virtual Procedure from Web Service Model

java.lang.ClassCastException Executing Virtual Procedure from Web Service Model ------------------------------------------------------------------------------- Key: TEIID-1127 URL: https://jira.jboss.org/browse/TEIID-1127 Project: Teiid Issue Type: Bug Components: JDBC Driver Reporter: Ted Jones Assignee: Steve Hawkins Fix For: 7.0 Getting a Teiid connection via JNDI and executing the query (exec Books_MySql_WS.Books_MySql_BOOKS.getBOOKS();) results in the following java.lang.ClassCastException error: 10:51:59,143 ERROR [PROCESSOR] Unexpected exception for request qGFm7nWIemY9.3 java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to java.sql.Connection at org.teiid.translator.jdbc.JDBCExecutionFactory.createResultSetExecution(JDBCExecutionFactory.java:79) at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:193) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.execute(ConnectorWorkItem.java:250) at org.teiid.dqp.internal.process.DataTierTupleSource.open(DataTierTupleSource.java:118) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:82) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:136) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:106) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchIterator.hasNext(BatchIterator.java:80) at org.teiid.query.processor.xml.RelationalPlanExecutor.execute(RelationalPlanExecutor.java:98) at org.teiid.query.processor.xml.ExecSqlInstruction.process(ExecSqlInstruction.java:59) at org.teiid.query.processor.xml.XMLPlan.nextBatch(XMLPlan.java:158) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchIterator.hasNext(BatchIterator.java:80) at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:440) at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:67) at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:293) at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:232) at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:114) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:168) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:106) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:67) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:177) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:190) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:176) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.run(StatsCapturingWorkManager.java:102) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619)