2,544 questions
-4
votes
0
answers
64
views
Why is only my MySQL client on Windows 11 slow? [closed]
I have a brand new computer with Windows 11 and I am facing a performance issue with MySQL I do ovserve on any other machine on the network and I not know how to fix.
The MySQL server is running on a ...
- 1,111
-2
votes
1
answer
95
views
Why C# program (MySQL Connector/NET, .NET 8.0) compile on command prompt with csc, but not in Visual Studio 2022?
I am a novice programmer. I want to work in my 'Windows 10' with MySQL Community Server 8.4 from a C# program (platform .NET 8.0). I am using the Visual Studio Community 2022. I also use MySQL ...
- 311
0
votes
1
answer
56
views
Ballerina MySQL connection error : Error while loading database driver
I am trying to connect to a mysql database using the following code.
import ballerina/io;
// import ballerina/http;
import ballerinax/mysql;
import ballerina/sql;
configurable string dbHost = ?;
...
- 399
0
votes
0
answers
34
views
Collation_connection always set to utf8mb4_0900_ai_ci on a database created with utf8mb4_0900_as_ci
I've an issue with the collation utf8mb4_0900_as_ci (Accent Sensitive) I used for creating everything in a database. Once I connect to the database (I use EFCore 9.0 with POMELO but the problem also ...
- 11
0
votes
0
answers
64
views
Commands out of sync MySQL error - possible missing commit [duplicate]
I'm trying to run:
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXIST abc();
SELECT( IF( ( SELECT 1 FROM information_schema.statistics WHERE index_name = 'abc_x' AND table_name = 'abc' ) > 0, SELECT 0, ...
- 6,467
0
votes
0
answers
146
views
HikariCP connections leak with MySQL long-running INSERT queries
I’m facing an issue where INSERT queries on a MySQL table get stuck in “waiting for lock”, and even after innodb_lock_wait_timeout (50s), the connections are not released back to HikariCP, eventually ...
- 657
1
vote
0
answers
66
views
Mysql ConnectionAttempts increased on AWS RDS after dotnet 6 update to 8
After updating our Dotnet API from dotnet 6 to 8 the connection-attemps on AWS RDS increased significantly (see attached picture).
The API is running in a docker-container.
We use a MYSQL RDS instance ...
- 34
-4
votes
1
answer
94
views
Database not updating, using C# and Windows forms [closed]
I have a SQL database being locally hosted that keeps track of stock, I'm trying to get the SQL command "UPDATE stock SET cantidad = 530 WHERE id = 0" through using a C# Windows form ...
7
votes
2
answers
177
views
How to convert std::chrono::system_clock::now() to boost::mysql::datetime::time_point
I'm using the boost mysql library in a project. I need to use boost::mysql::datetime (datetime) to represent timestamps. A datetime value can be constructed from a boost::mysql::datetime::time_point.
...
- 725
1
vote
1
answer
65
views
Optimizing SQLAlchemy Flush: Intercepting INSERTs for Batched Multi-Row Execution in MySQL
Is there a way to monkeypatch SQLAlchemy in a way that intercepts all INSERT INTO statements generated during a session.flush() without sending them to the database? Instead, I want to capture these ...
- 63
0
votes
1
answer
71
views
Error: "driver class not found" when reading MySQL Catalog in Apache Doris
I want to use the catalog to read MySQL data via Apache Doris, but I get an error: driver class not found.
I have already referred to the docs and communicated with the community, but I am still ...
- 78
1
vote
0
answers
29
views
QtSqlDatabase can't connect to MySql from inside debugger
Im writing a C++ program using QtCreator, Qt 6.9.0 and llvm-mingw1706_64 in Windows11.
It is an user interface toward a MySql database.
If I run the program normally, it can access database with no ...
-1
votes
2
answers
107
views
Why does my compiler not find my header path?
I'm working on a project in C++ and I would like to make a query to a database from my code. I installed MySql C++ connector from the MySql site and now I have to specify the path of the folder '...
0
votes
1
answer
61
views
qsqlmysql loaded library but QMYSQL driver not loaded
I can't connect to my SQL database using QSqlDatabase.
My system is:
Windows 11
Qt 6.9.0
llvm-mingw1706_64
MySql 8.0.41 running on a CentOs virtual machine.
I extract libmysql.dll, libmysql.lib and ...
0
votes
1
answer
73
views
MySQL and Microsoft Entity Framework 8 attaching default database name
I'm struggling with EF8 and MySQL because EF keeps prepending the default database name specified in connection string to every table name, even if the table is in the different db. Below is the ...
1
vote
4
answers
200
views
JDBC is removing part of my query when I run it in Java but it works in my SQL editor
This is my fairly simple SQL:
SELECT
CONCAT(
'{ ',
'"test": ',
'{',
'"a": true,', /* don't set to false */
'"b":...
- 3,497
1
vote
0
answers
63
views
Can't connect to mysql databass using python mysql.connector
I am working on a project in Python tkinter for which I have chosen MySQL as my database. i have downloaded MySQL full version so i have tried to connect MySQL using Python mysql.connector
this code ...
- 25
0
votes
0
answers
82
views
"Public Key Retrieval is not allowed" on first login
I'm trying to automate a MySQL connection using DBeaver's CLI with the following command:
.\dbeaver.exe -debug -con "driver=mysql|name=TestConn|host=10.18.1.92|port=3306|user=appsupport|password=...
- 13
0
votes
0
answers
79
views
Enum Mapping in Oat++ DTOs Causing Runtime & Compile-Time Errors
I'm using Oat++ with custom enums for serializing/deserializing in DTOs and integrating them with a MySQL connector. I'm facing issues when mapping enums to/from JSON and database fields.
I've tried ...
2
votes
1
answer
76
views
(No such file) error - c++ linking library issue from running executable file
I have been trying to develop a simple c++ program to connect to mysql using the mysql connector/c++ library. I have been running into issues after issues. This is the next hurdle. I am new to CMake &...
1
vote
0
answers
46
views
Spring Boot @Transactional(readOnly=true) not releasing connection with AWS RDS + HikariCP
I am using Spring Boot 3.4.3 with MySQL 8.0 and Hibernate 6.6.8.Final on AWS RDS.
I have implemented CRUD operations using JPA and QueryDSL. Everything is working fine except for one issue.
I added @...
- 11
0
votes
0
answers
32
views
Unable to access mysql under source assistant in ssis project
I newly installed mysql92 server and vs 2022 in my local machine. I tried to access mysql server in VS integration service project, but I can't see Mysql under source assistant. As alternative, I ...
- 1
0
votes
0
answers
70
views
MySQL Connector/C++ Driver Files Compiler Linking Error
I am building a simple c++ program and wanted to integrate MySQL database into it. I downloaded and installed the latest MySQL package(mysql-connector-c++-9.2.0-macos15-arm64.dmg) from the official ...
-1
votes
1
answer
61
views
MySQL connector doesn't take "USE db" in account
This works and returns the correct rows :
cursor.execute('SELECT * FROM my_db.my_table')
This doesn't, no rows are returned :
cursor.execute('USE my_db; SELECT * FROM my_table;', multi=True)
Running ...
- 59
2
votes
2
answers
67
views
Excel VBA ODBC reading field changes it to Null
Summary;
The first time I read a data field, I get 0, every time after, the same record field reads Null. This changes if I debug, step through and watch the values in the locals/watchlist, I get Null ...
- 123
1
vote
1
answer
65
views
MySQL, go-sql-driver with google auth token
I am looking to connect to a gcp managed db (running on GCP) via a cloud proxy (jump box with local port to connect to managed instance) with go-sql-driver but everything I've tried gcp MySQL instance ...
- 141
0
votes
1
answer
163
views
No suitable driver found using mysql-connector-java 8.0.33
I have a Java program that used to work and then it stopped working.
The error that I am getting is
java.sql.SQLException: No suitable driver found for jdbc:mysql://feldspar:3306/sndm
I looked into ...
- 497
0
votes
1
answer
61
views
RANK() Always Returns 0 in SeaORM Query
I am using SeaORM in a Rust project and trying to retrieve ranked user balances using MySQL’s RANK() OVER (ORDER BY ...). However, the rank field always returns 0 for all rows.
Rust Code:
#[allow(...
- 10.9k
0
votes
0
answers
76
views
Unable to access MySQL server in Python
So I have set-up a mySQL database and am trying to connect to it from Python. Unfortunately the Jupyter kernel keeps dieing if I try to connect. I don't have much to go on given I don't get an error ...
- 35
1
vote
0
answers
47
views
Is there a way to see interpolated mysql query for debugging in Rust?
In rust, I'm using mysql crate to make query with exec_first() function like this :
let query = r"SELECT NAME from MY_TABLE where VALUE=:age";
let datas = params!{"age"=> 2};
...
- 3,901
2
votes
1
answer
343
views
When using mysql.connector.aio how do we enable connection pooling (assuming it is needed)?
I am trying to port my old mysql connector code to use the asyncio libraries provided by MySQL. When I tried to run it, it said it didn't recognize the pool_name and pool_size.
It didn't explicitly ...
- 43.2k
0
votes
0
answers
57
views
mysql_fetch_lengths() returning array of Int64 on Lazarus/Linux
In Lazarus, I am loading libmariadb.so.3 v3.3.10 via LoadLibrary(). (Did another test with libmysqlclient.so.21 v8.0.41). When iterating through the fields of a query result, the length of a value is ...
- 1,710
1
vote
0
answers
125
views
IntelliJ IDEA not including com.mysql.jdbc.Driver on artifact
I'm making a program that requires connection to MySQL database. When I tried to run my generated .jar file, it shows following error:
No suitable driver found for jdbc:mysql://<my_ip>:3306/mydb
...
-1
votes
1
answer
59
views
How to initialize dict cursor in mysql.connector [duplicate]
I used to be able to do something like:
self.conn = MySQLdb.connect(user=...)
self.dict_cursor = self.conn.cursor(MySQLdb.cursors.DictCursor)
However, now it's not so simple with the new mysql-python ...
- 112k
-1
votes
1
answer
314
views
Where to put the mysql-connector-j-9.2.0.jar on macOS and make it work? [duplicate]
I am trying to connect Java program to MySQL server on macOS. If I am not wrong the mysql-connector-j-9.2.0.jar would be the jdbc component. I can't find a clear configuration instruction on it. I had ...
- 1
0
votes
0
answers
107
views
Debezium mysql connector is capturing schema changes for tables that are not in the table include list
I am using Debebezium CDC with the outbox transformer and we need it to start up as fast as possible. Since we are using the outbox, there is only ever going to be one table that we are interested in (...
- 1,478
2
votes
0
answers
82
views
How to build MySQL plugin with Qt 6 on Ubuntu 22.04?
I will preface that I don't really have any experience using cmake or building C++ projects in general (I'm sure that will become obvious).
I am having problems getting the MySQL driver and using it ...
- 21
0
votes
2
answers
57
views
NameError: name '_mysql' is not defined Mac Django
I was trying to run python manage.py run server while working with Django after changing my settings.py from this:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
...
- 1
-1
votes
1
answer
52
views
java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration while running schematool -dbType mysql -initSchema command
when I run schematool -dbType mysql -initSchema command in command prompt it is throwing below error -
Error: A JNI error has occurred, please check your installation and try again
Exception in thread ...
1
vote
0
answers
53
views
Using the same DbCompiledModel to create contexts..." with Entity Framework
I have a C# project running from about 8 years without problems.
Using .net 4.8 c# entity framework 6 MySql and SqLite.
This year I would like to upgrade mysql db drivers from version 8 to 9.
After ...
-1
votes
1
answer
67
views
Maven mysql dependency connector
how can i connect my maven to mysql dependency for version 8.0.39 which is not present in the maven repository
I saw in the maven repository the version is only upto the 8.0.33 for mysql connector
...
0
votes
0
answers
67
views
How to read data from multiple tables returned by MySQL in Rust?
I'm trying to run a stored procedure of MySQL DB.
I'm able to handle when the SP returns only one table as a result.
But when multiple tables are being returned as a result, then I am facing issues.
...
- 125
0
votes
0
answers
463
views
Database driver showing version and connection ok but undefined/unknown while executed
Database JDBC URL [Connecting through datasource 'HikariDataSource (HikariPool-1)']
Database driver: undefined/unknown
Database version: 8.0.40
Autocommit mode: undefined/unknown
Isolation level: ...
1
vote
1
answer
79
views
When querying MySQL, why does C# get "Error executing query: The given key was not present in the dictionary"?
We are supporting an old version of .Net framework, and we installed package MySql.Data.6.10.9 for the test.
The sample program was able to connect successfully to MySQL v8.0.32, but it gets "...
- 75
-1
votes
2
answers
85
views
Django ORM filter on datetime understands entries with a 'Z' offset, but not '+0000' offset
I have a MySQL database that mirrors a salesforce database. My table has a column for "createddate" that is contains ISO-8601 datetime entries. Some of the entries have an offset of "Z&...
0
votes
0
answers
90
views
Shiro environment initialization failed: org.apache.shiro.config.ConfigurationException
We are running an existing application using wildfly-10.0.0.Final with Shiro 1.2.2
We have upgraded our application from using mysql 5.6 to 8.0.40 and we are now using the latest mysql drivers. The ...
- 1
0
votes
0
answers
63
views
Azure Durable Function Fan Out Fan In and MySQL binding how to use?
(Powershell) When using the Azure Durable Function pattern fan out/fan in, all the data is consolidated in the "type": "orchestrationTrigger. What would be the place to use the "...
- 13
0
votes
2
answers
152
views
RMariaDB installation cannot find MySQL client library
I am trying to install the RMariaDB package (on macOS), but install.packages("RMariaDB") fails with the following message:
-----------------------------[ ANTICONF ]---------------------------...
- 11
-1
votes
1
answer
150
views
ActiveRecord not getting id after save
I got my application to weird state - when I create record (in application or in console), it is created in database, object reports to be persisted, but the object has no id (id: nil).
In summary: ...
- 661
0
votes
1
answer
73
views
Why I am unable to create connection with MySQL using python
The program terminates automatically without throwin any error or output
The port and connector working fine and details are given below
C:\Users\jsr>pip list
Package Version
--------...
- 117