PearlJamFanatic
asked on
code is stuck but works when run in debug mode
I working on a piece of code that
1) Reads table from syabse 12, sybase 15 and oracle 11
2) Dumps the resultset in csv file using opencsv
3)compares the open csv files and reports mismatch in another csv
The code runs n a loop for about 92 tables. some of these tables have millions (2-5 million) records. I ran it yesterday before leveing for home but i found it stuck today morning. No exceptions thrown. Now when I running it after inserting a few break points here and there i can get it to work. But when i run 'run as java application' from eclipse it's getting stuck.
How can i debugg this code. The class is attached as file TableComparator.txt.
TableComparator.txt
1) Reads table from syabse 12, sybase 15 and oracle 11
2) Dumps the resultset in csv file using opencsv
3)compares the open csv files and reports mismatch in another csv
The code runs n a loop for about 92 tables. some of these tables have millions (2-5 million) records. I ran it yesterday before leveing for home but i found it stuck today morning. No exceptions thrown. Now when I running it after inserting a few break points here and there i can get it to work. But when i run 'run as java application' from eclipse it's getting stuck.
How can i debugg this code. The class is attached as file TableComparator.txt.
TableComparator.txt
ASKER
No I had not tried it for more than one table before.
So it actually worked only in debugging mode?
I downloaded opencv fine,
but I could not find these things:
import com.fil.im.replicationtest er.util.Co nstants;
import com.fil.im.replicationtest er.util.Db Util;
Well, even if I compile, I'd not be able to try it as I don't have Sybase and your tables.
I downloaded opencv fine,
but I could not find these things:
import com.fil.im.replicationtest
import com.fil.im.replicationtest
Well, even if I compile, I'd not be able to try it as I don't have Sybase and your tables.
What means it is getting stuck?
Add some pruintouts to understand what it is doing
Add some pruintouts to understand what it is doing
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How can i take thread dump
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and don't run it from eclipse, its just going to confuse the issue
If you run it from command line you should type ctrl-break in the DOS window
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you did change something before you ran it yesterday?
Sorry, please, explain, it is important to unsderstand.
Can you also post exactly waht opncsv jar you used and the link if possible.
I'd like to at least try to compile your code.