关于hibernate的问题

Question

新手讨教
请问在hibernate中怎么和sql server2000建立连接，hibernate.cfg.xml怎么配置driver

Answer 1

<?xml version="1.0"?>
<!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="myeclipse.connection.profile">
SQL Server
</property>
<property name="connection.url">
jdbc:jtds:sqlserver://localhost:1433/testdb
</property>
<property name="connection.username">sa</property>
<property name="connection.password">sa</property>
<property name="connection.driver_class">
net.sourceforge.jtds.jdbc.Driver
</property>
<property name="dialect">
org.hibernate.dialect.SQLServerDialect
</property>
<property name="show_sql">true</property>

<property name="hbm2ddl.auto">update</property> </session-factory>
</hibernate-configuration>

Answer 2

小弟是新手  搞不出来啊20:55:35,312 FATAL DriverManagerConnectionProvider:65 - JDBC Driver class not found: com.microsoft.jdbc.sqlserver
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:100)
at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:61)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:27)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:180)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
at com.bjsxt.hibernate.ExportDB.main(ExportDB.java:15)
20:55:35,328 ERROR SchemaExport:202 - schema export unsuccessful
org.hibernate.HibernateException: JDBC Driver class not found: com.microsoft.jdbc.sqlserver
at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:66)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:27)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:180)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
at com.bjsxt.hibernate.ExportDB.main(ExportDB.java:15)
Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:100)
at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:61)
... 6 more

Answer 3

我加载的是msbase
mssqlserver
msutil这三个驱动

Answer 4

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver 
找不到驱动类，，刚刚你有没有重新部署啊

Answer 5

你的数据库jar包导没导进去导sqlserver2000

Answer 6

你加载到哪了？是WEB-INF/lib下了吗？

Answer 7

我建了个库，库里放了解hibernate的lib和核心库，还有就是上面说的sql server三个驱动。

Answer 8

是不是加载msbase 
mssqlserver 
msutil这三个驱动连接sql server

Answer 9

刚刚改了driver_class: <property name="connection.driver_class">
            com.microsoft.jdbc.sqlserver.SQLServerDriver
        </property>
不过00:00:43,812 ERROR SchemaExport:202 - schema export unsuccessful
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:28)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:180)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
at com.bjsxt.hibernate.ExportDB.main(ExportDB.java:15)
是不是还要升级sql server

Answer 10

        <property name="myeclipse.connection.profile">
            SQL Server
        </property>
        <property name="connection.url">
            jdbc:jtds:sqlserver://localhost:1433/hibernate_first
        </property>
     
        <property name="connection.driver_class">
            com.microsoft.jdbc.sqlserver.SQLServerDriver
            
        </property>
        <property name="dialect">
            org.hibernate.dialect.SQLServerDialect
        </property>
        <property name="show_sql">true</property>
        
        <property name="hbm2ddl.auto">update</property>
        
        
        <mapping resource="com/bjsxt/hibernate/User.hbm.xml"/>
     </session-factory>00:53:18,828 ERROR SchemaExport:202 - schema export unsuccessful
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:28)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:180)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
at com.bjsxt.hibernate.ExportDB.main(ExportDB.java:15)

Answer 11

你这个jar要加在tomcat的lib目录下，而不是你项目的目录下，而且如果你用的是sql2000还要打上一个补丁，在网上搜搜下载下来，装上就行了