Hibernate Community • View topic - Stored procedure with many input parameters

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Stored procedure with many input parameters

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

danzeu

Post subject: Stored procedure with many input parameters

Posted: Wed Apr 12, 2006 4:24 am

Newbie

Joined: Thu Apr 06, 2006 10:16 am
Posts: 6

Hello

Is there a way to map (in hbm files) the fields from a bean as input parameters for a stored procedure? I mean something like how the mapping is done for the returned result set's columns.

I'm asking this because i'm dealing with a stored procedure who has about 40 input parameters and i wish not to set them manually in code as string parameters: query.setParameter("firstName", fName), query.setParameter("lastName", lName).. etc.

Thank you

Daniel

Top

CWitherow

Post subject:

Posted: Wed Apr 12, 2006 9:01 am

Senior

Joined: Wed Aug 17, 2005 12:56 pm
Posts: 136
Location: Erie, PA (USA)

What about .setProperties(Object bean) method of Query interface? Looks like it does exactly what you are asking for.

Curtis ...

Top

danzeu

Post subject: Stored procedure with many input parameters

Posted: Wed Apr 12, 2006 9:42 am

Newbie

Joined: Thu Apr 06, 2006 10:16 am
Posts: 6

Hello Curtis

Thanx for the tip, it worked

Daniel

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum