[GROOVY-1302] Provide access to auto-generated column values when using INSERT through groovy.sql.Sql

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.0-JSR-6
• Assignee: Guillaume Sauthier
• Reporter: Peter Ledbrook
• Created: 01/May/06 05:58
• Updated: 07/May/06 15:29
• Resolved: 07/May/06 15:29

Description

At present, there is no easy way to access auto-generated values from an INSERT. For example, some tables have an autoincrement ID column which cannot be set with the INSERT statement, but it would be useful to know what value the database assigned to it for each row inserted.

To this end, I have attached a patch that adds a new set of methods called executeInsert() that return a list of the column values auto-generated by the database. These value can be accessed via array access notation; for example keys[1][0] would return the value of the first auto-generated column in the second inserted row.

No test yet, but may come later.