Configure hibernate to connect to database via JNDI Datasource

by

Apparently, you did it right. But here is a list of things you’ll need with examples from a working application:

1) A context.xml file in META-INF, specifying your data source:

<Context>
    <Resource 
        name="jdbc/DsWebAppDB" 
        auth="Container" 
        type="javax.sql.DataSource" 
        username="sa" 
        password="" 
        driverClassName="org.h2.Driver" 
        url="jdbc:h2:mem:target/test/db/h2/hibernate" 
        maxActive="8" 
        maxIdle="4"/>
</Context>

2) web.xml which tells the container that you are using this resource:

<resource-env-ref>
    <resource-env-ref-name>jdbc/DsWebAppDB</resource-env-ref-name>
    <resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type>
</resource-env-ref>

3) Hibernate configuration which consumes the data source. In this case, it’s a persistence.xml, but it’s similar in hibernate.cfg.xml

<persistence-unit name="dswebapp">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
        <property name="hibernate.connection.datasource" value="java:comp/env/jdbc/DsWebAppDB"/>
    </properties>
</persistence-unit>

More Related Contents:

  1. Connection cannot be cast to oracle.jdbc.OracleConnection
  2. Hibernate throws MultipleBagFetchException – cannot simultaneously fetch multiple bags
  3. Hibernate Annotations – Which is better, field or property access?
  4. What are the differences between the different saving methods in Hibernate?
  5. How to store date/time and timestamps in UTC time zone with JPA and Hibernate
  6. Bypass GeneratedValue in Hibernate (merge data not in db?)
  7. Ignore fields from Java object dynamically while sending as JSON from Spring MVC
  8. How should equals and hashcode be implemented when using JPA and Hibernate
  9. How does the FetchMode work in Spring Data JPA
  10. The meaning of NoInitialContextException error
  11. Hibernate Union alternatives
  12. Location of hibernate.cfg.xml in project?
  13. Hibernate – Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1
  14. JPA entity without id
  15. Can add extra field(s) to @ManyToMany Hibernate extra table?
  16. Simple hibernate query returning very slowly
  17. Rollback transaction after @Test
  18. JPA Query.getResultList() – use in a generic way
  19. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  20. Why composite-id class must implement Serializable?
  21. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  22. Error creating bean with name ‘entityManagerFactory
  23. ejb lookup failing with NamingException
  24. HQL joined query to eager fetch a large number of relationships
  25. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  26. What properties does @Column columnDefinition make redundant?
  27. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  28. JPA Updating Bidirectional Association
  29. Autowired Repository is Null in Custom Constraint Validator
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment