| support for large number of records in ResultSet - OracleThin [message #91166] |
Tue, 14 May 2002 09:56  |
Xibin Zeng
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
Hi,
I have a java program that simply issues a query and then does a loop using the returned ResultSet. All I am doing in the loop is calling the next() method. The result set should contain 500,000 records. I found that the program reached 497,216 before next() returned false. Subsequent close() on the Statement object generated this exception:
Exception in thread "main" java.sql.SQLException: Protocol violation
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857)
at oracle.jdbc.ttc7.Oclose.receive(Oclose.java:130)
at oracle.jdbc.ttc7.TTC7Protocol.close(TTC7Protocol.java:533)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:595)
Any body seen this or have some idea? I hate to think that I have hit a limit with the Oracle Thin driver, but the symptom does support the conclusion.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
