Hibernate and MS Access?

[Thameem Aliyar]

I'am developing an application with hibernate . And i have ms access db in hand . Is it possible to connect. How can i connect hibernate to ms access DB. Kindly help me please........
Thanking you in advance...........

[Vijitha Kumara]

You should have the proper driver and the appropriate Hibernate dialect defined. See this for more information about the support for various vendors.

[Thameem Aliyar]

Thanks for your reply. I used the same dialect. But I got some errors.

Here's my hibernate.cfg.xml................
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-configuration SYSTEM "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.dialect">com.hxtt.support.hibernate.HxttAccessDialect</property> <property name="hibernate.connection.driver_class">com.hxtt.sql.access.AccessDriver </property> <property name="hibernate.connection.url"> jdbc:access:///C:\Documents and Settings\Thameem-pc.THAMEEM\My Documents\db1.mdb </property> <property name="hibernate.connection.pool_size">10</property> <property name="show_sql">true</property> <property name="hbm2ddl.auto">update</property> <mapping resource="DemoMsAccess.hbm.xml" /> </session-factory> </hibernate-configuration>
And here's the error.......


Failed to create sessionFactory object.org.hibernate.HibernateException: Dialect class not found: com.hxtt.support.hibernate.HxttAccessDialect
Exception in thread "main" java.lang.ExceptionInInitializerError
at com.actions.MsAccessMain.main(MsAccessMain.java:20)
Caused by: org.hibernate.HibernateException: Dialect class not found: com.hxtt.support.hibernate.HxttAccessDialect
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:159)
at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:99)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:117)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
at com.actions.MsAccessMain.main(MsAccessMain.java:17)
Caused by: java.lang.ClassNotFoundException: com.hxtt.support.hibernate.HxttAccessDialect
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.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:156)
... 6 more


Kindly tell me a solution required.

Thanking you in advance................

[Thameem Aliyar]

I resolved the above error by including hibernate35.jar..
Now i'am getting the following error.......


Failed to create sessionFactory object.java.lang.NoSuchFieldError: INTEGER
Exception in thread "main" java.lang.ExceptionInInitializerError
at com.actions.MsAccessMain.main(MsAccessMain.java:25)
Caused by: java.lang.NoSuchFieldError: INTEGER
at com.hxtt.support.hibernate.HxttDialect.<init>(HxttDialect.java:27)
at com.hxtt.support.hibernate.HxttAccessDialect.<init>(HxttAccessDialect.java:12)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:156)
at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:99)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:117)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
at com.actions.MsAccessMain.main(MsAccessMain.java:22)


Here's my main method.....

public class MsAccessMain {
	private static SessionFactory factory;
	public static void main(String args[]){


		try {
			factory = new Configuration().configure("hibernate.cfg.xml").buildSessionFactory();
		} catch (Throwable ex) {
			System.err.println("Failed to create sessionFactory object." + ex);
			throw new ExceptionInInitializerError(ex);
		}
		Session session = factory.openSession();
		Transaction tx = null;
		Integer employeeID = null;
		try {
			tx = session.beginTransaction();
		DemoMsAccess ms=new DemoMsAccess();
		ms.setAddress("sdddd");
		ms.setName("Thameem");
		session.save(ms);
		
			tx.commit();
		} catch (HibernateException e) {
			if (tx != null)
				tx.rollback();
			e.printStackTrace();
		} finally {
			session.close();
		}
		
	}

}

Kindly tell me the solution required.

Thanking you in advance................

[Vijitha Kumara]

Looks like you have used incompatible types here. Can you show your mapping file and the POJO itself?

[Thameem Aliyar]

Thanks for your reply.......... Sorry for the late reply........ its beacause the net was down................

Here's my POJO.........

public class DemoMsAcccess {
	private String id;
	private String name;
	private String address;

	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
}

And here's my mapping xml...
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- Generated Dec 30, 2011 3:06:34 PM by Hibernate Tools 3.4.0.CR1 --> <hibernate-mapping> <class name="com.beans.DemoMsAcccess" table="DemoMsAcccess"> <id name="id" type="java.lang.String"> <column name="ID" /> <generator class="assigned" /> </id> <property name="name" type="java.lang.String"> <column name="NAME" /> </property> <property name="address" type="java.lang.String"> <column name="ADDRESS" /> </property> </class> </hibernate-mapping>
Kindly reply me solution....
Thanking you in advance..............

[Vijitha Kumara]

What is the line corresponding to the line #25 in your MsAccessMain original class (including package, imports etc..)?

And I suggest you first try to get the initialization work properly. Remove other code from the main class and try.