There are currently several options available for automatically generating IDs with Hibernate and JPA combined.
Example: @GeneratedValue(strategy = GenerationType.IDENTITY)
.
I am looking for documentation on how to choose the specific ID generation strategy that best suits each case.
1-) How are they different?
2-) Why is one chosen over another?
3-) Do all the strategies work if we talk about databases like Oracle, MySQL, PostgreSQL, ..?