Hi,
I am going through a sample of Stored Procedure.

<sql-insert callable="true">{ call createJoinTable(?, ?, ?) }</sql-insert>

but didnt get how to pass paramenters to the procedure. How to define the sequence of parameters. I have read that we should pass the paramters to the Stored Procedure in the same sequence in which Hibernate expects. But didnt get in which sequence does Hibernate expects the parameters.

Can anyone please help me with some sample.

Thanks a lot,
shilpa

I suppose that is sequence how you define id and properties in class

regards

unfortunately it is not.

at some point we logged the generated sql to the debug log, but that seem to have been removed.

until i find a way to get it back you can either look at the sql hibernate uses or simply use a debugger to see what BasicEntityPersister.customSQLxxx variables contain :)

Is it possible to pass objects of different classes to the stored procedure.

e.g.

TeststoredProcedure takes two parameters:
1. Customer.firstName
2. Organization.name

So here we will need to pass 2 objects (each of different class),
can we do this?

Thanks,
shilpa

hibernate assumes your stored procedure follows a similar structure as what delete, insert, update statements would require for data.

if you have more "highlevel stored procedures" which your referring to non-key/id values of related classes indicates then you probably have a better possibliity to write a custompersister that handles your stored proceudres (which is somewhat easy now that the default persisters support callable statements)

it's still there.

if you enable debug logging you should see the entitypersisters dump a set of static sql's from which you should be able to see which sequence hibernate expect the parameters to be in.

Hi,
How to enable debug in log4j.

I have added following to the log4j.properties file,

log4j.logger.net.sf.hibernate.persister.BasicEntityPersister=debug

and the log4j.properties is in my classpath.

Now how to make my program read that log4j.properties file ?

Thanks,
shilpa

if it is the root of your classpath it should do it automatically.