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.
Thanks,
Makesh
Makesh<br /> <br />SCJP | SCWCD | SCBCD | SCEA
Herman Schelti
Ranch Hand
Joined: Jul 17, 2006
Posts: 387
posted
0
hi Makesh,
should we guess your code, what DDMS you use etc. or are you goin' to tell us?
Herman
Makesh Kumar Ramakrishnan
Ranch Hand
Joined: Jan 07, 2006
Posts: 88
posted
0
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
PreparedStatement and its executeQuery are used in the function code.
Perhaps the Oracle JDBC Trace Facility will help if you enable it.
SCJP 1.4, SCWCD 1.3, SCBCD 1.3
Makesh Kumar Ramakrishnan
Ranch Hand
Joined: Jan 07, 2006
Posts: 88
posted
0
This issue is fixed. The cause of this issue is memory problem. JDBC didn't throw any out of memory error, that made this problem difficult to debug.Thanks for your time ranchers.
0
