Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle jdbc loses network connection after a while

Status
Not open for further replies.

maxpower1

Programmer
Jul 29, 2001
488
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top