MySQL Java hell

[AFB]

I put the driver in the lib\ext\ folder, no luck - class not found when trying to get the class.
I try setting the class path to the jar - ditto
I try setting it to the folders - same.


This is begining to suck.

Code:
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Loaded driver");

It never prints that statement, always throws exception.

Thanks

 

[AFB]

Standalone app

 

[Kilrsat]

ok, I have the following files in one folder:

BeerTrackerServer.java
ClientHandler.java
mysql-connector-java-3.1.7-bin.jar

The client handler uses the MySQL JDBC driver using Class.forName("com.mysql.jdbc.Driver"), just like you're trying.

To compile it, I change to the folder and enter this command:
javac -classpath mysql-connector-java-3.1.7-bin.jar;. *.java

To run it:
java -classpath mysql-connector-java-3.1.7-bin.jar;. BeerTrackerServer

Done.

 

[AFB]

Originally posted by: Kilrsat
ok, I have the following files in one folder:

BeerTrackerServer.java
ClientHandler.java
mysql-connector-java-3.1.7-bin.jar

The client handler uses the MySQL JDBC driver using Class.forName("com.mysql.jdbc.Driver"), just like you're trying.

To compile it, I change to the folder and enter this command:
javac -classpath mysql-connector-java-3.1.7-bin.jar;. *.java

To run it:
java -classpath mysql-connector-java-3.1.7-bin.jar;. BeerTrackerServer

Done.

,but a pain in the ass.

THX :beer: