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 Need some serious help THANK U ALL 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 "Need some serious help THANK U ALL" Watch "Need some serious help THANK U ALL" New topic

Need some serious help THANK U ALL

john mattucci
Ranch Hand

Joined: Nov 03, 2000
Posts: 331
Calling a stored procedure which returns multiple result sets. My problem which I cant seem to figure out; when I call cs.getResultSet() all result sets are returned ie 4. Im using ThinWeb Technologies(tm) Driver Version 1.3 for MS SQL Server. Why is this happening???
CallableStatement cs = myCon.prepareCall("{call initial_info (?)}");
cs.setInt(1, InfoGetter.locationInt);
boolean success = cs.execute();
int i = 0;
myRs = cs.getResultSet();
information[i] = new Vector();
if(i == 0 || i == 1)
information[i].addElement(new Integer(myRs.getInt(1)));
else if(i == 2)
else if(i == 3)
Object o[] = new Object[2];
o[0] = myRs.getString(1);
o[1] = new Integer(myRs.getInt(2));
success = cs.getMoreResults();
CREATE PROC initial_info(@location int)
SELECT .....;
SELECT ....;
I agree. Here's the link:
subject: Need some serious help THANK U ALL
It's not a secret anymore!