Home » Developer & Programmer » JDeveloper, Java & XML » support for large number of records in ResultSet - OracleThin
support for large number of records in ResultSet - OracleThin [message #91166] Tue, 14 May 2002 09:56 Go to next message
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.
Re: support for large number of records in ResultSet - OracleThin [message #91167 is a reply to message #91166] Tue, 14 May 2002 10:13 Go to previous message
Xibin Zeng
Messages: 2
Registered: May 2002
Junior Member
By the way, the server is Oracle 8i and I downloaded the latest classes12.zip.

Thanks!
Previous Topic: Re: Urgent: Please help to automate password within batch files.
Next Topic: Java Store Procedure for sending email
Goto Forum:
  


Current Time: Mon Jul 26 12:12:15 CDT 2021