All Questions
2,127 questions
1
vote
1
answer
50
views
Diff between locking and isolations which to use to handle concurrency
I read about the locking mechanisms used in db and isolation. if Locking can solve concurrency problems why we need isolation.
I want to understand the diff between both.
do we need to use both to ...
- 11
1
vote
1
answer
77
views
Error "Column count doesn't match value count at row 1" on table insert query in MySQL
Pretty common error, and I thought it would be easy to solve, but in this case, unfortunately I couldn't figure it out.
Java project connected to MySQL, set up with Connector/J.
Error occurs when ...
- 45
-1
votes
1
answer
38
views
Connecting to a databse in a VM
I'm practicing with conexions between java and databases for a future project but i came to a "dead" end.
My problems is that i have (System A: 192.168.1.6) and (System B: 192.168.1.254) ...
- 1
0
votes
1
answer
39
views
SQL Query to fetch final data for hierarchal configuration tables in a single query
I have two tables i.e. config_attr and config. I am working with MySQL 8.0.32.
config_attr -> This table has attribute name and its default value.
config -> This table has overriden or current ...
-1
votes
3
answers
253
views
Im goining to connect Mysql using Spring boot Java. but i gave errors. im new for this [duplicate]
Caused by: org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution [Access denied for user 'root'@'localhost' (using password: YES)] [n/a]
Caused by: org....
0
votes
0
answers
459
views
Unable to load authentication plugin with MySQL Authentication Plugin
I'm encountering an error in my MySQL application, and I'm seeking assistance in resolving it. I'm using MySQL Connector/J to connect to a MySQL database, and I keep encountering the following error ...
- 1
0
votes
1
answer
60
views
How can i make a primary key chose the table to link to between two tables (specifically where the primary key exists)? [duplicate]
I have three tables of concern to my problem: students, staff, and issued_books. The issued_books table has book_id column (reference to the books table) and user_id column (reference to either ...
-1
votes
1
answer
67
views
Updating List of values in MyBatis - SQLSyntaxErrorException
Getting SQLSyntaxErrorException while updating List of values in MyBatis. I am using separator=";" in forecach tag, but still I am getting the error. Below is my sql query
<update id=&...
- 49
0
votes
1
answer
41
views
How does java get an index of a database table and distinguish between a unique index and a full-text index
I want to get all the information about the database table to generate a DDL statement, but there is no way to tell if the index is a full-text index.
// 获取连接
Connection conn = ...
- 1
0
votes
1
answer
99
views
I cannot connect my database with my javafx app listview
I'm in need of help. I'm making a simple app in javafx, the app has to connect with a database and return some data that I will show on a listview right as the app loads.
The thing is, that I can't ...
- 11
0
votes
1
answer
785
views
My javafx app throws an error when trying to connect with the database
Good day, people. I've come to crash into an error that I can't find solution for yet, so I really need your help.
The program is as it follows: A desktop app made with Javafx (Maven) and Scenebuilder,...
- 11
1
vote
0
answers
316
views
Why is the configuration property 'spring.data.cassandra.password' considered deprecated?
I'm trying to connect my spring boot application with MySQL database.when running the application following exception occur.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using ...
2
votes
1
answer
143
views
When are mysql save a new binlog file?
I'm developing 1 java application to reading a binlog file to catch query event. Everything would be fine without exception. But what will happen if my application was crashed, i will miss many event ...
- 53
1
vote
0
answers
22
views
Keep getting warning java.sql.SQLSyntaxErrorException [duplicate]
warning image
i keep getting this message in netbeans while doin project for collage
how to fix it?
try{
stmt = conn.createStatement();
int stdId = Integer....
0
votes
1
answer
77
views
Connection to database using MySQL in Java
I am trying to connect to a database using MySQL. The error I get is:
"com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure"
Any ideas what can cause this?
...
