Getting Database connection in pure JPA setup

by

As per the hibernate docs here,

Connection connection()

Deprecated. (scheduled for removal in 4.x). Replacement depends on need; for doing direct JDBC stuff use
doWork(org.hibernate.jdbc.Work) …

Use Hibernate Work API instead:

Session session = entityManager.unwrap(Session.class);
session.doWork(new Work() {

    @Override
    public void execute(Connection connection) throws SQLException {
        // do whatever you need to do with the connection
    }
});

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. JPA JoinColumn vs mappedBy
  3. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  4. Hibernate Annotations – Which is better, field or property access?
  5. How to map an entity field whose name is a reserved word in JPA
  6. What’s the difference between JPA and Hibernate? [closed]
  7. How to map calculated properties with JPA and Hibernate
  8. What is the solution for the N+1 issue in JPA and Hibernate?
  9. JPA CascadeType.ALL does not delete orphans
  10. Bypass GeneratedValue in Hibernate (merge data not in db?)
  11. When and why JPA entities should implement the Serializable interface?
  12. JPQL Create new Object In Select Statement – avoid or embrace?
  13. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  14. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  15. JPA/Hibernate Native Queries do not recognize Parameters
  16. I found JPA, or alike, don’t encourage DAO pattern
  17. Hibernate – @ElementCollection – Strange delete/insert behavior
  18. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  19. JPA SQL Server No Dialect mapping for JDBC type: -9
  20. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  21. Is it possible to dynamically define column names in Hibernate / JPA?
  22. Specifying an Index (Non-Unique Key) Using JPA
  23. The onFlushDirty Hibernate Interceptor method is never called
  24. Hibernate throws strange error: Class is not mapped
  25. Batch inserts with JPA/EJB3
  26. Hibernate triggering constraint violations using orphanRemoval
  27. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  28. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  29. Change Table Name of an Entity on runtime? [duplicate]
  30. How to map one class to different tables using hibernate/jpa annotations

Leave a Comment