Hibernate连接Access数据库

灿仔DJ

于 2014-04-11 10:47:22 发布

阅读量8.1k

点赞数 1

分类专栏： hibernate 文章标签： hibernate access 数据库异常 jdbc

本文链接：https://blog.csdn.net/snomyc520/article/details/23428863

版权

hibernate 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

hibernate连接Access数据库方法一:用Access_jdbc30.jar包（此包在使用hibernate中会出现查询记录只能查询1000条，需要下载正版的jar包）

第一种方法:
第一步导入Access包,在配置文件中配置下面信息

<?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="connection.url">
jdbc:access:///G:/ACCESS/test1.mdb
</property>
<property name="myeclipse.connection.profile">access</property>
<property name="connection.driver_class">
com.hxtt.sql.access.AccessDriver
</property>
<property name="show_sql">true</property>
<property name="connection.username"></property>
<property name="connection.password"></property>
<property name="hibernate.dialect">
com.hxtt.support.hibernate.HxttAccessDialect
</property>
<property name="dialect">com.hxtt.support.hibernate.HxttAccessDialect</property>
<mapping resource="com/jsw/hibernate/entity/TUser.hbm.xml" />

</session-factory>

</hibernate-configuration>
上面的配置是错误的，
<property name="hibernate.dialect">
com.hxtt.support.hibernate.HxttAccessDialect
应改为:org.hibernate.dialect.SQLServerDialect否侧会抛出org/hibernate/type/StandardBasicTypes异常
</property>

正确的配置如下
<?xml version='1.0' encoding='GBK'?>
<!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="connection.url">
jdbc:access:///d:/EasychannelAccess/easychannel.accdb
</property>
<property name="connection.driver_class">
com.hxtt.sql.access.AccessDriver
</property>
<property name="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</property>
<property name="show_sql">true</property>
<mapping resource="po/User.hbm.xml" />

</session-factory>

</hibernate-configuration>

第二种方法:
用java自带的jdbc驱动,使用sqlserver方言，不过会出现一些小问题模糊查询方面和sql server数据库略有不同

<?xml version='1.0' encoding='GBK'?>
<!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="dialect">
org.hibernate.dialect.SQLServer7Dialect
</property>
<property name="connection.url">
jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};
DBQ=D://EasychannelAccess//easychannel.accdb
</property>
<property name="connection.driver_class">
sun.jdbc.odbc.JdbcOdbcDriver
</property>
<property name="show_sql">true</property>
<mapping resource="po/User.hbm.xml" />

</session-factory>

</hibernate-configuration>

用hibernate3框架的话，使用jdbc连接org.hibernate.dialect.SQLServerDialect 而不是
org.hibernate.dialect.SQLServer7Dialect 不然运行web项目会报错