...

View Full Version : exception in Java



Aymen++
05-12-2004, 09:12 AM
i have this code:


package mysql;
import java.sql.*;

public class Hello {
Connection connection;

private void displaySQLErrors(SQLException e) {
System.out.println("SQLException: " + e.getMessage());
System.out.println("SQLState: " + e.getSQLState());
System.out.println("VendorError: " + e.getErrorCode());
}

public Hello() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(SQLException e) {
System.err.println("Unable to find and load driver");
System.exit(1);
}
}

public void connectToDB() {
try {
connection = DriverManager.getConnection("jdbc:mysql://localhost/accounts?user=&password=");
}
catch(SQLException e) {
displaySQLErrors(e);
}
}

public void executeSQL() {
try {
Statement statement = connection.createStatement();

ResultSet rs = statement.executeQuery("SELECT * FROM acc_acc");

while(rs.next()) {
System.out.println(rs.getString(1));
}

rs.close();
statement.close();
connection.close();
}
catch(SQLException e) {
displaySQLErrors(e);
}
}

public static void main(String[] args) {
Hello hello = new Hello();

hello.connectToDB();
hello.executeSQL();
}
}


i have 3 errors after compiling, the first:
C:\Program Files\Xinox Software\JCreator LE\MyProjects\Hello.java:15: unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrown
the second:
C:\Program Files\Xinox Software\JCreator LE\MyProjects\Hello.java:15: unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrown
the third:
C:\Program Files\Xinox Software\JCreator LE\MyProjects\Hello.java:17: exception java.sql.SQLException is never thrown in body of corresponding try statement
why? and how can i solve it?

shmoove
05-12-2004, 09:33 AM
Class.forName() doesn't throw an SQLException, but it might throw a ClassNotFoundException if the class doesn't exist in it's classpath. So instead of catching an SQLException you should be catching a ClassNotFoundException (or something above it in the hierarchy like Exception).

shmoove



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum