[mapping] Calculated values in insert statement

standard · **Joined:** Tue Oct 03, 2006 6:28 am **Posts:** 9

Hi,
I've got a table like this:
TABLE_A:
- ID
- LINK_TYPE
- LINK_PROG
- ENTITY

When I have to insert in this table I'd like to produce this sql statment (I work on an Oracle10 DB):

INSERT INTO TABLE_A
VALUES (?, ?, SELECT MAX(LINK_PROG)+1 WHERE ID=? AND LINK_TYPE=?, ?)

How can obtain this with mapping? Is it possible?
Which is the best solutions?

standard · **Joined:** Tue Oct 03, 2006 6:28 am **Posts:** 9

standard · **Joined:** Tue Oct 03, 2006 6:28 am **Posts:** 9

Nothing?

kochcp · **Posted:** Fri Oct 27, 2006 3:53 pm

you can define the save statements, check here

http://www.hibernate.org/hib_docs/v3/re ... erysql-cud

standard · **Joined:** Tue Oct 03, 2006 6:28 am **Posts:** 9

mmm...good
I'm going to try!

thanks a lot!