function « Insert « JPA Q&A

1. Hibernate: column function on insert/update

Does Hibernate support processing values with database functions for insert and update? My classes contain character representations of Oracle OLS labels which need to be converted to numbers using Oracle's to_data_label function. This function cannot be reproduced in java since the mapping is done via Oracle's OLS policy tables and I do not want to make a separate query to get ...

2. How to use database functions on insert/update

3. Using a function on insert

4. Can I use a SQL Function during insert?

6. executing sql function when inserting

Hi, I need to run a sql function when inserting records. For example for property siblingNumber I want to call a stored procedure which will lookup number of siblings that belong to my parent, and return the correct value. I've looked everywhere and don't seem able to find it. Any ideas? Thanks --MB

7. Data inserted using PL/SQL function not visible for session?

Hibernate version: 3.1.2 Name and version of the database you are using: Oracle 10g We are using Spring + Hibernate with annotated transactions. Session factory is org.springframework.orm.hibernate3.LocalSessionFactoryBean and in our unit testing environment we use org.springframework.jdbc.datasource.DriverManagerDataSource data sources. The problem is that the following (slightly simplified) code doesn't work: Code: public class SomeDaoImpl extends HibernateDaoSupport { @Transactional(readOnly=true) ...