0

below is my JDBC code for connecting to DB and call a stored porcedure. i have installed the sqljdbc4v in src folder onf my project and the class path is also set to my bin folder and src folder.

Connection con = null;
    CallableStatement proc_stmt = null;
    ResultSet rs = null;

    try {

        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

        con = DriverManager.getConnection("jdbc:sqlserver://MYSERVER;databaseName=MYDATABASE", "USERID", "PASSWORD");

        proc_stmt = con.prepareCall("{ call generateID(?) }");

        proc_stmt.setString(1, "employee");
        rs = proc_stmt.executeQuery();

        if (rs.next()) {
            int employeeId = rs.getInt(1);
            System.out.println("Generated employeeId: " + employeeId);
        } else {
            System.out.println("Stored procedure couldn't generate new Id");
        }
    } catch (ClassNotFoundException ex) {
        ex.printStackTrace();
    } catch (SQLException ex) {
        ex.printStackTrace();
    } finally {

        try {

            rs.close();
            proc_stmt.close();
            con.close();

        } catch (SQLException ex) {
            ex.printStackTrace();
        }

    }

i keep on getting the below error

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at StoredProcedure1.main(StoredProcedure1.java:18)
Exception in thread "main" java.lang.NullPointerException
    at StoredProcedure1.main(StoredProcedure1.java:41)

please help..

SatyaTNV
  • 4,137
  • 3
  • 15
  • 31
DeathMate
  • 17
  • 1
  • 4

0 Answers0