This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Stored proceduresand sql-server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stored proceduresand sql-server" Watch "Stored proceduresand sql-server" New topic
Author

Stored proceduresand sql-server

suzi lu
Greenhorn

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...
Tx,
Suzi
John Bateman
Ranch Hand

Joined: Mar 09, 2000
Posts: 320
Hey
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
Greenhorn

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
Tx,
Suzi
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Stored proceduresand sql-server
 
Similar Threads
JDBC
Stored Procedures
getting ResultSet from Oracle procedure
@NamedNativeQuery and choosing the correct resultClass
How resultset is returned by stored procedure?