我用hibernate和ms sql做一个简单的数据库连接和操作测试,我公司项目里用到hibernate.结果出现一下错误:
C:/Documents and Settings/sunwenlong>cd C:/workspace/My1stHibernate
C:/workspace/My1stHibernate>ant run
Buildfile: build.xml
init:
build:
run:
[java] log4j:WARN No appenders could be found for logger (net.sf.hibernate.
cfg.Environment).
[java] log4j:WARN Please initialize the log4j system properly.
[java] net.sf.hibernate.JDBCException: Cannot open connection
[java] at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.
java:281)
[java] at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:32
97)
[java] at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java
:3277)
[java] at net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransa
ction.java:40)
[java] at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTran
saction(JDBCTransactionFactory.java:19)
[java] at net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImp
l.java:2220)
[java] at Test.main(Unknown Source)
[java] Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
for JDBC]Error establishing socket.
[java] at com.microsoft.jdbc.base.BaseExceptions.createException(Unknow
n Source)
[java] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown S
ource)
[java] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown S
ource)
[java] at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown
Source)
[java] at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unk
nown Source)
[java] at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(U
nknown Source)
[java] at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
[java] at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:512)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:140)
[java] at net.sf.hibernate.connection.DriverManagerConnectionProvider.g
etConnection(DriverManagerConnectionProvider.java:101)
[java] at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.
java:278)
[java] ... 6 more
BUILD SUCCESSFUL
Total time: 5 seconds
我的配置Hibernate描述文件:
<?xml version="1.0" encoding="gb2312" ?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory name="java:/hibernate/HibernateFactory">
<property name="show_sql">true</property>
<property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
<property name="hibernate.connection.url">jdbc:microsoft:sqlserver://localhost:1433;database=hibernate</property>
<property name="hibernate.connection.username">
test
</property>
<property name="hibernate.connection.password">
test
</property>
<property name="hibernate.dialect">
net.sf.hibernate.dialect.SybaseDialect<!-- 这里是Oracle 9i的Dialect -->
</property>
<mapping resource="Customer.hbm.xml" /> <!-- 指定Customer的映射文件 -->
</session-factory>
</hibernate-configuration>
请高手指点一下,谢谢