File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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

how to pass arrayList to calling Procedure

dilip sarode

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

CallableStatement cs = conn.prepareCall("{call updateSallary(?,?,?)}");

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

Joined: Aug 03, 2008
Posts: 9453

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

Joined: Oct 13, 2005
Posts: 45358
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?
I agree. Here's the link:
subject: how to pass arrayList to calling Procedure
It's not a secret anymore!