File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Error establishing Socket Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Error establishing Socket" Watch "Error establishing Socket" New topic

Error establishing Socket

saravana R rajan J

Joined: May 28, 2007
Posts: 1
Hi All,

I am running an application in JBoss server, and the application is written using struts, jbdc.

I am getting this exception, when more number of users logging in. Otherwise it is working fine.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Thanks in advance for your replies.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32089

Welcome to JavaRanch!

You could be running out of connections. Verify that you are always calling conn.close() in a finally block and not holding connections longer than necessary.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Jan Cumps

Joined: Dec 20, 2006
Posts: 2535

Do you have SQLServer 2000 sp3 installed?
Sp3 resolves several tcp/ip issues.

Regards, Jan

OCUP UML fundamental and ITIL foundation
youtube channel
subject: Error establishing Socket