cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: ValidatorAction cleanup
Date Fri, 13 Jul 2001 16:10:01 GMT
On 13.Jul.2001 -- 08:43 AM, Berin Loritsch wrote:
> > trying to sensibly integrate Informix SERIAL columns into
> > DatabaseAddAction.... Probably a more modular approach to
> > DatabaseAddAction.
> 
> As to this issue, if SERIAL columns generate new id numbers, you might
> want to use the "automatic" mode:
> 
> <table name="ifxTable">
>   <keys>
>     <key param="id" dbcol="department_id" type="int" mode="automatic"/>
>   </keys>
>   <values>
>     <value param="name" dbcol="department_name" type="string"/>
>   </values>
> </table>
> 
> What this does is tell the Database Actions that the "department_id"
> key values will be automatically generated by the database--so it does
> not try to add the information itself.

True, but then I'd like to have the freshly generated ID available --
without an error prone query (think duplicate values, no candidate
keys). Informix requires to do a myStatement.getSerial() after
execution. Oracle needs a query "MYSEQUENCE.current", others need
"@@IDCOLUMN" &c. So I'm working on a module for this. But perhaps a
code generator performs better.

Ah, while we're at it. Did you have a chance to have a look at my
proposed patch for ESQL?

	Chris.

-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message