All Forums Extensibility
Israfil 3 posts Joined 09/13
17 Sep 2013
DYNAMIC RESULT SETS and Teradata versions

I have a Java Stored Procedure created using the Teradata Plug-in for Eclipse, which works perfectly on Teradata V13.
But when I try to install it on Teradata V12 I receive the message
LANGUAGE JAVA *** Failure 3706 Syntax error: Java Language does not support DYNAMIC RESULT SETS in this release. Statement# 1, Info =183

Weren't DYNAMIC RESULT SETS a new feature of V12? Does anybody know any work-around?

tomnolan 594 posts Joined 01/08
18 Sep 2013

Dynamic result sets for SQL stored procedures are a Teradata Database 12.0 feature.
 
Dynamic result sets for Java stored procedures are a Teradata Database 13.0 feature.
 
The "workaround" is to use Teradata Database 13.0, because that is the earliest release that contains the feature you are trying to use.

Israfil 3 posts Joined 09/13
19 Sep 2013

Thank you very much for your answer. I supposed the possibility to use them in Java because the Release 12 Documentation ( http://www.info.teradata.com/edownload.cfm?itemid=071940001 ), speaking about Dynamic Result Sets, refers also to Teradata JDBC driver.
Do you have an idea if installing JDBC 13.0.0.6 driver on TeraData  R12 could help? (I’m following what suggested in http://downloads.teradata.com/download/connectivity/teradata-jdbc-driver-13-0-0-6 , the section What’s New of the README). 
Thank you again, Raffaele.

tomnolan 594 posts Joined 01/08
19 Sep 2013

>>> Do you have an idea if installing JDBC 13.0.0.6 driver on TeraData R12 could help?
 
No, it will not.

Israfil 3 posts Joined 09/13
20 Sep 2013

Ok, unfortunately release 12 is not our choice, we will find out a software solution. Thank you very much for your assistance.

You must sign in to leave a comment.