aspose file tools*
The moose likes JDBC and the fly likes JDBC MySQL Driver Connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC MySQL Driver Connection" Watch "JDBC MySQL Driver Connection" New topic
Author

JDBC MySQL Driver Connection

Michael Poke
Greenhorn

Joined: Jul 19, 2005
Posts: 4
I designed a user interface using java and at this point I am trying to connect it to a mySQL database on my computer just for development purposes. After that is complete I will be putting the database on a server and running it from there.

In the meantime I can't seem to find the right url to put into the Class.forName() call so my database is not actually connecting (keeps throwing the ClassNotFoundException). I commented out a few of the other urls I tried to use....all your help would be greatly appreciated...the connection class code is below:

(For reference I installed the mysql-connector-java-3.1.10 version)

import java.sql.*;


public class Connect {
public static void main(String argv[]) {
Connection con = null;


Connection connection = null;
try {
//Load the JDBC driver
//String driverName = "mysql-connector-java-3.1.10//src//com//mysql//jdbc//Driver"; //MySQL MM JDBC driver
//mm.mysql.jdbc.Driver

String driverName = "com.mysql.jdbc.Driver";
Class.forName(driverName).newInstance();

//Create a connection to the database
String serverName = "localhost";
String mydatabase = "prop";
String url = "jdbc:mysql:" + serverName + "/" + mydatabase; //a JDBC url
String username = "username";
String password = "password";
connection = DriverManager.getConnection(url, username, password);

} catch (SQLException e) {
//Could not connect to the database
System.out.println("Connection Not Found");
}
catch (ClassNotFoundException e) {
System.out.println("Driver Not Found");
//Could not find the database driver}}
}
catch (Exception ex){
System.out.println("ex");
}
System.out.println("Connection:" + connection);
}
}
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60050
    
  65

n the meantime I can't seem to find the right url to put into the Class.forName()


You don't put a URL into the Class.forName(); you give it the class name of the driver -- which I see you have done in your code.

if it's giving you a ClassNotFoundException, that means that the dirver class is not part of the classpath.

Have you placed the mysql jar file in the classpath?
[ July 19, 2005: Message edited by: Bear Bibeault ]

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Michael Poke
Greenhorn

Joined: Jul 19, 2005
Posts: 4
"Have you placed the mysql jar file in the classpath?"

how would I go about doing that?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29233
    
138

Originally posted by Michael Poke:
"Have you placed the mysql jar file in the classpath?"

how would I go about doing that?

Michael,
Welcome to JavaRanch!

You could use java -cp "myClasspath" MyClass to run at the command line. If you expect to use mysql a lot (as is likely), you could add it to the operating system environment variable.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Michael Poke
Greenhorn

Joined: Jul 19, 2005
Posts: 4
What I did was right click on my computer, properties, advanced tab, environment variables and then added the jar file there.

I am still not getting a connection...I do not understand what is going wrong.

Help Please!?!?!?!
Julio C Moreno
Greenhorn

Joined: Apr 22, 2005
Posts: 16
you could try the next line :
javac -classpath . LoadDriver.java (example, replace the name with yours)
and then.
java -classpath "mysql-connector-java-3.1.10-bin.jar;" LoadDriver

i hope this could help u.
Michael Poke
Greenhorn

Joined: Jul 19, 2005
Posts: 4
still not working

anymore ideas?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
A word of advice: Just saying "it doesn't work" will get you nowhere. You need to specify precisely what you're doing, what the error messages are, what your classpath is etc. Only then can one make educated guesses what the problem might be.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC MySQL Driver Connection
 
Similar Threads
websphere studio and mysql
problem in connecting to oracle through jdbc
Sockets
db access through applet
SQLServerException - could not connect to the host on port 1433