aspose file tools*
The moose likes JDBC and the fly likes Getting Error establishing socket. while running the application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Getting Error establishing socket. while running the application " Watch "Getting Error establishing socket. while running the application " New topic
Author

Getting Error establishing socket. while running the application

Divya Gehlot
Ranch Hand

Joined: Sep 10, 2006
Posts: 243
Hi,
Can Any one help me as I getting the following error while inserting data into database for some rows . I googled but but didnt get any proper solution.
Soultion what I got it is
1) turn off windows firewall.
2) change server TCP/IP settings.
3) It will give probelm with windows XP SP 2
I tried all but didnt able to solve that.
I am using Java 1.5, MSSQL server 2000,and eclipse 3.2,windows XP SP2
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.aztecsoft.quality.DatabaseConnectionQLTYSRV.getCon(DatabaseConnectionQLTYSRV.java:25)
at com.aztecsoft.quality.DatabaseQuery.getDaytoCountRow(DatabaseQuery.java:147)
at com.aztecsoft.quality.ProjectTrackerUtil.getNetworkDays(ProjectTrackerUtil.java:73)
at com.aztecsoft.quality.ProjectPlan.calODurationinDays(ProjectPlan.java:81)
at com.aztecsoft.quality.ProjectPlan.projectSummary(ProjectPlan.java:25)
at com.aztecsoft.quality.ProjectPlan.main(ProjectPlan.java:126)

Thanks in advance.
[ November 15, 2007: Message edited by: Divya Gehlot ]

SCJP1.5(81%), SCDJWS(94%), next mission SCEA (but need to wait or that)
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Getting Error establishing socket. while running the application