Hi everybody.

I need some help

I have a class with attributes: int id and String name.

I have Oracle Stored Procedure getstudents (In Id, OUT Name)

For a give In Parameter ID , the out parameter name will be generated.

Things are working well from JDBC, but I need to implement it through Hibernate.

If any body can show the xml amapping and code snippets it will be of great help to me.

Note : I have already gone thru all the meterials available but I cannot exactly understand the mapping of In and and out parameters.

Thanks
Niel

as the documentation EXPLICITLY states we currently only support stored procedures that returns a resultset.

btw. is your storedprocedure really named getStudents and not getStudent ? I'm curious since people do weird things with stored procedures and were wondering if you did something "weird" to return multiple students or ?

Hi Max,

Sorry for the typo, its getStudent , drop the s. The procedure in no way returns any list.

I am bit disappointed but I dont want to dump Hibernate for one such small shortcoming.

But I get into another problem then, if I keep Hibernate, I have to do the plain JDBC stuff through Hibernate for stored procedures.

Do you think there is any way to do the jdbc stuff through Hibernate? Please ignore typos.

Thanks a lot for earlier reply. I am adding the jdbcd code snippet which you can see and comment.

with warm regards
Niel


Connection con = DriverManager.getConnection( "jdbc:oracle:thin:@something ", "scott" ,"tiger");

CallableStatement stmt = con.prepareCall("{call getstudent(?,?)}");

// Here I am setting the Student Id
stmt.setInt(1, 7844);

stmt.registerOutParameter(2, java.sql.Types.VARCHAR);
stmt.executeQuery();

// Here I am getting the Student Name from out parameter.
System.out.println("Name " + stmt.getString(2));

you can always add a stored procedure that wraps your procedure to make it return a resultset.

In a future version we will attempt support simple out bindings.

session.connection()