eclipse+hibernate出现错误

[hekai1112004]

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported VM encoding MS936.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.setNonUnicodeTransliterator(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.setSQLCollation(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processEnvChange(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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 net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:93)
at net.sf.hibernate.impl.SessionFactoryImpl.openConnection(SessionFactoryImpl.java:396)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:2914)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:56)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:482)
at net.sf.hibernate.loader.Loader.doFind(Loader.java:136)
at net.sf.hibernate.loader.Loader.find(Loader.java:620)
at net.sf.hibernate.hql.QueryTranslator.find(QueryTranslator.java:928)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1343)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:76)
at com.test.TestOneToMany.doQuery(TestOneToMany.java:117)
at com.test.TestOneToMany.main(TestOneToMany.java:159)
rethrown as net.sf.hibernate.JDBCException: Cannot open connection: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported VM encoding MS936.
at net.sf.hibernate.impl.SessionFactoryImpl.openConnection(SessionFactoryImpl.java:399)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:2914)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:56)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:482)
at net.sf.hibernate.loader.Loader.doFind(Loader.java:136)
at net.sf.hibernate.loader.Loader.find(Loader.java:620)
at net.sf.hibernate.hql.QueryTranslator.find(QueryTranslator.java:928)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1343)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:76)
at com.test.TestOneToMany.doQuery(TestOneToMany.java:117)
at com.test.TestOneToMany.main(TestOneToMany.java:159)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported VM encoding MS936.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.setNonUnicodeTransliterator(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.setSQLCollation(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processEnvChange(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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 net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:93)
at net.sf.hibernate.impl.SessionFactoryImpl.openConnection(SessionFactoryImpl.java:396)
... 10 more
WARNING: Default charset GBK not supported, using ISO-8859-1 instead

[dary_zhou]

好像是你的JDBC驱动程序有问题吧,

[bluelily22]

映射文件中的ID
<generator class="VM" /> 改成与你数据匹配的类型
如数据主键为自动增长型
<id
column="UserID"
name="UserID"
type="integer"
>
<generator class="identity" />
</id>

[「已注销」]

Uping......

[USA110]

eclipse3.0的hibernate插件在哪有下载的

[hekai1112004]

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

<class name="com.test.Student" table="student" >

<id name="sid" type="string" unsaved-value="null" >
<column name="sid" sql-type="char(32)" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name="sname">
<column name="sname" sql-type="varchar(16)" not-null="true"/>
</property>

<property name="sage">
<column name="sage" sql-type="varchar(16)" not-null="true"/>
</property>

<set name="book" cascade="all" outer-join="true">
<key column="sid"/>
<one-to-many class="com.test.Book" />
</set>

</class>

</hibernate-mapping>


将<generator class="uuid.hex"/>改为<generator class="identity" />也不行呀

[hekai1112004]

hibernate.properties


## MS SQL Server

hibernate.dialect net.sf.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class com.microsoft.jdbc.sqlserver.SQLServerDriver
hibernate.connection.url jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=JP_MMS_DB;SelectMethod=cursor
hibernate.connection.username mms_web
hibernate.connection.password jp_web_mms

[bluelily22]

应该是数据库驱动的问题吧
你用的是微软的驱动吧，建议你用这个jtds-1.0.2.jar,这个要比微软的好

[peanohan]

http://www.binamics.com/hibernatesync/

[princeeee]

回复人： yxxcrtd(无所谓) ( ) 信誉：100
到处都能看到你。：）

[liukang520236]

每个工程都要加载驱动程序的，仔细看看你的驱动程序是否加载了，最好重新加载一次．