How can I set Datasource when I’m creating Hibernate SessionFactory?

by

If you happen to have your DataSource stored in JNDI, then simply use:

configuration.setProperty(
    "hibernate.connection.datasource",
    "java:comp/env/jdbc/yourDataSource");

But if you use a custom data source provider like Apache DBCP or BoneCP and you don’t want to use a dependency injection framework like Spring, then you may inject it on the StandardServiceRegistryBuilder before creating the SessionFactory:

//retrieve your DataSource
DataSource dataSource = ...;
Configuration configuration = new Configuration()
    .configure();
//create the SessionFactory from configuration
SessionFactory sf = configuration
    .buildSessionFactory(
        new StandardServiceRegistryBuilder()
            .applySettings(configuration.getProperties())
            //here you apply the custom dataSource
            .applySetting(Environment.DATASOURCE, dataSource)
            .build());

Note that if you use this approach, you don’t need to put the connection parameters in your hibernate.cfg.xml anymore. Here’s an example of a compatible hibernate.cfg.xml file when using approach from above:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>

    <session-factory>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
        <property name="show_sql">false</property>
        <!-- your mappings to classes go here -->
    </session-factory>
</hibernate-configuration>

Code above tested on Hibernate 4.3.

More Related Contents:

  1. Hibernate SessionFactory vs. JPA EntityManagerFactory
  2. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  3. How to map an entity field whose name is a reserved word in JPA
  4. What’s the difference between JPA and Hibernate? [closed]
  5. How to convert a Hibernate proxy to a real entity object
  6. What is the solution for the N+1 issue in JPA and Hibernate?
  7. JPA CascadeType.ALL does not delete orphans
  8. Wrong ordering in generated table in jpa
  9. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  10. Using Hibernate’s ScrollableResults to slowly read 90 million records
  11. Hibernate criteria: Joining table without a mapped association
  12. what is @JoinColumn and how it is used in Hibernate
  13. JPA eager fetch does not join
  14. In which case do you use the JPA @JoinTable annotation?
  15. How can I get the session object if I have the entity-manager?
  16. Hibernate: flush() and commit()
  17. Apache Commons equals/hashCode builder [closed]
  18. Using javafx.beans properties in model classes
  19. Hibernate/persistence without @Id
  20. Hibernate Criteria Query to get specific columns
  21. Disable the log from specific class/jar via logback.xml
  22. IN-clause in HQL or Java Persistence Query Language
  23. How to set the timeout period on a JPA EntityManager query
  24. Persist collection of interface using Hibernate
  25. Configure hibernate to connect to database via JNDI Datasource
  26. What is the MariaDB dialect class name for Hibernate?
  27. Different representation of UUID in Java Hibernate and SQL Server
  28. How to flush data into db inside active spring transaction?
  29. “Illegal attempt to map a non collection as a @OneToMany, @ManyToMany or @CollectionOfElements” in hibernate when annotating a ConcurrentHashMap
  30. Array with UserType in Hibernate and PostgreSQL –> MappingException

Leave a Comment