MYSQL :: Installing And Running Connector/J

Linux Installing Connector/j
im using linux a few months ago, im working in a proyect using java stand alone and mysql, but i have a poblem i cant install Connector/J im using SUSE 10.0, if any person can help me installing Connector/J on linux, the readme file tells how install it in classpath but dont understand this is the example of the readme file:

$ setenv CLASSPATH /to/directory of the Connector/J jar file..............:$CLASSPATH

and my linux doesnt reconizaze "setenv" i dont know whats setenv, i dont know whats CLASSPATH,and i try whit:

$ java -classpath /directory of the Connector/J jar file..........

and

$ java -classpath /directory of the Connector/J jar file..........:$CLASSPATH

About Installing The Connector/J In Windows XP With Java JDK 5.0
I am totally new to MySQL. I have to use MySQL Connector/J for my Java program. I have read the document in this offical site. I just teach you to download the zip file, extract it. It then say that to set CLASSPATH. It shows only example for UNIX. I am using Windows XP and I don't know how to set CLASSPATH in XP. In fact, I have no idea to install the Connector/J after extracting the ZIP file. What can I do now.

J Connector Jdk / Jre
My application uses J Connector's 'mysql-connector-java-3.1.6-bin.jar'
file with jdk 1.5 on my Win 2000 system to connect to MySQL running on a
Linux machine on my LAN and it works fine from within JDK. However it does
not work (does not register the 'MySQL J Connector' driver) if I run my
application's jar file using JRE 1.5 which is also installed on my Win
2000 system.

Can J Connector's 'mysql-connector-java-3.1.6-bin.jar' somehow be built
into my application's jar file? Or should it just be placed somewhere in
the JRE directory tree and, if so, then where?

.net 2.0 Connector
About to develop an asp .net site on a windows 2003 server. I am using
Visual Basic .net 2005 to constuct the site. What type of connection to
mySQL should I use - e.g. ODBC or mySQL's .net connector?

PHP Connector
I have MySQL, Apache, and PHP5 installed. The last thing I need to do is to install the PHP connector, but when I go to the http://dev.mysql.com/downloads/connector/php/ link, the directory does not exist :(

Does anyone know of another way to obtain and install the PHP connector for MySQL? I am just setting things up on my local system to start learning PHP development, but without the connector I am sort of stuck.

ASP Connector
I have set up a DSN connection on my local server. The test connections works fine.
It is connecting to an external mysql database.

However when I try to connect using a script it gives me a connection error I am using asp 2.0 and the latest mysql driver for ODBC The code is as follows: Code:

Connector/J Using JSP
we've installed MySQL on a Windows XP machine, but cannot connect to it
using JSP/Servlet. An error message comes up saying:

java.sql.SQLException: General error, message from server: "Incorrect
database name 'water'"
The database water exists on the server.

Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/water
?user=root&password=");

yes, we've tried different databases and the error persists;
yes, we've tried different users and passwords and the error persists;
yes, we looked at the Connector/J documentation and sintax and it is OK
yes, we used google and search for errors but no luc. Code:

What Connector To Use
What is the best choice for establishing a connection between the asp.net web site and the mySQL database?

I will be using asp .net 2.0, and IIS 6.0. The server will be used for multiple web sites with product databases.

I am aware of the issues with a release of the new .net connector version, but I am also aware that compiling the old 1.0.7 connector under .net 2.0 seems to cure any issues (?).

Either way, whats the best choice - ODBC or .net Connector?

Oledb Connector
Is there an oledb connector for MySQL 4.x and where can i find it?
On the MySQL website i can only see a connector for MySQL 3.x

ODBC Connector
I am using ODBC 4.51 and mySQL 4.0.1-NT. I have an app that is written in
vb6 with msAccess 2000 that was converted to mySQL. Everything is working
great except for one thing.

I have a grid of information (using TrueGrid v7) and I need the grid to
update with the newest data.

In msAccess (ADO) I used the adUseServer Cursor / Dynamic Recordset and then
all I had to do was do a tdbgrid1.refresh to get the latest data.
Everything was working just as I wanted.

In mySQL(ADO) when I use the adUseServer, I get no data returned to the
grid, and if I debug the data, it is there, but it doesn't refresh (in the
debug window). Changing to adUseClient puts the data in the grid, but
obviously doesn't refresh either.

The grid will have varying number of records depending on the query, but in
general it will have a couple of hundred records (with about 30 showing at
one time). What I need to be able to do, as an example, is to page down so
that records 60-90 are showing and refresh any new data that is coming in
without moving grid. I can do this programmatically, but was wondering if
anyone knew away around this. It worked perfectly with the msAccess engine.

BTW the options I have on the ODBC are 18475

MySql 4.0.2 Connector
I need a recommendation for the most stable/tested version of Connector for MySQL V4.0.2. My web host is running V4.0.2 and I'm having problems with connections. I am currently running V1.0.7 of connector. Is that the best version? I apparently have problems with connection pooling not working quite right, so that intermittently I have problem getting a connection because the pool is exhausted.

How To Use Java Connector?
I downloaded MySQL Connector/J. How do you connect this to a MYSQL database server
on another machine? I want to use some Java code to connect to this from the client machine?

Mysql-connector
what is the difference between "mysql-connector-java-3.1.9-bin-g.jar" and "mysql-connector-java-3.1.9-bin.jar"?

Connector MyODBC
Can I using MyODBC to connect to MySQL Server through A Proxy Server ?

Install Connector
I must connect with .NET to a MySQL-DB. But the MySQL-DB is not on my local developer PC but on a server in our Windowsnetwork. Where must I install the ODBC or .NET connector, on the local developer PC or on the DB-server ?

ODBC Connector
I just installed the last version of the MySQL ODBC driver, version 03.51.08
A bug in the previous version (Default values not returned by the function SQLGetColumns()
was corrected and works properly now.
However, the following problem still exists:

A call to the function SQGetInfo() with SQL_ALTER_TABLE does not return the bitmask
SQL_AT_ADD_COLUMN_DEFAULT set, although MySQL does allow default values in ADD COLUMN.
The equivalent bitmask for a call with SQL_CREATE_TABLE does return the bit set correctly.

Connector/J 2.0.14 And MySQL 4.1.15,
I wish to connect the database with this old version of the Connector.
I need it because I use JDK 1.1.8, and the newest Connector requires a newer JDK.
This is all I get.
java.sql.SQLException: Cannot connect to MySQL server on ourserver:correctport. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)
With the lastest 3.0.x Connector/J and JDK 1.5 I can communicate with the database without problems.

MySql Connector NET
When I try to create and Fill DataAdapter in VisualStudio with MySqlCommand (which is a stored procedure with SELECT statement) I got an error about invalid key constraint.
Can anyone send me example how to execute stored procedure (only got SELECT statement) in VisualStudio and fill DataAdapter?

MySql Connector/NET Pooling
I am trying to configure my asp.net application to work with MySQL
using Connector/NET and I wish to use connection pooling. What is the
best way to do this?

This is what I have so far:

MySqlConnection myConnection;
MySqlDataAdapter myDataAdapter;
DataSet myDataSet;

String strSql;

myConnection = new MySqlConnection("server=localhost; user id =
testuser; password=abc123; database=test;pooling=false;");

strSql = "Select * From Users;";

myDataAdapter = new MySqlDataAdapter(strSql, myConnection);

myDataSet = new DataSet();

myDataAdapter.Fill(myDataSet, "mytable");

DataGrid1.DataSource = myDataSet;
DataGrid1.DataBind();

Now, I was thinking about putting the connection string in the
web.config file with pooling=true, but I a not sure what that would do.
I checked the documentation for Connection/NET and it doesn't give any
information on the pooling parameter. What happens if I set it to true?
Where do I specify the size of the pool? Do I need to make any changes
on IIS or MySQL itself?

Problem With ODBC Connector
I just installed the last version of the MySQL ODBC driver, version 03.51.08
A bug in the previous version (Default values not returned by the function SQLGetColumns() was corrected and works properly now.

However, the following problem still exists:

MySql Obdc Connector
I'm newbie using mysql with visual basic .net

I'm trying to connect to the mysql and I've got the message "Unable to get the catalog"

I have installed the obdc driver as shown in the mysql web, I have the OBDC.NET driver from microsoft too...
I have created the obdc source...

mysql is running and I can connect it by php, and admin tools

MySQL And VB .Net 2003 - Connector
I need to connect to a client's SQL server to create a custom GIU.

While browsing through the connector downloads pages, I found the following connectors:

MySQL Connector/ODBC 3.51

Download Connector/Net 5.1

Can you please let me which connector to use which VB .Net 2003?

MySQL Connector / J 3.1.0 Alpha
I thought this is the most popular jdbc driver for mySql.

I have been using this for my project in Win2000 environment. But today I tested my application in winXP, and I was shocked. Somehow it just failed when retrieving a resultset from mySQL and the field names are all corrupted.

This does not happen in win2k environment. Is this a bug?

Anyway, what is the alternative driver or is there any recommendation?

Files Missing From 3.1.11 Connector/j
I have downloaded version 3.1.11 of connector/j and it is missing all of the .class files, specifically the Driver.class file. The Driver.java file is there. I have tried downloads from several mirrors to no avail. The other versions have all of the files. What gives with this one?

Web Developer Express And .Net Connector
I've managed to get the .net connector working in VS Web Developer Express
so that I can use the mySQL 5.0.22 database as a Membership provider. So I
can now (if I wanted to) use the web admin tool to do all my user admin, and
also use the login controls easily.

However, I cannot get the 'test' function to work on the Providers tab of
the Web Admin Tool. Has anyone got this working? - I'm just wondering
whether I've done something wrong or whether its just something we have to
live with for now.

Connector/J Not Working With MySQL5.0?
MySQL 5.0 alpha (binary install) on
Solaris 9 -or- RedHat 8.0

mysql-connector-java-3.0.8-stable
-----------------------

Should I expect to be able to connect to MySQL5.0 alpha with JDBC?
When trying to connect I am getting:

** BEGIN NESTED EXCEPTION **

java.io.IOException
MESSAGE: Unexpected end of input stream

The client machine trying to connect to the server *CAN* connect via
the mysql command line client (ie. is has permission to the servers).
I have tried connecting to MySQL version 5.0 installs on both Linux
and Solaris with the same result. If I point the driver back to a 3.23.57
install, it works fine as always. Code:

Myodbc 3.51 Connector Freezes
I just installed mysql server 5.0 and myodb driver 3.51. Now I'm trying to make a DSN on my system. When I enter the Data Source Name, Server, User and Password, then when I click the Database drop-down menu, the program freezes. It does not do anything, just sits there. I set up the database properly, and it is configured and ready to go but I cannot get past this.

MySQL Connector/j Version
I need to have a version of the connector/j which supports callableStatement, as to return a resultset from a stored procedure.

I am using a JDBC and java programming to connect to mysql which uses sqlyog interface.

My current version of connector/j gives me an error saying callablestatements not supported. Which is the best one to use?

Another quick question what is the difference between source and binaries (tar.gz and zip), maybe a stupid question.

I have noticed there is connector/j 5.0.3 and connector/j 3.1.13. I am not sure which 1 i have currently. Is there a way to verify which one I have.

Character Encoding Connector/J
I have 2 servers....

the first is an NT server running MySQL 3.x with connector/j. This server works fine and all "international" characters are showing up correctly.

The 2nd server is a linux server running mySQL max 4.x and all "international" characters are showing up as question marks, etc. I tried setting the URL in the jdbc connection string to useUnicode=true and set the default character set to utf8 but this didn't fix the problem. Any suggestions?

Reasons To Update To Connector/J 5.1.5
My question comes from our tech lead who wants to know:

Why upgrade to Connector/J 5.1.5 instead of staying with 5.0.5?

Our database is now defined in unicode - in case that may one reason for the upgrade.

Jdbc Over SSL, SAP Business Connector 4.6
I have set up a connection between SAP Business Connector 4.6 and MYSQL. I'm currently using jdbc driver com.mysql.jdbc.Driver (mysql-connector-java-3.0.16-ga-bin.jar).

Using DB URL jdbc:mysql://<ip>/<database> the connection is working fine.

So far so good.

Now my problem:
I need to set up a SSL connection but in MySQL Connector/J Documentation is stated:
'For SSL Support to work, you must have the following:

A JDK that includes JSSE (Java Secure Sockets Extension), like JDK-1.4.1 or newer. SSL does not currently work with a JDK that you can add JSSE to, like JDK-1.2.x or JDK-1.3.x due to the following JSSE bug:

http://developer.java.sun.com/developer/bugParade/bugs/4273544.html'

My SAP business connector is running under jdk 1.3.0

How do I get SSL running?

MySQL Connector/J License.
I have a question about the license for MySQL Connector/J. If I write an aplication that uses MySQL Connector/J, can I sell it? Can I distribute the MySQL Connector/J jar file with my aplication?

.net Connector And Visual Web Dev Express
Has anyone tried to use the .net mysql provider in the visual web developer express tools ?.
I've downloaded 5.1 of the provider but can't get VWD to see it. I'm wondering if VWD is restricting what I can see.

According to the documentation it does work but all the examples are shown using the full Visual Studio.

Php/mysql Connector For Solaris
I recently installed mysql 5 standard package for solaris on a solaris 9 machine. I also have an apache2/php5 installed and operating on a solaris 9 machine. I'm trying to connect to mysql server via php. I already granted the apache2/php5 server permission to access the database, but I'm still getting denied (Could not connect: Host 'apache2php5_server' is not allowed to connect to this MySQL server). Do I need to install some module in order to accomplish my task? Is there a php/mysql connector I need to install? If so, is there a solaris version?

MS Access And MySQL Connector
I have just installed MySQL on a test box and are testing it by moving our old Access database to MySQL, but keeping the forms and reports front end in Access for now until we migrate them to ColdFusion.

The problem is whenever we try to link across the network to the MySQL tables from within Access 2002, it crashes. I have tried to connect by creating a User database, and it connects when I test it, it sees the databases during setup, etc. But once the link starts from within Access, Access crashes.

I have tried making a System database, and again it connects and tests fine, can connect through the data query in Excel 2002 and see all the tables, but crashes in Access when I try to link.

I have updated the MDAC to version 2.8, I have applied the JetEngine 4.0 Pack 8, I have tried the version two of the MySQL connector 3.51.12-2, I have checked all the permissions and the test user we created has full access to the database and tables.
We are operating MS Access 2002 SP3, on Windows 2000 SP4 all fully patched.
This is happening on multiple PC's and hampering my selling this database as the way to go.

Cannot Connect MySql 5.0 By Connector/NET 1.0
I try to connect mysql by this code:

string connStr = "database=mtg;server=wdev057;user id=root;Password=; pooling=false"
MySqlConnection c = new MySqlConnection( connStr );
c.Open();

but Error
"An unhandled exception of type 'System.AgumentException' occurred in mysql.data.dll
Additional information: Item has already been added. Key in dictionary:"read_only" Key being added:"read_only" "

please tell me howto slove my problem.

MySQL Caching And .NET Connector
" It was issued as a prepared statement, even if no placeholders were employed. For example, the query used here is not cached:"

Would parameterized queries made through the .NET Connector be available to be cached? My guess is no but would like clarification.

Mysql Connector Java JAR
I am making a Java Applet connects to mysql database, it works well in
application mode. When I run it in applet mode, obviously the client
running the applet should have the mysql connector file
(mysql-connector-java-3.0.8-stable-bin.jar).

So the question is how to bundle this mysql jar file with my applet jar
file. I've tried to make both 2 files together in the html file:

archive="PCMApplet.jar;mysql-connector-java-3.0.8-stable-bin.jar"

the GUI shows up but the connection call to database is failed:
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
It seems to me that the mysql-blah.jar is not being used.

Mysql-connector-java-3.1.13-bin
I've MYSQL 5 installed and I want to connect to MYSQL using BIE JBOSS . I had put the jar file mysql-connector-java-3.1.13-bin.jar in the deploy/jboss/bie.sar folder and in windows environment I was able to connect to the MYSQL DB. But when I try doing the same in LINUX environment , I get the following error ,

Could not create connection; - nested throwable: (java.sql.SQLException: Cannot connect to MySQL server on <IP>:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.NoRouteToHostException)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Cannot connect to MySQL server on <IP>:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.NoRouteToHostException)))

Connector.net/VS Tools Install
Just installed Connector.Net and tried to make the changes to the machine.config as per the instructons for installing Visual Studio Plugin. Unfortunately, my machine.config file does not contain any refrences to MySql so obviosuly I cannot change them. Install of connector went smoothly and I am a admin on this pc.

Handheld And Mysql Connector/j Driver
can i use mysql connector /j driver in hanheld devices for connecting my handheld database through java application to the mySQl server database which is residing on desktop. Code:

How To Ship Mysql Connector Java JAR
I am making a Java Applet connects to mysql database, it works well in
application mode. When I run it in applet mode, obviously the client
running the applet should have the mysql connector file
(mysql-connector-java-3.0.8-stable-bin.jar).

So the question is how to bundle this mysql jar file with my applet jar
file. I've tried to make both 2 files together in the html file:

archive="PCMApplet.jar;mysql-connector-java-3.0.8-stable-bin.jar"

the GUI shows up but the connection call to database is failed:
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

It seems to me that the mysql-blah.jar is not being used.

Character Encoding Problem/Connector/J
I have 2 servers....

the first is an NT server running MySQL 3.x with connector/j. This server
works fine and all "international" characters are showing up correctly.

The 2nd server is a linux server running mySQL max 4.x and all
"international" characters are showing up as question marks, etc. I tried
setting the URL in the jdbc connection string to useUnicode=true and set the
default character set to utf8 but this didn't fix the problem.

Install Error MySQL Connector
I tried to install the ADO connector on Win XP and recieved the following error:

InstallUtilLib.dll: Unknown error in CorBindToRunTimeHost (0x80131700).

Another user reported this error and said it was resolved but did not say how it was resolved.

Ship Mysql Connector Java JAR
I am making a Java Applet connects to mysql database, it works well in
application mode. When I run it in applet mode, obviously the client
running the applet should have the mysql connector file
(mysql-connector-java-3.0.8-stable-bin.jar).

So the question is how to bundle this mysql jar file with my applet jar
file. I've tried to make both 2 files together in the html file:

archive="PCMApplet.jar;mysql-connector-java-3.0.8-stable-bin.jar"

the GUI shows up but the connection call to database is failed:
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

It seems to me that the mysql-blah.jar is not being used.

Password Required To Unzip Connector/J
I just installed MySQL on WinXP and immediately tried installing Connector/J. While the downloaded file is unzipping, the process stops and says File Callable Statement Regressio... is password protected. Please enter password in the box below. What passowrd do they want? Its not the password I just gave while installing MySQL. That one doesn't work.

Can't Connect To Mysql Server With J Connector.
I can't connect to mysql server using the mysql-connector-java-3.0.11.
I was able to run the same program when I was running Suse 9.0 but
since I install Suse 9.1, I can't connect.
The error message is:
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection refused

I'm using mysql-standard-4.0.14 and able to get in the mysql server by
typing:
bin/mysql -uroot -ptest
The /etc/my.cnf file is the default one from
support-files/my-medium.cnf
The #skip-networking is comment out.
Try to telnet localhost 3306 and it display the following text:
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
4
4.0.14-standard-log|0x-qw$E,Connection closed by foreign host.

Connector/ODBC Not Saving Port Setting
Using MySQL Connector/ODBC 3.51, I set the port to a non-default value
(3309), under 'Connection Options' to connect to a remote machine running 2
versions of MySQL. 'Test' is successful but when I close the Connector/ODBC
window on XP the port setting is not saved so the DSN doesn't work.