How can I use hibernate with MS Access?

by

Actual solution here!

After spending 1 day trying out different solutions ODBC, HXTT, etc. I found this beauty 🙂 http://ucanaccess.sourceforge.net/site.html.

It couldn’t be any simpler: just add the jars from the site to your project libs and.

META-INF/persistence.xml

<?xml version="1.0" encoding="utf-8"?>
<persistence>
    <persistence-unit name="traderMandate">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect" />
            <property name="hibernate.connection.url" value="jdbc:ucanaccess://C:/MY.accdb;" />
            <property name="hibernate.connection.driver_class" value="net.ucanaccess.jdbc.UcanaccessDriver"/>
            <property name="hibernate.archive.autodetection" value="class" />
        </properties>
    </persistence-unit>
</persistence>

Spring config:

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="persistenceUnitName" value="traderMandate"/>
</bean>

<tx:annotation-driven/>

<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>

And you’re good to go. 😉

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. Difference between FetchType LAZY and EAGER in Java Persistence API?
  3. How to map a composite key with JPA and Hibernate?
  4. How to map an entity field whose name is a reserved word in JPA
  5. Do I need elements in persistence.xml?
  6. What’s the difference between JPA and Hibernate? [closed]
  7. Hibernate Error: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session
  8. What is the “owning side” in an ORM mapping?
  9. What is the solution for the N+1 issue in JPA and Hibernate?
  10. JPA CascadeType.ALL does not delete orphans
  11. What is the difference between persist() and merge() in JPA and Hibernate?
  12. Do Hibernate table classes need to be Serializable?
  13. JPA/Hibernate Native Queries do not recognize Parameters
  14. How to solve the LazyInitializationException when using JPA and Hibernate
  15. Hibernate saveOrUpdate behavior
  16. Hibernate: flush() and commit()
  17. Filling combobox from database by using hibernate in Java
  18. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  19. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  20. Doing an “IN” query with Hibernate
  21. Save child objects automatically using JPA Hibernate
  22. The onFlushDirty Hibernate Interceptor method is never called
  23. Light weight alternative to Hibernate? [closed]
  24. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  25. Hibernate, spring, JPS & isolation – custom isolation not supported
  26. HQL joined query to eager fetch a large number of relationships
  27. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  28. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  29. Difference between @GeneratedValue and @GenericGenerator
  30. getting result set into DTO with native SQL Query in Hibernate

Leave a Comment