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
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: 61654
    
  67

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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30938
    
158

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: 42623
    
  65
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 - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC MySQL Driver Connection