[
https://issues.apache.org/jira/browse/IBATIS-142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12485363
]
Tony Jewell commented on IBATIS-142:
------------------------------------
This is causing impact in my project now and as we are weighing up staying with
ibatis or moving to Spring Jdbc. Lack of generated key support could be
significant.
The using of the SELECT @@identity specific for sybase is annoying and just
doesn't feel right.
So - yes it would be cool. You have the return structure from the execute - the
returned object could be a collection - just some syntactic sugar in the sqlmap
<selectkey as Brandon suggests to enable it, optionally providing the names of
the auto-generated keys to return.
> JDBC 3 Generated Keys Support
> -----------------------------
>
> Key: IBATIS-142
> URL: https://issues.apache.org/jira/browse/IBATIS-142
> Project: iBatis for Java
> Issue Type: Improvement
> Components: SQL Maps
> Reporter: Brandon Goodin
> Priority: Minor
>
> public int executeUpdate(String sql,int autoGeneratedKeys)
> public boolean execute(String sql,int autoGeneratedKeys)
> public ResultSet getGeneratedKeys()
> We should provide support for jdbc auto generated keys retrieval. This is
> only available in Java 1.4. So, we would have to throw an
> UnsupportedFeatureException if 1.3 or earlier was being used.
> Brandon
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
