Hello!

We have an application architecture where all select, insert, update and delete are made by a PL/SQL procedure. It means, for getting a lista of customers, I call a procedure Get_Customers in the database. And to update a customer I call Update_Customers.
Dows hibernate can help me in this? I mean, I would like to call session.load and have my Customer object filled, doesn't matter if it was by a procedure call or a select.
Is there any way of doing this?

Thanks,
JP

Try to create views and "instead of" triggers to "hide" procedures if possible.

for hibernate 2.1.x: write a custom persister

for hibernate 2.2: more or less direct support for custom sql and stored procedure is on the roadmap.

(though, custom selects with storedproceudere is far away since the different jdbc drivers cannot agree on how to make a stored procedure/function return a result set! ;(

I didn't understand what baliukas mean "Try to create views and "instead of" triggers to "hide" procedures if possible". Can you, please, explain me?

About the custom persister, is it possible to write a Custom Persister only to inser, update and delete and keep using the hibernate persister for select statements?

Thanks

yes.

look at the interface - there is insert, update, delete methods you just need to handle....

You can call procedure in view:

CREATE VIEW MyView AS ( SELECT * FROM mySelectProcedure() );

CREATE TRIGGER MyTrigger
INSTEAD OF INSERT ON MyView
REFERENCING NEW AS n
FOR EACH ROW
BEGIN
CALL myInsertProcedure(n);
END;