File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connection object giving resultset which doesnot match with query when run in anlyzer Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection object giving resultset which doesnot match with query when run in anlyzer" Watch "Connection object giving resultset which doesnot match with query when run in anlyzer" New topic
Author

Connection object giving resultset which doesnot match with query when run in anlyzer

sameer K
Greenhorn

Joined: Oct 09, 2002
Posts: 5
createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY)
is used to run the query same query gives some results but in java application it is returning false on resultset.next() also results are returned properly we use createStatement() i.e no parameters.
what may be the problem?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

what database/jdbc driver team are you using? What is the query? what is the java code?
sameer K
Greenhorn

Joined: Oct 09, 2002
Posts: 5
query is simple 'select * from Employee' this query returns some results in SQL query analyzer. but when run in servlet using createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY) results in no rows (Resultset.next() is false) but returns some results if resultSet is obtained through statement created from createStatement() method.
what is the problem?
sameer K
Greenhorn

Joined: Oct 09, 2002
Posts: 5
sorry, i forgot to provide following info
driver= sun.jdbc.odbc.JdbcOdbcDriver
db=MSSQL 2000
 
wood burning stoves
 
subject: Connection object giving resultset which doesnot match with query when run in anlyzer