CodingForums.com

CodingForums.com (http://www.codingforums.com/index.php)
-   Java and JSP (http://www.codingforums.com/forumdisplay.php?f=54)
-   -   exception in Java (http://www.codingforums.com/showthread.php?t=38446)

Aymen++ 05-12-2004 08:12 AM

exception in Java
 
i have this code:
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 08: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


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.