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

Details

Type: Improvement
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 1.0-JSR-6
Component/s: groovy-jdk
Labels:
None

Number of attachments :
6

Description

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.

More Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Download All

Attachments

fuller-sql-changes.tgz

19/Mar/06 7:02 AM

12 kB

Robert Fuller
GroovyResultSetPatch.txt

07/Apr/06 9:05 AM

72 kB

Robert Fuller
$i18n.getText("admin.common.words.hide")
sqlcall.zip

07/Apr/06 9:05 AM

26 kB

Robert Fuller
groovy/sql/CallResultSet.java 0.6 kB

groovy/sql/DataSet.java 7 kB

groovy/sql/ExpandedVariable.java 0.2 kB

groovy/sql/GroovyResultSet.java 108 kB

groovy/sql/GroovyRowResult.java 4 kB

groovy/sql/InOutParameter.java 0.2 kB

groovy/sql/InParameter.java 0.3 kB

groovy/sql/OutParameter.java 0.2 kB

groovy/sql/ResultSetOutParameter.java 0.1 kB

groovy/sql/Sql.java 41 kB

groovy/sql/SqlWhereVisitor.java 2 kB

Download Zip
$i18n.getText("admin.common.words.show")

sqlcall.zip

07/Apr/06 9:05 AM

26 kB

Robert Fuller
SqlPatch.txt

07/Apr/06 9:05 AM

19 kB

Robert Fuller
TestSqlCall.groovy

07/Apr/06 9:06 AM

4 kB

Robert Fuller
TestSqlCall.groovy

19/Mar/06 7:03 AM

3 kB

Robert Fuller

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Robert Fuller added a comment - 19/Mar/06 7: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.

Show

Robert Fuller added a comment - 19/Mar/06 7: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.

Hide

Permalink

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

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

Show

Robert Fuller added a comment - 19/Mar/06 7:03 AM Attached file shows some examples of calling stored procedures from groovy using changes in previous attachment.

Hide

Permalink

Robert Fuller added a comment - 07/Apr/06 9: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.

Show

Robert Fuller added a comment - 07/Apr/06 9: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.

Hide

Permalink

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

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

Show

Robert Fuller added a comment - 07/Apr/06 9:06 AM Updated version of groovy file demonstrating usage of sql callable statements against oracle database.

Hide

Permalink

Robert Fuller added a comment - 07/Apr/06 9: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.

Show

Robert Fuller added a comment - 07/Apr/06 9: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.

Hide

Permalink

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

Patch from Robert Fuller applied.

Show

Guillaume Laforge added a comment - 09/Apr/06 10:20 AM Patch from Robert Fuller applied.

People

Assignee:

Guillaume Laforge

Reporter:

Horia Muntean

Vote (0)

Watch (0)

Dates

Created:

21/May/04 9:42 AM

Updated:

09/Apr/06 10:20 AM

Resolved:

09/Apr/06 10:20 AM