[#GROOVY-493] Full stored procedure for groovy.sql.Sql

groovy

Full stored procedure for groovy.sql.Sql

Created: 21/May/04 09:42 AM Updated: 09/Apr/06 10:20 AM

Component/s:

groovy-jdk

Affects Version/s:

None

Fix Version/s:

1.0-JSR-6

Time Tracking:

Not Specified

File Attachments:

fuller-sql-changes.tgz (12 kB)
2.

GroovyResultSetPatch.txt (72 kB)
3.

sqlcall.zip (26 kB)
4.

SqlPatch.txt (19 kB)
5.

TestSqlCall.groovy (4 kB)
6.

TestSqlCall.groovy (3 kB)

Description

« Hide

In order to call properly a stored procedure one has to register the output parameters for the SP. Right now the groovy.sql.Sql does not support this.

All

Comments

Work Log

Change History

Sort Order:

[ Permalink | « Hide ]

Robert Fuller added a comment - 19/Mar/06 07:02 AM

Attaching tgz of implementation I made to support calling stored procedures. Note that the changes were made in 2004, so there are likely to be some changes in the relevant classes.

[ Permalink | « Hide ]

Robert Fuller added a comment - 19/Mar/06 07:03 AM

Attached file shows some examples of calling stored procedures from groovy using changes in previous attachment.

[ Permalink | « Hide ]

Robert Fuller added a comment - 07/Apr/06 09:05 AM

Have implemented support for callable statements in CVS head. Attached are patch files for the two classes changed. zip file contains changed classes plus new classes.

[ Permalink | « Hide ]

Robert Fuller added a comment - 07/Apr/06 09:06 AM

Updated version of groovy file demonstrating usage of sql callable statements against oracle database.

[ Permalink | « Hide ]

Robert Fuller added a comment - 07/Apr/06 09:07 AM

This feature now implemented against CVS head. Attachments with today's date contain changes required to implement. I look forward to seeing this absorbed back into CVS.

[ Permalink | « Hide ]

Guillaume Laforge added a comment - 09/Apr/06 10:20 AM

Patch from Robert Fuller applied.