| 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
|
|
 |
|
|
subject: Connection object giving resultset which doesnot match with query when run in anlyzer
|
|
|
0
