When the query returns less than 10000 records, everything works fine and no problem at all.
When the query returns more than 10000(exactly 13,000), after certain no of records the resultSet.next() not moving to next record eventhough there are so many records to be fetched. It doesn't throw any exception either. It's just hanging there like waiting for something to complete. The interesting part is, this failure not happening at the particular record. I ran the test three times for the same input. It failed at 11097th, 11095th and 10218th records.
I have no clue what's causing the problem.
I appreciate your help.
Makesh<br /> <br />SCJP | SCWCD | SCBCD | SCEA
Joined: Jul 17, 2006
should we guess your code, what DDMS you use etc. or are you goin' to tell us?
Makesh Kumar Ramakrishnan
Joined: Jan 07, 2006
Thank you for your response, Herman.
DataBase - Oracle 10.1.0.3 JDK - 1.4.2_03 Application Server - Oracle Application Server 10G 10.1.2.0.2
I am getting database connection from an Application Server Data source. This Data source was created very long time back.
DataSorce JDBC Driver: oracle.jdbc.driver.OracleDriver Data Source class : com.evermind.sql.OrionCMTDataSource