Executing multiple statements in JBoss Developer Studio SQL Scrapbook gives a parsing error
Issue
-
When I try to execute more than one SQL statement at a time against my JBEDS Virtual Database (VDB) in JBDS SQL Scrapbook I receive a parsing error:
select count(*) from (exec F_ReadTagsInterpolatedValues10Tag('2011-04-20 03:58:31', '2011-04-23 03:58:31', '1s', 'V7204-dO2_PV,V7204-GPR,V7204-pH_PV, V7204-OUR,V7204-KLA,V7204-Agitation,V7204-Air Flow,V7204-Weight,V7204-RQ') ) as t; select count(*) from (exec F_ReadTagsInterpolatedValues10Tag('2011-04-20 03:58:31', '2011-04-23 03:58:31', '1s', 'V7204-dO2_PV,V7204-GPR,V7204-pH_PV, V7204-OUR,V7204-KLA,V7204-Agitation,V7204-Air Flow,V7204-Weight,V7204-RQ') ) as t; Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "select" at line 5, column 1. Was expecting: <EOF>
Environment
- JBoss Enterprise Data Services Platform (JBEDS) 5.1
- JBoss Developer Studio (JBDS) 4.0.0, 4.1.0, 4.1.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.