FAQ Database Discussion Community


Getting the latest version of MySQL for EF6

c#,mysql,asp.net-mvc-3,entity-framework-6,mysql-connector
For my website I am using MySQL for EF6. When I set it up, I was told to use the 6.8.3 version, so I have MySql.Data v6.8.3 and MySql.Data.Entity.EF6 v6.8.3 that I installed via Nuget. Here's the values from my packages.config file: <package id="MySql.Data" version="6.8.3" targetFramework="net45" /> <package id="MySql.Data.Entity.EF6" version="6.8.3"...

MySQLSyntaxErrorException in SQL syntax

java,mysql,jsp,mysql-connector
I am trying to select data from a table using prepared statement. But it seems like I am getting syntax error which I cannot solve alone. try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/mydb"; String dbusername = "root"; String dbpassword = ""; // Change it to your Password // Setup the...

Can't Create Entity Data Model - using MySql and EF6

mysql,entity-framework,visual-studio-2013,mysql-connector,ado.net-entity-data-model
I'm trying to add an edmx Entity model to my C#/Web Project in Visual Studio 2013. My problem is that the file is not created. I do the following steps: Give the item a name Choose 'EF Designer from database' Choose the connection from the drop down (localhost) that already...

install mysql-connector in side installation of python (in addition to default python install)

python,mysql,mysql-connector,mysql-connector-python
I have a linux CENTOS 6.6 server that has python2.6.6 installed by default. I need a python version of 2.7 but CENTOS 6.6 NEEDS its default python2.6.6 install present for various system reasons (yum depends on 2.6.6). As such, I installed python 2.7 in a separate location (/usr/local/lib/python2.7/). Now I...

Use the same buffer for separate DATE and TIME

mysql,c,mysql-connector
I am using the MySQL C api along with prepared statements. When issuing a INSERT query with a TIME field the result is in HHH:MM:SS format, where the hours are the amount of hours elapsed this month. For instance if the date is 2015-02-21, and the time is 21:30:00 the...

Is MySQL Connector C++ cgi program vulnerable to MySQL injection just like php is?

c++,mysql,security,cgi,mysql-connector
I am making a cgi program using C++. It allows users to register their information on the website and also login. I am worried about security. Normally, MySQL is vulnerable to MySQL injection when using php to receive form. I am using the MySQL Connector/C++ API. When using C++, does...

JDBC MySQL Connector [closed]

java,mysql,jdbc,mysql-connector
I have configured mysql-connector.jar file in my java project in Eclipse(Kepler) IDE, I am able to connect to database without any issue. But each time I run the program it gives below error. Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.driver at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown...

Python Exception: RuntimeError: maximum recursion depth exceeded/unprintable runtime error

python,mysql,mysql-connector,mysql-connector-python
I'm getting this exception randomly on a script that receives items to insert into a mysql database using mysql-connector: Traceback (most recent call last): File "/opt/python/current2/lib/python2.7/logging/handlers.py", line 77, in emit Traceback (most recent call last): File "/opt/python/current2/lib/python2.7/logging/handlers.py", line 77, in emit Traceback (most recent call last): File "/opt/python/current2/lib/python2.7/logging/handlers.py", line 79,...

Not able to connect Mysql database to presto - No factory for connector mysql

mysql,mysql-connector,prestodb
I always get this error when trying to start the Presto server in Intellij. 2015-06-05T19:30:32.293+0530 ERROR main com.facebook.presto.server.PrestoServer No factory for connector mysql java.lang.IllegalArgumentException: No factory for connector mysql at com.google.common.base.Preconditions.checkArgument(Preconditions.java:145) at com.facebook.presto.connector.ConnectorManager.createConnection(ConnectorManager.java:131) at com.facebook.presto.metadata.CatalogManager.loadCatalog(CatalogManager.java:88) at...

Javascript Error: SyntaxError: missing ; before statement

javascript,syntax-error,mysql-connector
I have the following code snippet. I have tried all the possible things mentioned on StackExchange but am unable to spot the error in my code. <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@ page import="java.sql.*" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta charset="utf-8" /> <title>Twitter Mapper</title> <link...

Create MySQL infinite loop

c++,mysql,mysql-connector
I am working on creating test functions for a project that work independently of what data is currently in the database. Specifically, I want to have a test case that demonstrates OPT_READ_TIMEOUT is working. I found out that MySQL has while statements and figured that I would just make an...

MySQL Connector Entity Framework - Type not discovered in same assembly

asp.net-mvc,entity-framework,mysql-connector
I installed MySQL Connector/NET via Nuget (specifically Mysql.Data and Mysql.Data.Entities 6.8.3) and followed the instructions on the MySQL site to set it up. This is how I am setting up the EF configuration: DbConfiguration.SetConfiguration(new MySqlEFConfiguration()); No matter what I do, I get a runtime error: System.InvalidOperationException: An instance of 'MySqlEFConfiguration'...

CString Format adds null value for MySQL query

mfc,mysql-connector,c-string
I have to add data to databse. Im using MySQL Connector in my vc++ application. Im following below method to create and insert values to some columns in that table. if(mysql_query(&dbSql , "CREATE TABLE IF NOT EXISTS perfscoretbl (SessionID CHAR(100) NOT NULL,TagName CHAR(50) NOT NULL ,\ Description CHAR(50) NOT NULL,TagLow...

ASP.net code return open session errors

mysql,asp.net,vb.net,visual-studio-2012,mysql-connector
this look like a simple issue but been need some help with this. When I am trying to run the following code I just get the error below. I did make sure the connection was opened and also made sure proper mySQL connection coding structure was followed. I'm just lost...

ResultSet ->getString() crashes when value is >=16

c++,mysql,crash,database-connection,mysql-connector
ResultSet *search; .... .... search= prepareStatement->executeQuery(); while (search->next()) { cout << "Email Found: " << search->getString("EmailColumn") << endl; //crashes here } From the code above, calling getString() function actually gets the value from the database. But then it crashes the program. It displays the value then crashes the program. I...

persist java LocalDate in MySQL

java,mysql,jpa,jdbc,mysql-connector
I'm writing a java client application using: SE 8, MySQL 5.6 (Connector/J 5.1), JPA 2.1. when I try to persist an entity with an ID (int Auto-increment), date (LocalDate). it throw an Exception says: Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '\xAC\xED\x00\x05sr\x00\x0Djava.time.Ser\x95]\x84\xBA\x1B"H\xB2\x0C\x00\x00xpw\x07\x03\x00\x00\x07\xDF\x03\x06x' for column 'date' at row 1 does...

mysql/connector python query works in mysql but not python

python,mysql,mysql-connector
I've seen the following two answers: python - mysql query not working SQL query works in console but not in python And neither of the solutions work for me. I'm running the code below which completes without any errors every single time yet does not at all modify the mysql...

Is there a native C++ connector for mariadb/mysql that is not just a wrapper for an older c connector? [closed]

c++,mariadb,mysql-connector
Has anyone released a native c++ connector for mariadb/mysql that is not a wrapper for a c connector api? I've googled around and can't find anything. The reason I ask is to judge the ultimate value of using a c++ connector versus just implementing the c connector itself without the...

How to install Mono mysql connector on ubuntu server

mysql,mono,mysql-connector
I download with wget and unzip.After Go v4.5 and install with gacutil /i MySql.Data.dlland itry compile with gmcs -r:System.dll -r:System.Data.dll -r:MySql.Data.dll Sql.cs And i get this error error CS0006: cannot find metadata file `MySql.Data.dll' Compilation failed: 1 error(s), 0 warnings ...

Cannot Uninstall MySql Connector .Net 6.9.3, failure at MySql.Web.v20.dll

mysql,.net,windows,mysql-connector
Env: Windows 7 and 8.1, both x64 I am unable to uninstall MySql Connector.Net or install the update. I looked at the error log and failure occurs at this juncture. Uninstalling assembly 'C:\Program Files (x86)\Development\Database\MySQL\MySQL Connector Net 6.9.3\Assemblies\v2.0\MySql.Web.v20.dll'. Affected parameters are: logtoconsole = logfile = C:\Program Files (x86)\Development\Database\MySQL\MySQL Connector Net...