All Questions
30,680
questions
-2
votes
0
answers
39
views
is there a way to store unschematised datas in sql database [closed]
mysql : 5.6 java : 11
Am in need of an mechanism to store unschematised data in my db. the case is as follows.
Objective :
To get all user from a 3rd party app and store it in db.
Problem facing :
...
-2
votes
0
answers
33
views
problem in delete function in java and mysql [closed]
error message when i press delete حذف
I have a table connected with mysql when I choose a row to delete it doesn't work
here is the code of delete
private void l2MouseClicked(java.awt.event....
0
votes
2
answers
43
views
Using JdbcTemplate to Insert a UUID into a MySQL 8 Table
I'm trying to insert a row in a MySQL 8 table that has a column of type BINARY(16). In detail, I'm using Spring JdbcTemplate, and the information is stored in a Java UUID object. I can't find how to ...
- 8,263
0
votes
0
answers
21
views
How to search mutliple columns in mysql with partial matching (?) similar to a search bar? [duplicate]
I am writing a Java command line app for searching through books in a library and outputing the location of the book to the user. The books are stored in a mysql database and all access is done ...
-1
votes
0
answers
22
views
Unable to access mysql container [duplicate]
I have a java-container and mysql-container
when I run
docker run -d --network java-network --name java-container -p 8080:8080 java-image
I see the error
Access denied for user 'root'@'172.18.0.3'
...
- 275
-1
votes
0
answers
49
views
different thread read old value even previous update finish when in concurrency
my project is a spring boot 2.x, mybatis 3.x and mysql 8.0(default isolation level - repeatable read).
I have a BServiceImpl:
@Slf4j
@Service
public class BServiceImpl extends CommonService {
@...
- 1,187
-2
votes
0
answers
36
views
Cannot connect to a MySQL database [duplicate]
I'm doing a litle project for myself in Android Studio with the use of Java and I want my application to connect to a database I created for it. I followed few tutorials (links below) and none of them ...
- 1
-1
votes
0
answers
31
views
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver in Eclipse dynamic web project [duplicate]
creating simple dynamic web project. I am facing the exception class not found in my servlet, even after I added my jar file.
the project works fine earlier, but after deleting my server and adding it ...
0
votes
0
answers
52
views
Could not write JSON: Infinite recursion (StackOverflowError)
I am developing a web project with spring boot using jpa, I have a problem using swagger and testing an api of mine named getAppointmentById, I tried using @JsonIgnore, @JsonManagedReference, @...
-1
votes
1
answer
60
views
Improve performance of method
I need to improve the performance of my code. I have the following code:
public List<ArticoliDett> settaArticoliPreSalvataggio(Iterator iteratore){
try{
List<ArticoliDett&...
- 2,113
0
votes
0
answers
32
views
Query is not fetching the latest data from MySQL while using FOR UPDATE clauses
I have a table which locks rows as per accountId and a lock status column having values 0 and 1.
CREATE TABLE lock (
id INT(11),
accountId INT(11),
isLocked TINYINT(2),
);
The requirement is ...
-1
votes
0
answers
21
views
How to combine firstname,middlename,lasname with null case in HQL search query
In my application I've saved staff name as first name, middle name & last name separately on the database. So if the user enters the full name or part of the name to search the staff, it should ...
- 2,023
0
votes
1
answer
56
views
Trying to return a single value from MYSQL to Java but getting 0.0
If I run this query in MYSQL to get the time taken for the last query:
SELECT sum(Duration)
FROM INFORMATION_SCHEMA.PROFILING
WHERE QUERY_ID = (SELECT MAX(QUERY_ID) FROM INFORMATION_SCHEMA.PROFILING);
...
2
votes
0
answers
64
views
How do you cancel a long-running MySQL query via JDBC?
I have a long-running query that I run against a MySQL 8 database via JDBC. My goal is to be able to exit this query on some trigger (e.g. external signal, data processing error, etc.) and have the ...
- 61
0
votes
0
answers
21
views
ORM connection behaves differently for two different codes
I had two different codes and I needed to make an ORM connection and create a table out of the given code:
code 1:
package com.scm.entities;
import jakarta.persistence.Column;
import jakarta....
