Hibernate - Postgres mailing lists can contain a maximum of 1664 entries

Question

We use hibernate, postgres 8.3x

Our facilities are many to one, matched with impatience. We have multiple associations with matching from many to one.

As you add new columns to any other existing objects, We become lower errors:

goal lists can contain a maximum of 1664 entries

I searched the internet and they say this is due to the More number of select statements in sql query (generated by sleeping)

Can you please tell any authority to us if there is any configuration (in postgres) for updating the columns of the maximum number in the configuration or any other solution to solve this problem.

Thanks in advance.

Answer 1

Try

      <property name="hibernate.max_fetch_depth" value="25"/>

Answer 2

Something is definitely wrong with your model / mappings / query . The correct way to fix it is to work with your model / mappings / queries, and not with the maximum number of columns in PostgreSQL (I don’t even understand how you reached it, a query that retrieves 1664+ columns does not make sense).

Answer 3

PostgreSQL, . ? , . , , .

Answer 4

, @ManyToOne (fetch = FetchType.EAGER). , FetchType.EAGER, @ManyToOne (fetch = FetchType.LAZY)

, !