HI

I am new to hibernate implementation; I did normal insertions (just simple insert queries) with hibernate successfully. I struck up with a problem where I need to insert data with sub query (dynamic).

Query is:
INSERT INTO "CREDIT_CARD" (CNUMBER,CTYPE, EXPDATE,CUID,LAST_UPDATE) VALUES ((select tcrypt.tencrypt('234509873333') from dual),'AMEX','060627',43903873,sysdate);

Here my question is how can I execute “select tcrypt.tencrypt('234509873333') from dual” which is inside a Query.

I did one way is that, writing this as Native SQL and insert into data base.

Please suggest is there any alternative to execute the above query.

Thanks in advance
[/quote]

Hello

Have a look here: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/index.html#mapping-column

And have a look at:


Maybe this is what you are looking for.

Regards!
Adam

PS.
Rate if this helps.

Hi Adam,
Thanks for you reply,
I tried like below in the mapping file and it is not succeeded
<property name="card_number" formula="(select tcrypt.tencrypt(card_number) from dual)" >
<column name="CNUMBER"/>
</property>

If I wrongly understood please let me know

Thanks in advance

Try removing the VALUES clause:



Also note that when using HQL the VALUES clause isn't supported. Quoting from http://www.hibernate.org/hib_docs/v3/re ... tch-direct

Hi gwiley,
Thanks for your reply,
Can we do the same functionality using Hibernate mapping file i.e Object level.
Thanks in advance