ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Jewell (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-142) JDBC 3 Generated Keys Support
Date Thu, 29 Mar 2007 21:39:25 GMT

    [ 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.

View raw message