Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC_MySQL - Driver not possible to load

 
Jobst
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to connect MySQL with Java. To compile the Java- application is no problem. But to execute the application is not possible, I always get the message that the driver cannot be found.
I use a type 4 driver (for MySQL) from TcXDatakonsultAB. (From the installation instructions) I've used Class.forName("twz1.jdbc.mysql.jdbcMysqlDriver");
and the URL jdbc:z1MySQL: . I also tried several different possibilities of writing the CLASSPATH.
I've read a lot of tutorials and installation instructions but cannot find the solution, why the application cannot find the driver .....
Is there anyone who can help me ?
Many Thanks,

Jobst
 
Jobst
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HELLLO !
I think it's the best that I send the application I use.
It's an application from Sun's Java-Tutorial for trying
out and to learn. Compiling is no problem, only to execute
the application is not possible, I always
get the message that the driver cannot be found.
The 'jar.'-DriverFile is located in my Java-directory under
jre/lib/ext.
Well, I think this is really hard stuff !!!
I talked with some people about this problem, but until now
nobody could help me ...
Any help or ideas you have is welcome !
I thank you !
Greetings, Jobst ;-)
import java.sql.*;

public class CreateCoffees {
public static void main(String args[]) {

String url = "jdbc:z1MySQL:myDataSource";
Connection con;
String createString;
createString = "create table COFFEES " +
"(COF_NAME varchar(32), " +
"SUP_ID int, " +
"PRICE float, " +
"SALES int, " +
"TOTAL int)";
Statement stmt;

try {
Class.forName("twz1.mysql.jdbcMysqlDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con = DriverManager.getConnection
(url, "myLogin", "myPassword");

stmt = con.createStatement();
stmt.executeUpdate(createString);

stmt.close();
con.close();

} catch(SQLException ex) {
System.err.println
("SQLException: " + ex.getMessage());
}
}
}
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the "twz1.jdbc.mysql.jdbcMysqlDriver" driver? I'm not familiar with it. The most common driver used with MySQL is the mm.mysql driver available from http://www.worldserver.com/mm.mysql/
One thing to check is that you are unpacking the drivers correctly. For example, I think the mm.mysql drivers are supplied as a jar, but you have to unjar the initial level (which also contains the source and sample code) to get to the real jar that you put on your classpath.
Another thing I'd check is that you can get to the drivers via 'javap'. ie if your program can get the drivers you should also be able to get to them with 'javap twz1.jdbc.mysql.jdbcMysqlDriver'
If you are trying to run it in an application server, everything may be different and none of the above will be helpful...
You may find you have a better chance of response if you have a name that conforms to the JavaRanch naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
 
Tejeshwara Murthy K.G
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I don't know whether u r trying to connect in Windows or Linux. Presently i am working on Linux platform. The below code i have used for connecting to mysql Database.
why don't try like this...

Source code for just to make a connection.
Connection con = null;
try
{
Class.forName (driver name);//I am using "org.gjt.mm.mysql.Driver"
con = DriverManager.getConnection("jdbc:mysql://localhost/DBName"); I am giving "jdbc:mysql://localhost/SmartNet?user=root" my database name is SmartNet.
System.out.println("connected to DBName");
}
catch (SQLException e)
{
System.out.println("error "+e);
}
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic