Bug 781003 (SOA-3480) - It is possible to call stored procedure via Teiid JDBC driver on VDB even though VDB doesn't contain the imported procedure
Summary: It is possible to call stored procedure via Teiid JDBC driver on VDB even tho...
Keywords:
Status: CLOSED NOTABUG
Alias: SOA-3480
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0.ER4
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-12 14:24 UTC by Filip Nguyen
Modified: 2011-11-15 17:49 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-11-15 17:49:22 UTC
Type: Bug


Attachments (Terms of Use)
textDBVDB.vdb (12.39 KB, application/octet-stream)
2011-10-12 14:28 UTC, Filip Nguyen
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 781002 0 high CLOSED Stored procedure cannot be called using "Procedural Relational Command" 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-3480 0 Major Closed It is possible to call stored procedure via Teiid JDBC driver on VDB even though VDB doesn't contain the imported proced... 2017-12-12 14:27:34 UTC
Red Hat Issue Tracker TEIID-1781 0 Major Closed It is possible to call stored procedure via Teiid JDBC driver on VDB even though VDB doesn't contain the imported proced... 2017-12-12 14:27:34 UTC

Internal Links: 781002

Description Filip Nguyen 2011-10-12 14:24:52 UTC
project_key: SOA

I use setting same as in SOA-3478. But I deleted the procedure from xmi files in the VDB (attachment) and changed query to: 

{code:title=Teiid Query|borderStyle=solid}
String query = "{ CALL getEmployeeSurnames }";
{code} 

The Query is called and result set is returned.

After conversation with Steven Hawkins I understand that this shouldn't be possible and Teiid should respond that it cannot resolve the query.

Comment 1 Van Halbert 2011-10-12 14:28:34 UTC
Link: Added: This issue Cloned to SOA-3481


Comment 2 Filip Nguyen 2011-10-12 14:28:42 UTC
Attachment: Added: textDBVDB.vdb


Comment 3 Filip Nguyen 2011-10-12 14:30:44 UTC
Link: Added: This issue relates to SOA-3478



Note You need to log in before you can comment on or make changes to this bug.