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.
<em><strong><strong><strong>código</strong></strong></strong></em>***************
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