[teiid-issues] [JBoss JIRA] (TEIID-5834) Class cast exception using web service with bind varables

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TEIID-5834 started by Steven Hawkins.
---------------------------------------------
> Class cast exception using web service with bind varables
> ---------------------------------------------------------
>
>                 Key: TEIID-5834
>                 URL: https://issues.jboss.org/browse/TEIID-5834
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 11.1.2
>            Reporter: Mike Higgins
>            Assignee: Steven Hawkins
>            Priority: Major
>
> I am using a restful web service, which works fine if literal values are used to constrain it.  However, when I use bind variables, it gives me a traceback:
> java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
> 	at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
> 	at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
> 	at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
> 	at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
> 	at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
> 	at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
> 	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> 	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> 	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
> 	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
> 	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
> 	... 8 more
> The SQL is:
> SELECT CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID", 
> WS_CLUSTER.WS_CLUSTER_T."VH_SPECIES",  
> WS_CLUSTER.WS_CLUSTER_T."PROJECT_SHORT_NAME", 
> WS_CLUSTER.WS_CLUSTER_T."biosysid" 
> FROM caimanm.lm_biological_system 
> LEFT OUTER JOIN WS_cluster.WS_cluster_t 
> ON (CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID" = WS_CLUSTER.WS_CLUSTER_T."biosysid") 
> AND (WS_CLUSTER.WS_CLUSTER_T."biosysid" in (?, ?, ?))
> WHERE (CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID" in (?, ?, ?))
> Where WS_CLUSTER is the web service.  I didn't find any issues about this so I was not sure if a later version would work.  



--
This message was sent by Atlassian Jira
(v7.13.8#713008)