Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes MSSQL7.0 resultset bug? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MSSQL7.0 resultset bug?" Watch "MSSQL7.0 resultset bug?" New topic
Author

MSSQL7.0 resultset bug?

omar khan
Ranch Hand

Joined: Feb 01, 2001
Posts: 183
Hello everybody.
I am using JDK1.3.0 and MSSQL7.0 on Win NT4.0
I stepped into a strange problem. I was wondering if anyone has eperienced it yet. The problem is this:
rs is a resultset
while (rs.next())
{
somecode
}
gives me a cursor error but
boolean mybool = rs.next();
while (mybool)
{
somecode
mybool=rs.next();
}
works ok
funny, isn't it?
[This message has been edited by OMAR KHAN (edited September 26, 2001).]
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Sounds pretty strange...never heard of that one before! Are you sure you are not just overlooking a programming error?? Post the offending code along with the error message and maybe someone can sniff out an overlooked problem for you.
Jamie
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MSSQL7.0 resultset bug?
 
Similar Threads
JDBC Problem
jsp resultset
ResultSet
exhausted ResultSet
scrollable result sets