aspose file tools*
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
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: SQL Server with a Select * stored proc