[teiid-designer-issues] [JBoss JIRA] Created: (TEIIDDES-564) Preview from Procedure fails: number of bound values '0' does not match number of parameters '1' in prepared statement.
Preview from Procedure fails: number of bound values '0' does not match number of
parameters '1' in prepared statement.
-----------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-564
URL: https://jira.jboss.org/browse/TEIIDDES-564
Project: Teiid Designer
Issue Type: Bug
Components: Teiid Integration
Affects Versions: 7.1
Environment: TeiidDesigner 7.1M2, Teiid 7.1 Final
Reporter: Paul Nittel
Attachments: ProcedureParameters.zip
I created a small procedure which requires a single input parameter. When previewed, I
receive the error noted in the title. If I deploy the VDB to the Teiid server, the same
procedure executes OK. (Hence my logging it against the Designer.)
Here is the exception from the server.log:
[QueryResolverException]The number of bound values '0' does not match the number
of parameters '1' in the prepared statement.
at
org.teiid.dqp.internal.process.PreparedStatementRequest.resolveParameterValues(PreparedStatementRequest.java:262)
at
org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:167)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:437)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:352)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:174)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
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)
Here is the transformation SQL:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT * FROM Parts_Oracle.PARTS WHERE VPARTS.NEWPROCEDURE.colorIN LIKE
Parts_Oracle.PARTS.PART_COLOR;
END
I queried using the color 'Red'.
Model Project Set will be attached.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira