java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Hi eee:
I get the below error:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
        at java.net.URLClassLoader.findClass(URLClassLoader.java:241)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:516)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:460)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:448)
        at java.lang.Class.forName1(Native Method)
        at java.lang.Class.forName(Class.java:142)
        at ExportFromMSSQL.main(ExportFromMSSQL.java:15)

The steps I have taken to set up my env are as folliws:
1. Add the javac and the sqljdbc.jar to my environment as follows:
PATH=/home/asmith:/home/asmith/perl/:/usr/ucb:$HOME/bin:/usr/bin/X11:/
sbin:/usr/java131/jre/bin:/usr/java131/bin:/myhome/asmith/JDBC/sqljdbc_2.0/enu/sqljdbc.jar:.

Where things reside:
1. My javac resides in usr/java131/bin
2. Downloaded and installed the MS driver (http://www.microsoft.com/downloads/details.aspx?FamilyId=F914793A-6FB4-475F-9537-B8FCB776BEFD&displaylang=en) into JDBC subdir. Now the dir structure looks like below
/myhome/asmith/JDBC/sqljdbc_2.0/enu > ls -l
total 1720
drwxr-s---   5 asmith  mygrp           512 Dec 02 13:54 auth
drwxr-s---   5 asmith  mygrp           512 Dec 02 13:54 help
-rw-r-----   1 asmith   mygrp          1675 Jul 14 14:47 install.txt
-rw-r-----   1 asmith   mygrp        13986 Jul 14 14:47 license.txt
-rw-r-----   1 asmith   mygrp        11172 Jul 14 14:44 release.txt
-rw-r-----   1 asmith   mygrp        409322 Jul 18 11:29 sqljdbc.jar
-rw-r-----   1 asmith   mygrp        422699 Jul 21 11:50 sqljdbc4.jar
drwxr-s---   5 asmith   mygrp        512 Dec 02 13:54 xa

I run as
/myhome/asmith/JDBC/sqljdbc_2.0/enu/help/samples/connections > javac connectURL.java
/myhome/asmith/JDBC/sqljdbc_2.0/enu/help/samples/connections > java connectURL
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
        at java.net.URLClassLoader.findClass(URLClassLoader.java:241)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:516)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:460)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:448)
        at java.lang.Class.forName1(Native Method)
        at java.lang.Class.forName(Class.java:142)
        at connectURL.main(connectURL.java:43)


My code is the sample code provided in connectURL.java i.e below:

import java.sql.*;
 
public class connectURL {
 
        public static void main(String[] args) {
 
                // Create a variable for the connection string.
                String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
                        "databaseName=AdventureWorks;integratedSecurity=true;";
 
                // Declare the JDBC objects.
                Connection con = null;
                Statement stmt = null;
                ResultSet rs = null;
 
                try {
                        // Establish the connection.
                        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                        con = DriverManager.getConnection(connectionUrl);
 
                        // Create and execute an SQL statement that returns some data.
                        String SQL = "SELECT TOP 10 * FROM Person.Contact";
                        stmt = con.createStatement();
                        rs = stmt.executeQuery(SQL);
 
                        // Iterate through the data in the result set and display it.
                        while (rs.next()) {
                                System.out.println(rs.getString(4) + " " + rs.getString(6));
                        }
                }
 
                // Handle any errors that may have occurred.
                catch (Exception e) {
                        e.printStackTrace();
                }
 
                finally {
                        if (rs != null) try { rs.close(); } catch(Exception e) {}
                        if (stmt != null) try { stmt.close(); } catch(Exception e) {}
                        if (con != null) try { con.close(); } catch(Exception e) {}
                }
        }
}

Select allOpen in new window