Seam / Hibernate and PostgreSQL - Any problems?

I am currently working on a project that uses MySQL / Seam / Hibernate (JPA). I am reviewing the transition to PostgreSQL after exploring some of the features it provides. My question is: is there something I need to worry about in this configuration? Limitations? Gotchas? What should be considered? Some BLOBs (images, X.509 certificates, etc.) will be stored in the database. Will there be a problem using PostgreSQL? Are there any specific configuration changes or settings that I have to make to the Hibernate configuration? Thanks for any advice you can give!

+3
source share
1 answer

As far as I know, there are no special problems with JPA / Hibernate and PostgreSQL. Actually, I would even say that this combo works very well, especially when working with Blobs. The PostgreSQL JDBC driver provides a very good implementation java.sql.Blob(one of the views that supports lazy loading of blobs, as indicated in this thread ). This is the only thing I had to say.

+1
source

Source: https://habr.com/ru/post/1744393/


All Articles