Bug 1311213

Summary: EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jan Stastny <jstastny>
Component: Teiid, DocumentationAssignee: David Le Sage <dlesage>
Status: CLOSED CURRENTRELEASE QA Contact: Filip Elias <felias>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.3.0CC: aszczucz, blafond, drieden, jolee, lfabriko, mbaluch, thauser, vhalbert
Target Milestone: GAKeywords: Documentation
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Known Issue
Doc Text:
Cause: Using a driver from a prior major release against a new major release. Consequence: The user may see errors due to incompatibilities between major versions Workaround (if any): The user should be instructed to upgrade their driver. Result:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-11 05:04:55 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Jan Stastny 2016-02-23 15:28:31 UTC
Description of problem:
We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance.
The problem is caused by virtual procedure execution.
Query performed:
EXEC View.hiddenUpdate(456,'changed')

View definition:
<model name="View" type="VIRTUAL">
   <metadata type="DDL"><![CDATA[
	CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN
   MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME);
END
]]> </metadata>
</model>

Comment 1 JBoss JIRA Server 2016-02-24 18:10:15 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3998 to Resolved

Comment 2 Van Halbert 2016-03-05 16:42:10 UTC
This is a client side issue, as the engineer indicated (and fixed in 6.x).  Therefore, there is no fix to help the use of the EDS 5.3 jdbc driver, other than document this and suggest they upgrade their driver to 6.x if this issue arrives.

Comment 3 JBoss JIRA Server 2016-06-03 22:43:31 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3998 to Closed