Questions tagged [mysql-connector]

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...
Min Joon So
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...
mFeinstein
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...
Richard
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...
Steele Stonick
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...
Guilherme Gusman
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...
Pherdindy
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?
BioLogic
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...
Lia
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...
Angriffskeule
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...
Nico Albers
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...
Zaid
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 | +----------+-----...
Oliver Angelil
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...
Idan Shechter
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...
Ruoxi
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...
warchiefbinar
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...
J Vines
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:...
Dror B.
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...
Simon
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...
yrz
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...
kama
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...
Aksheer Mittal
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...
ankur
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...
Thomas Hagen
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...
chk.buddi
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...
CDixon
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...
Fortune
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...
Brueni
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...
imtiaz rupu
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...
Enzomatric
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...
AlexJamBach
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...
Tim
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...
Tim
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...
Thomas Matthews
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.
Continuation
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...
Thomas Matthews
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...
muncherelli
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...
Lyubomyr Shaydariv
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...
oshai

View additional questions