hibernate session init

[nyname00]

Hi!

Is there a way to execute some code right after a hibernate session is created? My problem is that i have to call a stored procedure (one-time per session) before any create/update statement is executed. Else my create/update statements won't work.

Thanks in advance for any help!

[gschmutz]

Can't help you about Hibernate, but if you're working against an Oracle database, why don't you use an ON LOGON system trigger, which will always fire after a session is created.
Will of course also only fire once for a pooled connection.

[nyname00]

Thanks !

Think i'll give it a try but our db admins won't be happy :(

Although I hoped I could manage it within spring/hibernate.
Experimented a bit with hibernate's Interceptor but this seems to be the wrong approach. Maybe anyone knows something similar which could help me.

[Ben Alex]

Maybe it's unsuitable, but we add seed data by a simple bean that implements InitializingBean.

[nyname00]

Tried it, but the problem is that the session gets closed
between the bean's initialization and the save/update call.

But it was a good hint anyway. I think it could sovle some other problems ...

thanks

[Colin Sampaleanu]

Hi!

Is there a way to execute some code right after a hibernate session is created? My problem is that i have to call a stored procedure (one-time per session) before any create/update statement is executed. Else my create/update statements won't work.

Thanks in advance for any help!

You should be able to wrap the SessionFactory you are using in a spring interceptor (take a look at the spring manual) which when the session factory is asked to create a new session, does create the session, then either uses it or spring jdbc to call your stored proc...