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 Stored proceduresand sql-server 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 "Stored proceduresand sql-server" Watch "Stored proceduresand sql-server" New topic

Stored proceduresand sql-server

suzi lu

Joined: Jan 05, 2001
Posts: 17
I have a stored proc which takes 5 parameters , does some manipulation and returns me a record set.How do i call that in JDBC?
callablestatement c = stmt.preparecall("call sp_myproc(?,?,?,?,?)")
and say setXXX for all the five parameters....and say
resultset rs = c.execute()
and then manipulate the resultset???
Am i correct???
Pl help...
John Bateman
Ranch Hand

Joined: Mar 09, 2000
Posts: 320
My only comment to you would be.. what happens when you actually do that?
Let us know IF it doesn't work.

SOURCE CODE should be SURROUNDED by "code" tags.
suzi lu

Joined: Jan 05, 2001
Posts: 17
I mean if I have a stored proc returning a resultset, taking in 5 parameters, then do i have to say, c.registeroutparameter for resultset???(i would say setXXX() for input params anyways)
Pl help me
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
then do i have to say, c.registeroutparameter for resultset???
That's only used if your parameters are defined as out or inout parameters. Your original post had all the required steps.

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
I agree. Here's the link:
subject: Stored proceduresand sql-server
It's not a secret anymore!