This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes how to pass arrayList to calling Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to pass arrayList to calling Procedure " Watch "how to pass arrayList to calling Procedure " New topic
Author

how to pass arrayList to calling Procedure

dilip sarode
Greenhorn

Joined: Jan 11, 2010
Posts: 1
Hi ,
i am using

CallableStatement cs = conn.prepareCall("{call updateSallary(?,?,?)}");
cs.registerOutParameter(1,Types.INTEGER);
cs.registerOutParameter(2,Types.INTEGER);
cs.registerOutParameter(3,Types.VARCHAR);

and i have to pass arrayList to the 2,Types.INTEGER.

how to pass it. and then get from procedure


Thanks a lot.
Ankit Garg
Sheriff

Joined: Aug 03, 2008
Posts: 9400
    
  20

Hi Dilip, welcome to javaranch.

This question has nothing to do with Servlets, so I'll move it to the more appropriate forum for you...


SCJP 6 | SCWCD 5 | Javaranch SCJP FAQ | SCWCD Links
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 43905
    
  33
Do you mean you have a List<Integer> which you want to get 3 elements out of, or are you passing a List<Integer> to the no 2 parameter?
 
Have you checked out Aspose?
 
subject: how to pass arrayList to calling Procedure
 
jQuery in Action, 3rd edition