Before inserting card number into database, I need to perform encryption using below formula.

In Mapping I did like below

<property name="card_number" formula="(select tcrypt.tencrypt(card_number) from dual)" >
<column name="CNUMBER"/>
</property>


In the bean
Creditcard cardobj = new Creditcard();
cardobj.setCard_type("VISA");
cardobj.setCard_number("234509873333");


It is inserting null value.

Please suggest me where I am doing mistake.

Thanks in Advance

Formula on property is used when an evaluation result is needed, there is no column mapped to this kind of property.

For your need, you can use a custom UserType.
You can have a look to http://www.jasypt.org/, it offers some encrypted usertypes.