No ResultSet set was produced

[Sherif Shehab]

Hi,

what can cause this exception : "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced."


thanks

[Paul Sturrock]

My guess is you are trying to call executeQuery with some SQL that doesn't produce a result set. Can we see your code?

[Sherif Shehab]

here is my Code :

public class UpdateSecondary {
 
DbStuff dbstuff = new DbStuff();
PreparedStatement pS= null ;
ResultSet rS = null;
 
public void GetFromPrimary(String seq) {
 
String args = seq;

Vector<String> vecky = new Vector<String>();
 
String sql = "select * from IVRFINTRAN  where sequence= '" + seq + "'";
 
Connection con = dbstuff.createDbConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver",
"dburl", "dbuser", "dbpass");
 
try {
pS= con.prepareStatement(sql);
rS = pS.executeQuery();
 
while (rS.next()) {
vecky.add(rS.getString(1));
vecky.add(rS.getString(2));
vecky.add(rS.getString(3));
vecky.add(rS.getString(4));
vecky.add(rS.getString(5));
vecky.add(rS.getString(6));
vecky.add(rS.getString(7));
vecky.add(rS.getString(8));
vecky.add(rS.getString(9));
vecky.add(rS.getString(10));
vecky.add(rS.getString(11));
vecky.add(rS.getString(12));
vecky.add(rS.getString(13));
vecky.add(rS.getString(14));
vecky.add(rS.getString(15));
vecky.add(rS.getString(16));
vecky.add(rS.getString(17));
vecky.add(rS.getString(18));
vecky.add(rS.getString(19));
vecky.add(rS.getString(20));
vecky.add(rS.getString(21));
vecky.add(rS.getString(22));
vecky.add(rS.getString(23));
vecky.add(rS.getString(24));
 

System.out.println("Vecky size " + vecky.size());
for (int i = 0; i < vecky.size(); i++) {
System.out.println("Data  " + vecky.indexOf(vecky.get(i)) + "   "
+ vecky.get(i));
}
 
}
 
}
catch (SQLException e) {
System.out.println("Screwed in Sql");
e.printStackTrace();
}
finally
{
try {


rS.close();
pS.close();
con.close();
}
catch (SQLException e) {
System.out.println("error in closing con");
e.printStackTrace();
}
}
UpdateSecondary(vecky.get(0), vecky.get(1), vecky.get(2), vecky.get(3), vecky.get(4), vecky
.get(5), vecky.get(6), vecky.get(7), vecky.get(8), vecky.get(9), vecky.get(10),
vecky.get(11), vecky.get(12), vecky.get(13), vecky.get(14), vecky.get(15), vecky
.get(14), vecky.get(17), vecky.get(17), vecky.get(7), vecky.get(7), vecky
.get(21), vecky.get(22), vecky.get(23));
}
 
public void UpdateSecondary(String seq2, String extno, String trkno, String cifno,
String userid, String acc1, String acc2, String amount, String journal, String menuid,
String status, String date, String time, String coments, String fundcode,
String callid, String fundcodeto, String curfrom, String curto, String amountsar,
String amountto, String trantype, String callerid, String counter)
 
{
String sql2 = "UPDATE IVRFINTRAN SET extno = '" + extno + "'  ,trkno = '" + trkno
+ "'  ,cifno = '" + cifno + "'  ,userid = '" + userid + "'  ,accno1='" + acc1
+ "' ,accno2='" + acc2 + "' ,amount='" + amount + "' ,journal='" + journal
+ "' ,menuid='" + menuid + "' ,status='" + status + "' ,datetrnbeg='" + date
+ "',timetrnbeg='" + time + "' ,coments='" + coments + "' ,fundcode = '" + fundcode
+ "' ,callid='" + callid + "' ,fundcodeto='" + fundcodeto + "' ,curfrom='"
+ curfrom + "',curto='" + curto + "' , amountsar='" + amountsar + "' ,amountto='"
+ amountto + "'  ,trantype='" + trantype + "',callerid='" + callerid
+ "' ,counter='" + counter + "' WHERE sequence = '" + seq2 + "'";
 
Connection con = dbstuff.createDbConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver",
"dburl", "dbuser", "dbpass");
try {
PreparedStatement pS2 = con.prepareStatement(sql2);
ResultSet rS2 = pS2.executeQuery();
 
while (rS2.next()) {
pS2.executeQuery();
System.out.println(" Update Done ");
 
}
}
catch (SQLException e) {
System.out.println("Failed in Update");
e.printStackTrace();
}

}
public static void main(String[] args) {
System.out.println("Put sequ . : ");
Scanner scan = new Scanner(System.in);
// String input = scan.next();
String input = "12176604165 ";// scan.nextLine()";
UpdateSecondary u = new UpdateSecondary();
u.GetFromPrimary(input);
 
}
 
}
    

[Paul Sturrock]

So you are running an update statement? This won't produce a resutls set. Try using execute instead.

[Sherif Shehab]

Originally posted by Paul Sturrock:
So you are running an update statement? This won't produce a resutls set. Try using execute instead.

in this part

 try {
Statement pS2 = con.createStatement();
ResultSet rS2 = pS2.executeQuery(sql2);
 
while (rS2.next()) {
//pS2.executeQuery();
pS2.execute(sql2);
System.out.println(" Update Done ");
 
}
}
catch (SQLException e) {
System.out.println("Screwd in Update");
e.printStackTrace();
}   

i cant use execute because it returns boolean, what do you think?

[Sherif Shehab]

Any suggestions ?

[Paul Sturrock]

i cant use execute because it returns boolean, what do you think?

Why can't you? You were not using the return type anyway, so what's the difference?

(Also, why are you using a Vector to encapsulate your data? Do you need synchronized code? Why not use a custom class?)
[ September 16, 2008: Message edited by: Paul Sturrock ]