Hi,

It is postgresql with serial (autoupdate/autoincrement key) option.
For example:
CREATE TABLE OS (
  ID_os SERIAL NOT NULL CHECK (ID_os > 0),
  Major_type VARCHAR(20) NOT NULL,
  Sub_type VARCHAR(20) NULL,
  Minor_type VARCHAR(20) NULL,
  Maintanance_level VARCHAR(6) NULL,
  PRIMARY KEY(ID_os)
);

Michal

Dne sobota 13 květen 2006 14:36 James, Steven napsal(a):
> Depend son the database but if it is an auto key just use the select key
> tag. Have a look at the documentation on page 15.
>
> http://cvs.apache.org/dist/ibatis/ibatis.java/docs/iBATIS-SqlMaps-2.pdf
>
>
> ________________________________
>
> From: CIJOML [mailto:[EMAIL PROTECTED]
> Sent: Sat 13/05/2006 13:32
> To: [email protected]
> Subject: how to get ID from relation table?
>
>
>
> Hello,
>
> I am new to iBatis and I need fill in value into table with foreign key.
> How can I get ID from relation table filled before this table? Does ibatis
> return this value for me?
>
> For example:
> Table person with personId, firstName, surName
> Table Address with addressId, personId (foreign key), streetName, etc
>
> Now I am able to insert/udpdate/delete rows in person table, but need also
> fill in relation table.
>
> Thanks a lot
>
> Michal
>
>
>
>
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be copied,
> disclosed to, retained or used by, any other party. If you are not an
> intended recipient then please promptly delete this e-mail and any
> attachment and all copies and inform the sender. Thank you.

Reply via email to