All Questions
8,396 questions
0
votes
0
answers
27
views
MySQL 8 Cluster : Hibernate transaction: Unable to commit against JDBC Connection; Plugin instructed the server to rollback the current transaction
I use Java Spring 3 and JPA Repository to interact with MySQL 8 Cluster.
You can follow my code:
Transfer transfer = new Transfer();
transfer.setField...;
transferRepository.save(transfer);
transfer....
- 1
1
vote
0
answers
33
views
How to use MATCH ... AGAINST (FullText Search) with Hibernate 6 and QueryDSL?
I’m working on a Spring Boot 3.2 + Hibernate 6.6.11 + QueryDSL 5 project, using MySQL and attempting to implement full-text search using MATCH ... AGAINST (with ngram parser).
I have already created ...
- 11
0
votes
0
answers
31
views
Hibernate 6 error using `manyToOne` and `oneToMany` mapping - Why is this happening? [duplicate]
I have two entity classes defined. One called EncryptedFile and the other called Chat.
I have stripped out the code down to the root problem.
Chat:
package database.objects
@Entity
@Cacheable
@org....
- 879
0
votes
0
answers
38
views
Database Connection Issue using docker compose: Access Denied – Hibernate Fails to Initialize JPA
I'm encountering an access denied error when trying to connect to MySQL from my Spring Boot application. Here's the relevant part of the error log:
SQL Error: 1045, SQLState: 28000
Access denied for ...
0
votes
1
answer
57
views
How can I get hibernate to do a unidirectional ManyToOne mapping without using the primary key?
We have a table structure like this:
CREATE TABLE `client` (
`id` BIGINT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `member` (
`id` BIGINT NOT ...
- 3
0
votes
0
answers
29
views
Portable ID generator in Hibernate (For Oracle 11G and Mysql 8.0)
Background
I am trying to migrate my database form Oracle 11G -> Mysql 8.0. I am using hibernate as my ORM layer (over spring boot app)
Problem
While migrating to mysql, i also need to change my id ...
- 1,303
1
vote
2
answers
28
views
org.hibernate.MappingException: Unknown entity: org.example.Person
I am trying to save a record of Person class into mySql database using pure java and hibernate but I get this error. these are my classes. I appreciate any help why this error is raised.
With these ...
- 92
0
votes
1
answer
89
views
Spring Boot: DELETE request returns 204 but doesn't delete the record from the database
I'm working on a Spring Boot application and trying to implement a DELETE endpoint to remove a record from the database. The API responds with 204 No Content, and my application logs indicate that the ...
0
votes
1
answer
60
views
Spring JPA - Changing the data type of an already established ID?
Long story short, I messed up and need to change an ID from a string to an autogenerated long within Spring and update any children with the newly generated number ID. I'm attempting to correct it ...
1
vote
0
answers
48
views
Dropwizard - new entities not commiting
We have a thread that queries external systems by clients. It receives a JSON array containing client information like id (which our system calls "customId"), name, phone, etc. The array is ...
- 11
0
votes
0
answers
21
views
How to Handle Missing Data in LEFT JOIN for Custom Fallback Message in JPA Query?
I'm building a Spring Boot application where I need to fetch data from an AuditLog table. This table is connected to several other entities through LEFT JOIN, and one of those entities is ...
- 17
0
votes
1
answer
84
views
Java JPA Repository One To One Join Table Wrong Join Variable and Unknown Column Error
I am struggling to get a one to one join relationship JPA repository call to work.
I have two tables product and display_name so I made the follow entities
@Entity
@Table(name = "product")
...
- 73
0
votes
0
answers
55
views
Migrated Spring Boot Project from MySQL to PostgreSQL
We want to migrate a Spring Boot project in which we use JPA over a very large MySQL database (500+ tables) to a postgreSQL database.
After a series of specific changes (change of reserved words, ...
0
votes
1
answer
70
views
Hibernate throws error: Table 'USERS' not found in MySQL database
I'm currently developing a login and registration feature for my application, and I'm trying to connect to my MySQL database. However, I'm facing an issue where the application reports that the ...
1
vote
1
answer
48
views
How is JPA's Sort.by() is able to access nested fields of entity?
I am getting a surprising output in my GET API built in springboot,
I have two related entities, say A and B. Here A has @OneToOne mapping with B.
@Entity
class A {
....
@OneToOne
@...
- 47