UnsupportedOperationException: The application must supply JDBC connections

by

Wow, just fixed the problem.

sessionFactory = configuration.buildSessionFactory(new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry());

I was missing the

.applySettings(configuration.getProperties())

Learnings

  1. configure() should be called AFTER setProperty
  2. Use hibernate.connection.url and NOT connection.url if you use hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
  3. Set log4j property for hibernate logs to ALL, so that you can see more detailed issues
  4. To get rid of the WARN Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!, you need to replace http://www.hibernate.org/dtd/ in the cfg.xml and all hbm files too. Dont forget teh hbm files, they too use the same DTD.

Lastly, referred to this, to fix this. The last advice by Bill Gorder is superb.

private static SessionFactory configureSessionFactory()    
        throws HibernateException {    
    Configuration configuration = new Configuration();    
    configuration.configure();    
    ServiceRegistry serviceRegistry = new ServiceRegistryBuilder()    
            .applySettings(configuration.getProperties())    
            .buildServiceRegistry();    
    return configuration.buildSessionFactory(serviceRegistry);    
}

More Related Contents:

  1. how to return Map with HQL
  2. Hibernate annotation or XML configuration
  3. How to map calculated properties with JPA and Hibernate
  4. Can someone explain mappedBy in JPA and Hibernate?
  5. Hibernate: Difference between session.get and session.load
  6. Hibernate: one-to-one lazy loading, optional = false
  7. How to use Spring managed Hibernate interceptors in Spring Boot?
  8. What is the difference between DAO and Repository patterns?
  9. @OrderColumn annotation in Hibernate 3.5
  10. How to query data for Primefaces dataTable using lazy loading and pagination
  11. Postgresql UUID supported by Hibernate?
  12. Performing Date/Time Math In HQL?
  13. How to connect to multiple databases in Hibernate
  14. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  15. Hibernate – why use many-to-one to represent a one-to-one?
  16. How Do I Create Many to Many Hibernate Mapping for Additional Property from the Join Table?
  17. Spring Data JPA – Pass column name and value as parameters
  18. hibernate could not get next sequence value
  19. Invalidating JPA EntityManager session
  20. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  21. Grails 2.4 and hibernate4 errors with run-app
  22. Hibernate/JPA ManyToOne vs OneToMany
  23. When to Use EntityManager.clear()?
  24. How is Hibernate deciding order of update/insert/delete
  25. Hibernate inserts duplicates into a @OneToMany collection
  26. Hibernate hbm2ddl.auto, possible values, and what they do
  27. In Spring with jpa/hibernate, how do I keep a session open to avoid lazy initialization exceptions?
  28. Should Hibernate be able to handle overlapping foreign keys?
  29. Hibernate IN Clause with multiple columns
  30. How do I map a BigDecimal in Hibernate so I get back the same scale I put in?

Leave a Comment