You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Gabriel Belingueres (JIRA)" <ib...@incubator.apache.org> on 2009/06/05 00:13:07 UTC

[jira] Created: (IBATIS-605) add INFORMIX special predefined value for ibator's tag

add INFORMIX special predefined value for ibator's <generatedKey> tag
---------------------------------------------------------------------

                 Key: IBATIS-605
                 URL: https://issues.apache.org/jira/browse/IBATIS-605
             Project: iBatis for Java
          Issue Type: Improvement
          Components: Tools
         Environment: ibator plugin for eclipse
            Reporter: Gabriel Belingueres
            Priority: Trivial


Hi,

For Informix databases (at least in v9.x and 10.x) the following is tested to work:

    	<generatedKey column="the_serial_id" 
    		sqlStatement="select dbinfo('sqlca.sqlerrd1') from systables where tabid=1"
    		identity="true"/>

(it must be executed AFTER the insert statement.)

May it be added as a predefined constant as other databases? (see http://ibatis.apache.org/docs/tools/ibator/configreference/generatedKey.html)

Regards,
Gabriel

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (IBATIS-605) add INFORMIX special predefined value for ibator's tag

Posted by "Jeff Butler (JIRA)" <ib...@incubator.apache.org>.
     [ https://issues.apache.org/jira/browse/IBATIS-605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Butler closed IBATIS-605.
------------------------------

    Resolution: Fixed

Fixed in SVN.

Thanks!


> add INFORMIX special predefined value for ibator's <generatedKey> tag
> ---------------------------------------------------------------------
>
>                 Key: IBATIS-605
>                 URL: https://issues.apache.org/jira/browse/IBATIS-605
>             Project: iBatis for Java
>          Issue Type: Improvement
>          Components: Tools
>         Environment: ibator plugin for eclipse
>            Reporter: Gabriel Belingueres
>            Assignee: Jeff Butler
>            Priority: Trivial
>
> Hi,
> For Informix databases (at least in v9.x and 10.x) the following is tested to work:
>     	<generatedKey column="the_serial_id" 
>     		sqlStatement="select dbinfo('sqlca.sqlerrd1') from systables where tabid=1"
>     		identity="true"/>
> (it must be executed AFTER the insert statement.)
> May it be added as a predefined constant as other databases? (see http://ibatis.apache.org/docs/tools/ibator/configreference/generatedKey.html)
> Regards,
> Gabriel

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.