初學者，如何用hibernate配置SqlServer？（MyEclipse）

 

樊斌峰 1分鐘前

填問卷贏好書華章讀者調研活動結果公布

這是我的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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>

 <property name="dialect">
               org.hibernate.dialect.SQLServerDialect
     </property>
 <property name="hibernate.connection.url">jdbc:sqlserver://127.0.0.1:1433;DatabaseName="shopping";</property>
 <property name="hibernate.connection.username">sa</property>
 <property name="hibernate.connection.password">sa</property>
 <property name="hibernate.connection.driver_class">
  com.microsoft.sqlserver.jdbc.SQLServerDriver
 </property>
 <property name="hibernate.show_sql">true</property>
 <mapping resource="model.hbm.xml" />

</session-factory>

</hibernate-configuration>

運行程式後報告錯誤：

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" org.hibernate.exception.SQLGrammarException: Cannot open connection
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
 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.examp.ShoppingOnline.hibernate.DbOperate.save(DbOperate.java:211)
 at com.examp.ShoppingOnline.test.TestAddUser.main(TestAddUser.java:17)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 無法開啟登入 '"shopping"' 中請求的資料庫。登入失敗。
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
 at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
 at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
 at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
 ... 6 more
希望哪位高手能幫忙解決一下，感激不盡！