All Questions
7,380 questions
-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
0
votes
0
answers
35
views
MyBatis PersistenceException: Communication link failure with DB on VM intermittently while using services on Kubernetes
nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC ...
- 37
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
...
0
votes
1
answer
187
views
How do I add MySQL Connector/J to a Gradle IntelliJ project?
I'm trying to create a Gradle project using IntelliJ 2024.3 and MySQL Connector/J 8.4.0, but every attempt (save one) fails at runtime with a ClassNotFound exception.
I attempted to follow the ...
- 1
2
votes
1
answer
565
views
kafka mysql source connect errorKafka Connect JDBC Source Connector Fails to Start: IllegalAccessError due to ClassLoader Issue
Translated by ChatGPT
I'm encountering an error while trying to run a Kafka Connect JDBC Source Connector task(connect-standalone). The error stack trace shows an IllegalAccessError when Kafka Connect ...
- 71
0
votes
0
answers
260
views
Connecting SQL Developer to MySQL database
I have Oracle's SQL Developer 24.3 (uses Java 17 in the background) and want to connect to MySQL Server 8.0.18. Using MySQL's J-connector I can connect to MySQL database (Tools->Preferences->...
- 6,487
0
votes
0
answers
103
views
MySQL and JDBC connection to Azure for MySQL using SSL without modifying Java code
I have a Java application that I don't have the source code to. I do have a configuration file that is pointed at a local MySQL server instance. The connectionstring was
jdbc:mysql://localhost:3306/...
- 10.6k
2
votes
1
answer
86
views
Alter table showing errors in JDBC programs
I am trying to add two columns in an already existing table Contact_Info using MySQL.When I am doing this using MySQL command line client, its wrking perfectly. But if I try to do this in a JDBC ...
- 644
1
vote
0
answers
52
views
mysql table locks failing tomcat connection pooling and http
I need to execute the below commands though mysql scheduler to refresh the full-text indexes in a table -
ALTER TABLE some_table DROP INDEX full_text;
ALTER TABLE some_table ADD FULLTEXT INDEX ...
- 5,758
1
vote
0
answers
21
views
MySql jdbc socket closes 5% of streaming queries
The code connects to read-replica db using com.mysql.cj.jdbc.MysqlDataSource. For each of about 800 long-running medium to large queries (10k - 200k rows) running in parallel (64 coroutine limit), in ...
- 31
1
vote
0
answers
101
views
jdbc connection to mysql mysqld 8.0.37 over SSL
I have one application server and one database server both linux, application server is using tomcat and we are connecting to MySql DB server using JDBC, so far i was not facing any issue as SSL was ...
- 530
0
votes
0
answers
58
views
Problem with stored procedure that not save my rows
I do a stored procedue in my db, I have more of 1 row if I run stored procedure in mysql workbench, but if I try to debug my programm result set is empty
I tried debug, but rs is empty. This is my ...
0
votes
0
answers
29
views
How to update a record in a mysql table with Confluent JDBC sink connector only if the record I'm going to insert is greater than the current record
I would like to know if it was possible to update a record via Confluent's jdbc sink connector only if the value I am inserting is greater than or equal to the current one. This is because my KSQLDB ...
- 1
0
votes
0
answers
22
views
getting different boolean values while connecting to sql server
DatabaseConnection.kt
import java.sql.Connection
import java.sql.DriverManager
import java.sql.PreparedStatement
import java.sql.ResultSet
class DatabaseConnection {
fun validateUser(username: ...
0
votes
0
answers
39
views
UTF-8 characters are not stored in SQL table in right format
I am trying to write a dataframe in SQL table which is having some extended ASCII characters like 'em-dash', 'pound symbol', but they are not written in the DB table, instead showing some junk ...
