This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Spring and the fly likes passing a list to a stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "passing a list to a stored procedure" Watch "passing a list to a stored procedure" New topic

passing a list to a stored procedure

Raaja Gotluru
Ranch Hand

Joined: Mar 02, 2010
Posts: 118

I have a situation where I need to pass a ArrayList object to a stored procedure which contains objects of hibernate pojos with values and iterate that in the stored procedure to insert the values and I am trying like this

This list might contain atleast 10000 records but in stored procedure I am not able to handle this list. If I give input parameter as of type object[] then I cant get values from the hibernate pojos. How to achieve this can anyone help.

I agree. Here's the link:
subject: passing a list to a stored procedure
It's not a secret anymore!