天天看點

MyEclipse--Hibernate連接配接ACCESS資料庫

1、在lib目錄下導入2個jar包

Access_JDBC30.jar

hibernate.jar

2、Hibernate添加資料源

Driver templat:

Driver name: access

Connection URL:jdbc:access:///G:/ACCESS/test1.mdb

Driver JARs :Access_JDBC30.jar

3、Hibernate資料源配置 

<property name="dialect">com.hxtt.support.hibernate.HxttAccessDialect</property>

<?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>