persistence.xml的transaction-type屬性設定

RESOURCE_LOCAL：
適用於JavaSE程式、JNDI使用non-jta-datasource

JTA：
適用於JavaEE程式、JNDI使用jta-datasource

ref:
https://access.redhat.com/documentation/en-us/red_hat_jboss_web_server/1.0/html/hibernate_entity_manager_reference_guide/configuration

https://openhome.cc/Gossip/EJB3Gossip/FirstContainerManagedJPA.html

EntityManagerFactory是threadsafe、EntityManager是non-threadsafe

https://docs.jboss.org/hibernate/stable/entitymanager/reference/en/html/transactions.html#transactions-basics

 
Source Code:
https://github.com/javaee/jpa-spec/blob/master/javax.persistence-api/src/main/java/javax/persistence/EntityManagerFactory.java

https://github.com/eclipse-ee4j/jpa-api/blob/master/api/src/main/java/jakarta/persistence/EntityManagerFactory.java

 

JPA API和Hibernate API的對照

  JPA API                                      Hibernate API
---------------                                  --------------------
 EntityManagerFactory                SessionFactory
 EntityManager                            Session
 EntityTransaction                        Transaction
 Query                                          Query

北風資料庫練習JPA的小專案

https://github.com/imrexhuang/jpa-northwind

 自己練習JPQL語法用的小專案，資料庫使用H2Database

 

EclipseLinkJpaVendorAdapter對Oracle資料庫PLSQL支援較佳

開發Spring Data JPA一般會使用HibernateJpaVendorAdapter，但是如果Oracle資料庫會使用EclipseLinkJpaVendorAdapter，對PLSQL支援較佳

ref:
https://www.eclipse.org/eclipselink/documentation/2.5/solutions/oracledb002.htm#CHDDCIEC

https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/orm/jpa/vendor/EclipseLinkJpaVendorAdapter.html

Invalid object name 'hibernate_sequence'

https://stackoverflow.com/questions/49037803/sql-server-2016-invalid-object-name-hibernate-sequence

Avoid GenerationType.AUTO

Set it explicit to GenerationType.IDENTITY or GenerationType.SEQUENCE depending on what you want or your DB supports.

中文訊息:
com.microsoft.sqlserver.jdbc.SQLServerException: 無效的物件名稱 'hibernate_sequence'

利用NetBeans產生JPA Entity

 New -> Other -> Persistence -> Entity Classes from Database

REF:
https://github.com/imrexhuang/table2entity