Filip Spiridonov
Reputation: 36210
Generate large length column using Hibernate
I want to store user's reports. The database is autogenerated by Hibernate based on the Java entities.
What is the best way to specify, that the String report will contain a large portion of information?
The options are:
@Column(length = xxxx) - this looks like more portable@Column(columnDefinition = "TEXT") - doesn't work on some databases@Lob - not sure what are pros/cons
Any suggestions?
Upvotes: 0
Views: 100
Answers (1)
Paulo Fidalgo
Reputation: 22296
The advantage of using @Column(length = xxxx) is their portability. If you know you're not changing the database, you can use the second option and check for a native Type.
Otherwise use the first option. The @Lob could lead to problems if you need to search the text inside the field, because it can be considered as binary.
Upvotes: 1
Related Questions
- how to set length of an column in hibernate with maximum length
- How to specify the size of char column in Hibernate annotation?
- Long column size in JPA/Hibernate
- How to set maximum possible length to string column using hibernate
- Java Hibernate set min and max column length
- Hibernate - Data truncation: Data too long for column - object field
- Hibernate only sets length within @Column on field, not attribute
- How to set column size in Hibernate without using Annotations
- max length to hibernate column
- Creating table with longer text field by hibernate.hbm2ddl.auto