Questions tagged [mysql-connector]
536 questions
1
votes
1
answer
39
Views
Using connector c++ to access MYSQL database (How to add a path to my standard search directory)
I am relatively new to programming&C++ and just began learning about MYSQL. I have been searching for a couple of days but couldn't find a solution. I usually use Cygwin&VIM&g++ to write, compile and run codes that I write.
My goal is to retrieve data from MYSQL database that I've set up on my lapt...
1
votes
0
answer
307
Views
Connect to MySQL in RDS using Java Connector/J and SSL
I am struggling to get my java code (that uses HikariCP) to connect with my database on AWS RDS using SSL. I can connect with the database using MySQL Workbench, I just can't find out how to configure the MySQL Connector/J 5.1.45 driver to access the database using SSL.
Currently this is my HikariCP...
1
votes
0
answer
127
Views
Python MySQL Connector: Why do I get different error messages depending on user for the same error?
I am connecting to a mysql database to get some data. It works fine, but I am trying to build in error checking in the event something goes wrong.
Here is the test code (without error checking):
conn = mysql.connector.connect(
user='pool',
password='password',
host='127.0.0.1',
database='emsdb')
con...
1
votes
0
answer
111
Views
Connect C++ WINAPI to MySQL with Connector/c++ Error: 1045 Access denied for user non-localhost
I am developing a WINAPI C++ program in which I need users to be able to log into accounts from a website. I have never integrated MySQL into a c++ program and I am running into this issue. My MySQL is hosted with my website by dreamhost.com so the MySQL server is not on my computer but it is with d...
1
votes
0
answer
323
Views
Scope provided not working with mysql-connector-java maven war
I've been trying to find a solution for this for a long time without success.
I have analyzed the dependence tree and seems to have no other lib requiring mysql-connector-java. Besides that, even with scope provided, the jar is being packed on the final war.
My dependency in pom.xml:
mysql
mysql-con...
1
votes
0
answer
267
Views
I installed my MySql Connector/Net before I installed the .NET core 2.0 did I do this installation correctly?
I installed .NET Core 2.0 after installing the MySQL Conector/Net 6.10.6. The requirement of the MySQL Connector with the version I have is to have a .NET Core 2.0, I am not sure if there will be an issue if I installed the connector prior to the .NET Core 2.0.
Shown are the MySQL Connector/Net requ...
1
votes
2
answer
343
Views
Difference between jdbc driver and connectors
From what I understand, jdbc drivers provide interface to connect to database,read data,write data. But isn't informatica connectors also about the same thing i.e. connect to database,read data,write data. then what is the difference between the two?
1
votes
0
answer
509
Views
Connecting eclipse to phpmyadmin XAMPP
project picture
Hi,
I hope I will ask my question correctly. I don't want to be restriced from asking questions here at stackoverflow.
I opened a new project with eclipse and tried to connect to the XAMPP phpmyadmin database and tried to integrate a mysqlconnector.jar into the project but this does...
1
votes
1
answer
32
Views
Save Table from MySQL as dictionary in Python with MySQL Connector
Im trying to get Values from a MySQL Table and save them as a dictionary in Python, using MySQL connector since I couldnt manage to install anythingelse...
My problem is that it prints all key-value pairs, but only the last one/last row gets saved in the dictionary f[]. How do I get it to save every...
1
votes
0
answer
453
Views
ssl not working with MySQLdb but with mysqlconnector
unfortunately I can't get MySQLdb to work and neither connect via command line to an AWS server which requires me to use SSL. This strangely works fine via SequelPro.
What works?
Beside the mentioned GUI, programmatically I use mysqlconnector instead of MySQLdb as engine and pass ssl args and this...
1
votes
1
answer
71
Views
why is rs.Next() skipping column [closed]
i have been trying to build a GUI which takes the images from the MySQL DB and displays one after each when the next button is clicked, it works fine except it skips one image and displays one after it, i have checked the id of the same row the id is skipped as well so i presume it's a problem mysql...
1
votes
0
answer
23
Views
MySQL connector in python: insert row error
I have a table 'persons' in database 'testdb'. The following shows up when executing the following in the mysql command line:
SELECT * FROM persons;
+----------+----------+-----------+----------------+-------------+
| PersonID | LastName | FirstName | Address | City |
+----------+-----...
1
votes
0
answer
27
Views
Entity Data Model silently quits
Before I describe the problem, I want to let you know that I went over like 30 different answers on Stack Overflow that seems to be similar to my problem, but none of thee solution helped me solve this.
The issue:
The wizard while creating ADP.NET Entity Data Model quits after I click 'Next' in the...
1
votes
1
answer
221
Views
Python mysql memory leak in insertion
I'm inserting millions of rows in MySQL using Python3 but I found the memory usage keeps growing and finally reached 64GB. I tried to diagnose the problem and here is a reproduction of the problem: say I have 100 CSV files. Each file contains 50000 rows and I want to insert them into the database. H...
1
votes
0
answer
416
Views
mySQL C++ connector Visual Studio 2017
I am pretty new to Visual Studio.. Couldn't find similar topic so starting the new one.
I'm developig an MFC app and I'd like to use mySQL database engine.
I believe I have followed instructions from the official site to install the C++ connector:
Building Connector/C++ Applications: General Conside...
1
votes
0
answer
231
Views
DBX Error: Driver could not be properly initialized
DBX Error: Driver could not be properly initialized. Client library may be missing, not installed properly, of the wrong version, or the driver may be missing from the system path..
The above error occurs when attempting to open SQL window (right-clicking MySQLConnection in Data Explorer panel) or w...
1
votes
0
answer
85
Views
Stopping spark session does not close metastore mysql connections
I'm using Spark 2.3.1 and Connector/J 5.1.47.
I wrote a simple program just to check the metastore connectivity:
from pyspark.context import SparkContext
from pyspark.sql import SparkSession
from pyspark.conf import SparkConf
conf = SparkConf()
conf.set('javax.jdo.option.ConnectionURL', 'jdbc:mysql:...
1
votes
0
answer
196
Views
Expected to read 4 header bytes but only received 0
I have written a windows service which uses SSH (Secure Shell) to copy data from a CSV file to PhpMyAdmin online database.
There was an error trigger when the connection opens,
MySql.Data.MySqlClient.MySqlProtocolException
HResult=0x80131509
Message=Packet received out-of-order. Expected 2; got 1.
S...
1
votes
1
answer
174
Views
GlassFish 5 and MySQL Connector
I use GlassFish 5 with mysql-connector-java-8.0.13.jar
and CLASSPATH values:
C:\Program Files\glassfish5\glassfish\lib
C:\Program Files\glassfish5\glassfish\domains\domain1\lib
C:\Program Files\glassfish5\glassfish\domains\domain1\lib\ext
After several restarts of both the server and the laptop...
1
votes
0
answer
25
Views
sqlalchemy dbapi How to transfer args to cursor?
https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/engine/default.py
def create_cursor(self):
if self._use_server_side_cursor():
self._is_server_side = True
return self.create_server_side_cursor()
else:
self._is_server_side = False
return self._dbapi_connection.cursor()
the mysql connec...
1
votes
1
answer
12
Views
Connect with more than two databases using Django ORM, one database is legacy database without migrate into app
We want to connect a remote existing database from settings.py, can we use those tables directly using model without migrate from app.
We know about the legacy database connection but inspect.db command always asks to migrate the connected database.
Is using mysql connector is preferable or it is ou...
1
votes
1
answer
64
Views
cannot connect to mysql rds instance using .NET mysql connector
We need to enable TLS1.1 connections on mysql rds instance. I have a console application that I am using to test my connection to the mysql RDS instance.
After many to-and-fros with Infra team, it is confirmed that mysql instance is using TLSv1.1. Please find the command outputs that I have run in...
1
votes
1
answer
150
Views
Python mysql.connector - cursor.execute("WHERE … ) returns NoneType
I wanna code a login page using flask, but the value of the users that I get out of my database always is a NoneType. Even if the username that's entered in the login form is the same as the one in the database. I think I might have an error in the SQL Query but I can't figure Out where it is. I app...
1
votes
1
answer
134
Views
Failed to determine a suitable driver class in Google Cloud Platform
when running my spring-boot app, it throws the following error on google cloud.
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception; nested exception is
Caused by: org.springframewor...
1
votes
0
answer
86
Views
token must be bytes, 'List' is not callable? P3.7
I'm trying to verify the password input of user with the password (encrypted) in MySQLdb:
Working with mysqlconnector, python 3.7
encryptor.py :
from cryptography.fernet import Fernet
#---key-----
key = b'Ys_G_ziOS1AFs6X-jD3rtgsh77b3HpF7A-yiGpH-5Fg='
cipher_suite = Fernet(key)
cipher_text = cipher_s...
1
votes
1
answer
583
Views
“WFLYCTL0412: Required services that are not installed:” => [“jboss.jdbc-driver.mysql”]
I am trying to add a mysql datasource to my wildfly(Jboss15.0.0) server.
But I encounter the following error:
WFLYCTL0013: Operation ('add') failed - address: ([
('subsystem' => 'datasources'),
('data-source' => 'MySqlDS')
]) - failure description: {
'WFLYCTL0412: Required services that are not inst...
1
votes
1
answer
18
Views
C++ with sql connector getting metadata without asking for to much data
I just started working with the sql conenctor in C++ (and sql).
I need to write a bunch of header files from objects out of a database. (MariaDB but would be great if it works on all sql dbs)
My Solution so far is getting the tablenames with
res = stmt->executeQuery('SHOW TABLES from ' + dbname);
w...
1
votes
1
answer
90
Views
Load CSV data into MySQL using Python, create table and add record
Unexpected error:
My code to create a table and add a record from a csv, not sure how to rectify the error, should I use the same variable as in csv?
1
votes
1
answer
80
Views
Enabling mysql support in PHP
I am trying to add MySql support in PHP. I am using PHP version 7.2.11. When i'm trying to run my application, it shows the following error:
Your PHP installation does not have MySQL support. Please enable MySQL support in PHP or ask your web host to do so for you.
This problem didn't occur when i t...
1
votes
1
answer
38
Views
Hibernate cannot parse connection String
According to Mysql documentation, this connection string from xml configuration file is correct:
jdbc:mysql:///database?useSSL=false&allowPublicKeyRetrieval=true
And Mysql Connector/J parses the query parameters correctly.
However same connection string fails to be parsed correctly when Hibernate co...
1
votes
1
answer
20
Views
No suitable driver found for jdbc:mysql//localhost:3306/Test in Eclipse
i'm aware that this question got asked several times, but the answer is always to add the .jar to the build path. I have done this but still get the 'No suitable driver found for jdbc:mysql//localhost:3306/Test' exception.
Any other ideas what could be wrong? I added some shots and my code to test...
1
votes
1
answer
1.5k
Views
mySql Connector exception (C++ library for mysql) when inserting row into non-empty table
I have not done much database programming at all. I am working from some example code for using MySQL Connector/C++.
When I run the following code I get a crash on the last line in some std::string code - but it ONLY crashes when the table is not empty. If the table is empty, it inserts the row an...
1
votes
1
answer
2.2k
Views
How do I update a value in a row in MySQL using Connector/C++
I have a simple database and want to update an int value. I initially do a query and get back a ResultSet (sql::ResultSet). For each of the entries in the result set I want to modify a value that is in one particular column of a table, then write it back out to the database/update that entry in t...
1
votes
1
answer
504
Views
MySQL: Appending records: find then append or append only
I'm writing a program, in C++, to access tables in MySQL via the MySql C++ Connector.
I retrieve a record from the User (via GUI or Xml file).
Here are my questions:
Should I search the table first for
the given record, then append if it
doesn't exist,
Or append the record, and let MySQL
append th...
1
votes
1
answer
1.6k
Views
MySQL, C++: Retrieving auto-increment ID
I have a table with an auto-incrementing ID. After inserting a new row, I would like to retrieve the new ID.
I found an article that used the MySQL function LAST_INSERT_ID(). The article says to create a new query and submit it.
I'm using MySQL Connector C++, Windows XP and Vista, and Visual St...
1
votes
1
answer
1.6k
Views
How to make Django work with MySQL Connector/Python?
Has anyone made Django work with myconnpy?
I've checked out http://github.com/rtyler/connector-django-mysql but
the author said it's very outdated and not supported.
If you've managed to make Django work with myconnpy, please share your
experience.
Thanks.
1
votes
1
answer
1.4k
Views
MySql Connector prepared statement only transfers 64 bytes
I am using the MySql Connector C++ to store a JPEG image from a file into the database. I am using the prepared statement. After execution of the prepared statement, only the first 64 bytes of the file are copied into the database.
My research of examples show that no iteration is necessary and...
1
votes
1
answer
135
Views
Storing Config Values
Wondering if I am going about this the right way. I am creating a C# application that loads a few variables from my App.Config.xml file. I am loading these into a 'config' class (Config.cs) along with other variables that I am loading from a MySQL database. This is what my class looks like so far...
1
votes
1
answer
924
Views
MySQL JDBC driver & FLOAT(N, M) column type
I've recently got a bug that's somewhat weird for me. Let's consider that we have a table with a column of FLOAT(8, 3). Let's also consider we have a validated table editor accessible via web browser. The table editor supports the client-side validation for every column, and does not allow to put fl...
1
votes
1
answer
395
Views
error when using mysql connector-j
I have an error in log after when trying to update the database:
java.sql.SQLException: Streaming
result set null is still active. No
statements may be issued when any
streaming result sets are open and in
use on a given connection. Ensure that
you have called .close() on any active
streaming resu...