Error connecting to MSSQL Server from Hibernate

[Sushma Sharma]

HI All,

I am newbie to Hibernate and i m trying one of tutorials. problem is that I am getting the following error when I run my application

 
INFO  - using java.io streams to persist binary types
INFO  - using CGLIB reflection optimizer
INFO  - using JDK 1.4 java.sql.Timestamp handling
INFO  - configuring from resource: /hibernate.cfg.xml
INFO  - Configuration resource: /hibernate.cfg.xml
INFO  - Reading mappings from resource: hibernate\event\Event.hbm.xml
INFO  - Mapping class: hibernate.event.Event -> EVENTS
INFO  - Configured SessionFactory: null
INFO  - processing extends queue
INFO  - processing collection mappings
INFO  - processing association property references
INFO  - processing foreign key constraints
INFO  - Using Hibernate built-in connection pool (not for production use!)
INFO  - Hibernate connection pool size: 1
INFO  - autocommit mode: false
INFO  - using driver: com.microsoft.jdbc.sqlserver.SQLServerDriver at URL: jdbc:microsoft:
sqlserver://localhost:1433;databseName=master;selectMethod=cursor
INFO  - connection properties: {user=Administrator, password=****}
WARN  - Could not obtain connection metadata
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socke
t.
        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 org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverMa
nagerConnectionProvider.java:110)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1502)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1031)
        at hibernate.event.HibernateUtil.<clinit>(HibernateUtil.java:13)
        at hibernate.event.EventManager.store(EventManager.java:28)
        at hibernate.event.EventManager.main(EventManager.java:13)
INFO  - Using dialect: org.hibernate.dialect.SQLServerDialect
INFO  - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
INFO  - No TransactionManagerLookup configured (in JTA environment, use of read-write or t
ransactional second-level cache is not recommended)
INFO  - Automatic flush during beforeCompletion(): disabled
INFO  - Automatic session close at end of transaction: disabled
INFO  - Scrollable result sets: disabled
INFO  - JDBC3 getGeneratedKeys(): disabled
INFO  - Connection release mode: null
INFO  - Maximum outer join fetch depth: 1
INFO  - Default batch fetch size: 1
INFO  - Generate SQL with comments: disabled
INFO  - Order SQL updates by primary key: disabled
INFO  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO  - Using ASTQueryTranslatorFactory
INFO  - Query language substitutions: {no='N', true=1, yes='Y', false=0}
INFO  - Second-level cache: enabled
INFO  - Query cache: disabled
INFO  - Cache provider: org.hibernate.cache.HashtableCacheProvider
INFO  - Optimize cache for minimal puts: disabled
INFO  - Cache region prefix: hibernate.test
INFO  - Structured second-level cache entries: disabled
INFO  - Echoing all SQL to stdout
INFO  - Statistics: disabled
INFO  - Deleted entity synthetic identifier rollback: disabled
INFO  - Default entity-mode: pojo
INFO  - building session factory
INFO  - Not binding factory to JNDI, no JNDI name configured
INFO  - Running hbm2ddl schema update
INFO  - fetching database metadata
ERROR - could not get database metadata
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socke
t.
        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 org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverMa
nagerConnectionProvider.java:110)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:126)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:297)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1033)
        at hibernate.event.HibernateUtil.<clinit>(HibernateUtil.java:13)
        at hibernate.event.EventManager.store(EventManager.java:28)
        at hibernate.event.EventManager.main(EventManager.java:13)
ERROR - could not complete schema update
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socke
t.
        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 org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverMa
nagerConnectionProvider.java:110)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:126)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:297)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1033)
        at hibernate.event.HibernateUtil.<clinit>(HibernateUtil.java:13)
        at hibernate.event.EventManager.store(EventManager.java:28)
        at hibernate.event.EventManager.main(EventManager.java:13)
INFO  - cleaning up connection pool: jdbc:microsoft:sqlserver://localhost:1433;databseName
=master;selectMethod=cursor
INFO  - Checking 0 named queries
WARN  - SQL Error: 0, SQLState: 08001
ERROR - [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
WARN  - SQL Error: 0, SQLState: HY000
ERROR - [Microsoft][SQLServer 2000 Driver for JDBC]Connection refused: connect
org.hibernate.exception.JDBCConnectionException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:66)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43
)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29
)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:301)
 
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:136)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49)
        at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransacti
onFactory.java:24)
        at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:264)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1070)
        at hibernate.event.EventManager.store(EventManager.java:29)
        at hibernate.event.EventManager.main(EventManager.java:13)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
shing 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 org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverMa
nagerConnectionProvider.java:110)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
 
        ... 8 more

I have specified all the details needed to connect to MS SQL Server in hibernate.cfg.xml and hibernate.properties both. below is the code for both

hibernate.cfg.xml

  
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 
 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
 
    <session-factory>
        <property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
        <property name="hibernate.connection.url">jdbc:microsoft:sqlserver://localhost:1433;databseName=master;selectMethod=cursor</property>
        <property name="hibernate.connection.username">Administrator</property>
        <property name="hibernate.connection.password"></property>
        <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
        <property name="show_sql">true</property>
        <property name="transaction.factory_class">
             org.hibernate.transaction.JDBCTransactionFactory
        </property>
        <property name="hibernate.cache.provider_class">
             org.hibernate.cache.HashtableCacheProvider
        </property>
        <property name="hibernate.hbm2ddl.auto">update</property>
 
        <mapping resource="hibernate\event\Event.hbm.xml"/>
 
    </session-factory>
 
</hibernate-configuration>
 

hibernate.proerties

  
######################
### Query Language ###
######################
 
## define query language constants / function names
 
hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'
 
 
## select the classic query parser
 
#hibernate.query.factory_class org.hibernate.hql.classic.ClassicQueryTranslatorFactory
 
 
#################
### Platforms ###
#################
 
## HypersonicSQL
 
hibernate.dialect org.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class com.microsoft.jdbc.sqlserver.SQLServerDriver
hibernate.connection.username Administrator
hibernate.connection.password 
hibernate.connection.url jdbc:microsoft:sqlserver://localhost:1433;databseName=master;selectMethod=cursor
 
#################################
### Hibernate Connection Pool ###
#################################
 
hibernate.connection.pool_size 1
 
##############################
### Proxool Connection Pool###
##############################
 
## Properties for external configuration of Proxool
 
hibernate.proxool.pool_alias pool1
 
##############################
### Miscellaneous Settings ###
##############################
 
## set the maximum depth of the outer join fetch tree
 
hibernate.max_fetch_depth 1
 
#####################
### JDBC Settings ###
#####################
 
## enable batch updates even for versioned data
 
hibernate.jdbc.batch_versioned_data true
 
 
## use streams when writing binary types to / from JDBC
 
hibernate.jdbc.use_streams_for_binary true
 
 
##########################
### Second-level Cache ###
##########################
 
## set a prefix for cache region names
 
hibernate.cache.region_prefix hibernate.test
 

Please tell me what am I doing wrong....
Any suggestions are welcome

Regards

Sushma

[Paul Sturrock]

Do you have a login defined in MSSQL called 'Administrator' which requires no password? This seems unlikely, since as far as I'm aware you can't define a login with no password.

[Sushma Sharma]

yes, my username id Administrator and it doesn't have a password. Actually, its my windows password and I am using the windows login for MS SQL Server also.... is that a problem? I am able to connect to MS SQL Server. I am not sure why I am getting

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


Is this because of password is empty?
I'll try creating some other user and try with that...

[Pavan Tummala]

jdbc:microsoft:sqlserver://localhost:1433;

 databseName

=master;selectMethod=cursor

typo???

[Hiroshi Tominaga]

Hi,
Did you check if the SQL servers has the 1433 port available?
Try the following command: telnet <serverName> 1433

Check in the sqlServer if the TCP/IP protocol is enable.
Check if the Database is started.
Check for the domain of the Database, if you are in the same domain.


best regards

[samdeep aarzoo]

telnet <serverName> 1433
what is the use of this command at telenet

i write this on console
and i got only cursor blinks what does this show
what is the use of this command
and what we are checking through this

[Paul Sturrock]

Originally posted by Sushma Sharma:
yes, my username id Administrator and it doesn't have a password. Actually, its my windows password and I am using the windows login for MS SQL Server also.... is that a problem?

Yes it is a problem. You need to change the authentication method your MSSQL instance uses to "SQL Server and Windows" and connect to it with a database account, rather than using Windows integrated authentication.

[Sham Grandhe]

hey use the below link to change your SQL Server Login setting from window authentication to SQL Server and Window Authentication

http://www-1.ibm.com/support/docview.wss?uid=swg21119906

this might help your resolve the SQL Server Error 18452

[Sham Grandhe]

Originally posted by sandeep mittal:
telnet <serverName> 1433
what is the use of this command at telenet

i write this on console
and i got only cursor blinks what does this show
what is the use of this command
and what we are checking through this

waw check the above mentioned steps you should be able to resolve the issue.

[Paul Sturrock]

Please pay attention to the date of posts. It is very unlikely that Sushma Sharma is still waiting for an answer to a question they posted almost three years ago.

Also:

Yes it is a problem. You need to change the authentication method your MSSQL instance uses to "SQL Server and Windows" and connect to it with a database account, rather than using Windows integrated authentication

This is not true any more. Most SQL Server JDBC drivers support NTLM these days.