Hi all, I'm writing my first java program on Ubuntu system.
I installed on Ubuntu system the libmysql-java package, I writed my program and then I compiled it, but I have the following message in running it:
Code:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at Primo.main(Primo.java:9)
My program is the following:
Code:
import java.sql.*;
class Primo {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("dbname", "root", "mypasswd");
Statement cmd = conn.createStatement();
String query = "SELECT * from mytable;";
ResultSet res = cmd.executeQuery(query);
while (res.next()) {
System.out.println(res.getString("Codice"));
}
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
Where is the problem?
Thanks in advance for answers.