<session-factory>
<property name="hibernate.connection.url">jdbc:sqlserver://localhost:1433;DatabaseName=Test </property>
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver </property>
<property name="hibernate.connection.username">sa </property>
<property name="hibernate.connection.password">sa </property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect </property>
<mapping resource="com/test/hibernate/User.hbm.xml"/>
</session-factory>说明我的机子是sqlserver2000,装visule studio的 时候装了点sqlserver2005(vs自带的,没有企业管理器)现在我运行的错误是:
org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)
at com.test.hibernate.Client.main(Client.java:19)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 5 more
Exception in thread "main" org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:183)
at com.test.hibernate.Client.main(Client.java:32)
<property name="hibernate.connection.url">jdbc:sqlserver://localhost:1433;DatabaseName=Test </property>
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver </property>
<property name="hibernate.connection.username">sa </property>
<property name="hibernate.connection.password">sa </property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect </property>
<mapping resource="com/test/hibernate/User.hbm.xml"/>
</session-factory>说明我的机子是sqlserver2000,装visule studio的 时候装了点sqlserver2005(vs自带的,没有企业管理器)现在我运行的错误是:
org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)
at com.test.hibernate.Client.main(Client.java:19)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 5 more
Exception in thread "main" org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:183)
at com.test.hibernate.Client.main(Client.java:32)
解决方案 »
- Hibernate用Query查询出现的问题
- JNI中的STATIC{}这个是匿名内部类吗?
- 请求servlet出错,疯掉了啊
- 从数据库里读出的时间,不同电脑上显示的不同
- 关于乱码的解决,谢谢!
- org.hibernate.hql.ast.QuerySyntaxException: FgFile is not mapped
- 一个类中维护两个map对象,出现了奇怪的问题,不知是不是SDK本身就有问题?大家进来看看?
- struts xdoclet
- 帮我看看这段代码.然后对每个方法写下注释.谢谢啦
- axis1.4 调用报错:faultString: java.lang.reflect.InvocationTargetException
- oracle和mysql
- struts2一次请求执行action里的二个方法
报错:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
说是没打补丁
需要sqlserver sp3
但是我的是xp系统啊,需要sp3吗?