Custom SQL for CRUD with annotations

alsayno · **Posted:** Mon Jun 13, 2005 4:51 am

hi!

in hibernate3 there is the possiblity to use custom sql queries for
CRUD operations.
is it also possible to define this with annotations?

thx

Marcos Silva Pereira · **Posted:** Tue Jun 14, 2005 7:19 pm

alsayno wrote:

hi!

in hibernate3 there is the possiblity to use custom sql queries for
CRUD operations.

Yes, please, read the following chapter from docs:
17.4. Custom SQL for create, update and delete

alsayno wrote:

is it also possible to define this with annotations?

thx

No yet!

valeuz...

emmanuel · **Posted:** Thu Jun 16, 2005 8:58 pm

patch welcome

Marcos Silva Pereira · **Posted:** Fri Jun 17, 2005 3:24 pm

I think that put custom crud sql in annotations is not a good idea. First because it is a dba task and second because alter some sql will require a new compilation of code. Anyway, it could be useful because for now you cannot mix (for the same class) XML and annotations mapping.

valeuz...

emmanuel · **Posted:** Wed Jun 22, 2005 6:52 am

Well since you're packaging your xml files anyway, extra compilation usually doesn't hurt.

Marcos Silva Pereira · **Posted:** Thu Jun 30, 2005 1:46 pm

emmanuel wrote:

Well since you're packaging your xml files anyway, extra compilation usually doesn't hurt.

Right, how do you plan to do it? Maybe using a package-info could be a good approach.

best regards