It's not a secret anymore!*
The moose likes JDBC and the fly likes SQL Server with a Select * stored proc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server with a Select * stored proc" Watch "SQL Server with a Select * stored proc" New topic
Author

SQL Server with a Select * stored proc

Christian Schnepf
Greenhorn

Joined: Sep 25, 2001
Posts: 28
I have a select * stored proc that I need to access from a jsp page. I am having difficulty setting up the output params and could use a little help. I dont get an error, but I do not get any data either.

Is there something wrong with my prepare or the registerOuts?

Table:


StoredProc:


JavaCode
David Yutzy
tumbleweed and gunslinger
Ranch Hand

Joined: Jun 29, 2001
Posts: 192
Why wouldn't you just read the resulset instead of messing with out parameters?
Christian Schnepf
Greenhorn

Joined: Sep 25, 2001
Posts: 28
I have been unsuccessful finding any examples on getting out put from params or results sets for SQL Server.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server with a Select * stored proc