I have a text field in my Hibernate entity as shown below: @Column(nullable = false, columnDefinition = "TEXT") private String content; So, what is the default and suggested length for this field (it is a content of a blog)? And…
For some reasons my query is running perfectly in MySQL WorkBench but when added to the repository I am getting syntax error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version…
I'm trying to fetch all rows that have the same patient_id, so I'm doing findAllByPatientId. But I'm always receiving one object in the Listinstead of all the rows. @Entity @Getter @Setter public class MedicalHistory extends BaseEntity { @Id @GeneratedValue(strategy =…
After upgrade to Spring Boot 3 I`ve got next problem; My entity @Data @Table(name = "campaign_status") @Entity public class CampaignStatus { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "campaign_status_id") private Long campaignStatusId; @Column(name = "name") private String name; } My jpa…
I am trying to insert data when starting my application but it fails continuously and this exception is thrown, I don't know what I am doing wrong, I have changed the Mysql dialect for version 8 it keeps failing.I have…
I'm using postgres with my spring boot app and I want to make a specific table not delete able by anyone. Is there a way to implement this on spring boot side. Revoking delete grant does the job on postgres…
I'm working on a spring boot project example and I have already created the database but when I configure the database, it doesn't seem to work. It doesn't give me an error though but when I execute the application, nothing…
With the release of Hibernate 6, once again I am scratching my head trying to figure out how to get Hibernate to convert a @Lob to bytea for a PostGres database. I also need the code to be testable with…
Thanks a lot for taking time to read my post. Please could you help me. I want to have a oneToMany relationship in my database such as: RelationShip Between Objects in DB I am using Spring, JPA, Mappers and Repos…
I am using Spring boot with Mysql. I have implemented Datasource and defined properties in application.xml file. I have a long running query: @Query(value - "select sleep(10)", nativeQuery=true) public void test(); in JPA repository methods. I want to implement query…