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>
Steven Hawkins <shawkins> updated the status of jira TEIID-3998 to Resolved
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.
Steven Hawkins <shawkins> updated the status of jira TEIID-3998 to Closed
Added to Release Notes. URL: https://access.qa.redhat.com/documentation/en/red-hat-jboss-data-virtualization/6.3/single/release-notes#workarounds_for_ongoing_issues