hi,
I have a java program that uses oracle thin driver to connect to Oracle 9i db on unix box. If there is only 2000 records to process, the program works like a charm. However, when I tried to process 30000, after 5 minutes or so, I get a sqlexception:network adapter cannot establish connection to the server. is there any attribute that i need to add to tnsnames.ora or other ideas?
thanks,
max p.
~za~
You can't bring back a dead thread!
I have a java program that uses oracle thin driver to connect to Oracle 9i db on unix box. If there is only 2000 records to process, the program works like a charm. However, when I tried to process 30000, after 5 minutes or so, I get a sqlexception:network adapter cannot establish connection to the server. is there any attribute that i need to add to tnsnames.ora or other ideas?
thanks,
max p.
~za~
You can't bring back a dead thread!