Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

My code:

import java.sql.*;

public class DBMain {

public static void main(String[] args) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://E70F8DAF84124E3:1433" , "RECEP",
"reco");

} catch (Exception e) {
e.printStackTrace();
}
}
}


Console Output:
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 DBMain.main(DBMain.java:22)

Help please...[/u]

does this even relate to hibernate??

a personal firewall can prevent your program from binding to a socket if your firewall has it shut off

Thank you for reply but I have shut down my firewall. I tried it. on the other hand, my operatig system is windows xp service pack 2. It may be cause that problem but I couldnt found anyway....

try:

1)enable all protocols in client(cliconfg.exe) and server(svrnetcn.exe)
2)update SQlSERVER to last sp.
3)use jtds driver http://jtds.sourceforge.net/

One of the simplest tests for connection issues is to trying a telnet to port 1433. If you don't get a connection, either there's a firewall of some sort in the way blocking you or the service is not currently running on the target host.

BTW, I used the jTDS driver with Hibernate v3.0 on a recent project without any connection issues to SQL Server. I worked with someone who had tried using the MS JDBC driver and did not recommend them due to performance issues and bugs. Your mileage may vary of course.