Hi,
I guess it depends on the jdbc driver of that database...
In case the driver supports then we can create scrollable result sets by creating
Statement object with appropriate constants like ResultSet.TYPE_SCROLL_INSENSITIVE or
ResultSet.TYPE_SCROLL_SENSITIVE whichever suits your requirements...
Statement stmt = connection.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
Now we can loop through the resultset any number of times.
regards
Jayant
-----Original Message-----
From: Abdul jeelani [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 4:51 PM
To: [EMAIL PROTECTED]
Subject: Re: preparedStatement
u r right. You cannot loop thru' resultsets more than once.
Regards,
Abdul
----- Original Message -----
From: "Shahata, Ash" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 4:48 PM
Subject: Re: preparedStatement
I tried this already, but unfortuanltly I get the same result... the problem
seems that rs2 can not be looped through more than once! Is this how result
sets react in general, would I be able to loop through a resultset more than
once?
-----Original Message-----
From: Mathias Höggren [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 11:13 AM
To: [EMAIL PROTECTED]
Subject: SV: preparedStatement
Hi!
I strongly suspect your problem is right here:
if(val1 == val2){
Try this instead:
if (val1.equals(val2)) {
Brgds
Mathias
-----Ursprungligt meddelande-----
Från: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED] Shahata, Ash
Skickat: den 26 februari 2003 12:09
Till: [EMAIL PROTECTED]
Ämne: Re: preparedStatement
I think I figured it out where the problem is, it'a not from the code that I
sent it's to do with the rs.next! However I still couldnt fix it. The value
of tname is passed correctly and when I retireve it on its own, it works
fine. Here's the part of the code that is causing the problem:
while (rs.next()){
out.println("Inside rs");
while(rs2.next()){
out.println("Inside rs2");
String val1 = rs.getString(2);
String val2 = rs2.getString(2);
if(val1 == val2){
out.println("Inside IF");
String id2 = rs2.getString(1);
out.println("Sybase Customer Name = " +
rs2.getString("swName"));
out.println(" | id = " + id2 + "<br>");
}//if
}//while(rs2.next())
}//while(rs.next())
I'm looping through both result sets, expecting to see rs2 looping several
times for every value of rs1, but here's what I grt from my println:
These Records appear on both systems
Inside rs Inside rs2 Inside rs2 Inside rs2 Inside rs2 Inside rs2 Inside rs2
Inside rs2 Inside rs Inside rs Inside rs
Any idea why the loop is not functioning as expected?
Thanks
-----Original Message-----
From: Pillai Jaideep, App Spec, SCS-SD [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 10:18 AM
To: [EMAIL PROTECTED]
Subject: Re: preparedStatement
R U sure tname variable holds exactly the value U want ?
-----Original Message-----
From: Shahata, Ash [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 5:50 PM
To: [EMAIL PROTECTED]
Subject: preparedStatement
Hi there,
I'm getting stuck with the following procedure using prepared statements..
it works just fine if I use a normal statement. I need to pass a prepared
statement because I need to pass a valriable to the query. It does not
return any records!
Statement stmt = con1.createStatement();
String query = "Select * from SW_Customer where swName = ?";
PreparedStatement ps = con1.prepareStatement(query);
ps.setString(1,tname);
ResultSet rs = ps.executeQuery();
while (rs.next()){
String name = rs.getString(1);
out.println("Value of field = " + rs.getString("swName"));
out.println("Value of field = " + name);
}
Any help will be appreciated
Thanks
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
=========================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
==========================================================================To
unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
