Conexão II

Já me falaram várias coisas... já tentei de tudo.... vou postar o código novamente e o trecho do arquivo profile.....

Peço ajuda obrigado.

*******código**********************
import java.sql.*;
import java.sql.Connection;

public class TestQuery {

public TestQuery () {
}

public static void main(String args[]) {

String url="jdbc:mysql://192.168.10.102/usuario";
Connection con;
String query = "SELECT * FROM usu";
Statement stmt;

try {
Class.forName("com.mysql.jdbc.Driver");
}
catch (java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}

try {
System.out.println("Trying to connect...");
con = DriverManager.getConnection (url, "root","redhat");
System.out.println("connected!");
stmt = con.createStatement();
ResultSet result = stmt.executeQuery(query);
while (result.next()) {
String name = result.getString(1) + " " + result.getString(2);
System.out.println(name);
}
stmt.close();
con.close();
}
catch(SQLException ex) {
System.err.print("SQLException: ");
System.err.println(ex.getMessage());
}
}
}
************************************************************************************

Erro:

ClassNotFoundException: com.mysql.jdbc.Driver
SQLException: No suitable driver

************************************************************

Arquivo profile

pathmunge /usr/java/j2sdk1.4.2_04/bin
pathmunge /root/java/mysql/com/mysql/jdbc
fi

pathmunge /usr/X11R6/bin after

unset pathmunge

# No core files by default
ulimit -S -c 0 > /dev/null 2>&1

USER="`id -un`"
LOGNAME=$USER
MAIL="/var/spool/mail/$USER"

HOSTNAME=`/bin/hostname`
HISTSIZE=1000
JAVA_HOME="/usr/java/j2sdk1.4.2_04/bin"
CLASSPATH=".:$CLASSPATH:/root/java/mysql/com/mysql/jdbc"
MYSQL="/root/java/mysql/com/mysql/jdbc"

if [ -z "$INPUTRC" -a ! -f "$HOME/.inputrc" ]; then
INPUTRC=/etc/inputrc
fi

export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC JAVA_HOME CLASSPATH MYSQL

Obrigado

Tentou colocar o full path para o JDBC do MySQL?
tipo:

CLASSPTAH=.:$CLASSPATH:/home/dpedroso/libs/mysql-connector-java-3.0.12-production-bin.jar

ou será que estou falando besteira?

Notícias, artigos e o maior fórum brasileiro sobre Java