All Questions
30,619 questions
0
votes
0
answers
46
views
Are there any jOOQ conventions on how to batch-insert 1 to n relations to the database?
I regularly face the use case in our backend application that it needs to save a lot of data at once that is scattered around multiple tables, but mostly its a 1 to n relationship, or recursive data ...
- 1
-1
votes
0
answers
24
views
Table is not generating in Spring Data JPA [duplicate]
@Entity
@Table(name = "order")
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Order implements Serializable {
private static final long serialVersionUID = 1L;
@...
0
votes
1
answer
74
views
How to properly get output from shell cmd in Java?
I installed mysql in a docker container, and tried to run this Java code to get some variable value:
String[] cmd = new String[] {"docker", "exec", "my", "mysql"...
- 183
-5
votes
0
answers
45
views
I am unable to connect mysql to java project [duplicate]
I am working on a java project. I have added the jar file in the referenced libraries option. I also have provided the path in settings.json. Also added the lib folder to store jar files still i can't ...
- 1
-3
votes
0
answers
20
views
spark strucutred streaming mysql read [duplicate]
I am using Spark Structured streaming which reads data from Kafka using JAVA api.
However for specific condition need to read the data from MySQL.
How can that be implemented with structured streaming?...
0
votes
1
answer
60
views
Java MySQL: Could not create table and insert initial data
I am creating a system with MySQL and I can't seem to make it create a table and then insert the initial data for the users table. It is connecting properly to the specified database but not creating ...
1
vote
0
answers
97
views
HikariPool-1 - Failed to validate connection in Spring Boot Data Jpa with mysql
I know there are already similar questions and answers on the topic. I tried all the suggestions but nothing worked for me. I decided to post this question because my case seems slightly different.
I ...
- 65
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
81
views
MySql database connection with Jakarta ee via JPA and Wildfly
i've been developping an app for a uni project and i started with 3 simple tables (Student, Teacher and Subject), but when i try to list all the subject in the Controller servlet it shows an error on ...
- 21
0
votes
1
answer
174
views
Getting exception "Not a navigable ResultSet" from JDBCTemplate query against a MySQL database in Spring Boot application
We have a Spring Boot application, written in Kotlin, which runs in a container on Digital Ocean App Platform.
Versions:
MySQL 8.0.30
Kotlin 2.0.20
Spring Boot 3.4.2
HikariCP 3.4.5
MySQL Connector/J ...
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
0
votes
0
answers
54
views
Why am I getting "No database selected" error when using Hibernate with MySQL in WildFly?
I'm trying to deploy a Java application to WildFly that uses Hibernate with a MySQL database. However, when I run my application, I get the following error in the logs:
alter table exam_table
...
1
vote
2
answers
70
views
Java application slow when connecting to MySQL server when not on LocalHost
TLDR at the bottom
I'm fairly new to java and have been studying for around 2 years in my spare time.
I've recently decided to try my hand at making some retail software for my small business.
I am ...
- 11
0
votes
1
answer
155
views
Use of MySQL8Dialect for MySQL 9.1.0 correct?
What is the correct Hibernate dialect for MySQL 9.1.0 set in the application.properties of a Java Spring application? For MySQL 8 I would have used org.hibernate.dialect.MySQL8Dialect, but it seems ...
- 9,624