Skip to main content
2,544 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
Advice
0 votes
0 replies
38 views

This is not actually a question: I simply stumbled upon a solution. In setting up a new (Win11) computer I was having trouble making my usual connection between MS Access on my machine and a MySQL ...
phc_joe's user avatar
  • 103
0 votes
0 answers
179 views

Using Delphi 10.3, FireDAC, 64 bit application, MySQL. Error: Could not convert variant of type (Null) into type (OleStr) Really simple query as a test: FDQuery1.Close; FDQuery1.Sql.Clear; FDQuery1....
AndyD's user avatar
  • 9
-2 votes
2 answers
95 views

I’m dealing with a repeated crash in a custom Linux application and hoping to get advice or confirmation or suggestion on the root cause. The application connects to an SFTP server, downloads a daily ...
Muhammad Myy's user avatar
  • 61
0 votes
1 answer
79 views

I need to pass a list of IDs as a parameter to a Doris query. Example: SELECT * FROM my_table WHERE id IN (1, 2, 3); I want the values 1,2,3 to come from parameters rather than hard-coding or ...
Salman Pary's user avatar
  • 11
-4 votes
0 answers
100 views

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 ...
user1129682's user avatar
  • 1,111
-2 votes
1 answer
120 views

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 ...
Ilya Chalov's user avatar
  • 311
-1 votes
1 answer
59 views

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 = ?; ...
Shehan Lakshitha's user avatar
  • 438
0 votes
0 answers
51 views

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 ...
user3305465's user avatar
  • 11
0 votes
0 answers
150 views

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 ...
tusharRawat's user avatar
  • 639
1 vote
0 answers
73 views

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 ...
jonny's user avatar
  • 34
-4 votes
1 answer
98 views

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 ...
Joelkoellner Koellner's user avatar
  • 7
7 votes
2 answers
183 views

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. ...
pacmaninbw's user avatar
  • 725
1 vote
1 answer
73 views

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 ...
Meenti's user avatar
  • 63
0 votes
1 answer
77 views

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 ...
Young's user avatar
  • 78
1 vote
0 answers
29 views

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 ...
Riccardo Carassale's user avatar
  • 21
-1 votes
2 answers
111 views

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 '...
Giacomo Pellegrini's user avatar
  • 1
0 votes
1 answer
74 views

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 ...
Riccardo Carassale's user avatar
  • 21
0 votes
1 answer
84 views

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 ...
Sergey Or's user avatar
  • 1
1 vote
4 answers
202 views

This is my fairly simple SQL: SELECT CONCAT( '{ ', '"test": ', '{', '"a": true,', /* don't set to false */ '"b":...
Curtis's user avatar
  • 3,497
1 vote
0 answers
64 views

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 ...
Pranay Domal's user avatar
  • 25
0 votes
0 answers
96 views

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=...
qwerty's user avatar
  • 13
0 votes
0 answers
85 views

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 ...
Aditya Hagawane's user avatar
  • 1
2 votes
1 answer
77 views

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 &...
Charles Florestal's user avatar
  • 61
1 vote
0 answers
51 views

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 @...
박아론's user avatar
  • 11
0 votes
0 answers
37 views

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 ...
romex's user avatar
  • 1
0 votes
0 answers
75 views

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 ...
Charles Florestal's user avatar
  • 61
-1 votes
1 answer
63 views

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 ...
Arcus's user avatar
  • 59
2 votes
2 answers
77 views

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 ...
Noodle_Soup's user avatar
  • 123
1 vote
1 answer
75 views

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 ...
sherring's user avatar
  • 141
0 votes
1 answer
189 views

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 ...
giles3's user avatar
  • 497
0 votes
1 answer
69 views

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(...
Alok's user avatar
  • 11k
0 votes
0 answers
76 views

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 ...
Python404's user avatar
  • 35
1 vote
0 answers
47 views

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}; ...
FabienM's user avatar
  • 3,903
2 votes
1 answer
381 views

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 ...
Archimedes Trajano's user avatar
  • 43.3k
0 votes
0 answers
66 views

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 ...
Anse's user avatar
  • 1,710
1 vote
0 answers
128 views

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 ...
Airlangga Fidiyanto's user avatar
  • 314
-1 votes
1 answer
64 views

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 ...
David542's user avatar
  • 112k
-1 votes
1 answer
323 views

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 ...
Andios's user avatar
  • 1
0 votes
0 answers
115 views

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 (...
GrahamB's user avatar
  • 1,478
2 votes
0 answers
86 views

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 ...
Sean Rogers's user avatar
  • 21
0 votes
2 answers
58 views

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', ...
Aditi B's user avatar
  • 1
-1 votes
1 answer
55 views

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 ...
Anand Hotti's user avatar
  • 1
1 vote
0 answers
53 views

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 ...
Luca Simone Bernardini's user avatar
  • 11
-1 votes
1 answer
70 views

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 ...
Anand Hiremani's user avatar
  • 1
0 votes
0 answers
69 views

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. ...
Deepanshu Yadav's user avatar
  • 125
0 votes
0 answers
465 views

Database JDBC URL [Connecting through datasource 'HikariDataSource (HikariPool-1)'] Database driver: undefined/unknown Database version: 8.0.40 Autocommit mode: undefined/unknown Isolation level: ...
Arun Kumar's user avatar
  • 1
1 vote
1 answer
82 views

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 "...
Mike's user avatar
  • 75
-1 votes
2 answers
97 views

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&...
Ryan Vande Water's user avatar
  • 1
0 votes
0 answers
95 views

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 ...
Hilly B's user avatar
  • 1
0 votes
0 answers
64 views

(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 "...
Peterpanman's user avatar
  • 13

1
2 3 4 5
…
51