Problem trying to connect to SQL using MS JDBC

From: ?fooguy? (johns_spam_address_at_yahoo.com)
Date: 08/24/04

  • Next message: Joe Weinstein: "Re: Problem trying to connect to SQL using MS JDBC" 
    Date: 24 Aug 2004 12:57:17 -0700

    This looks like a classpath problem, but I don't think it is:

    <code>
    package com.microsoft.jdbc.sqlserver;
    import com.microsoft.jdbc.sqlserver.*;
    import java.awt.*;
    import java.sql.*;
    import javax.sql.*;
    import javax.swing.*;

    public class sqlTest //extends JApplet implements ActionListener
    {
            public static void main (String args []) throws SQLException {
            {
                    try
                    {

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

                            // use your hostname and port number here
                            String url = "jdbc:microsoft:sqlserver://myServerName:1433/PROD";
                            String login = "foo"; // use your login here
                            String password = "bar"; // use your password here

                            //open a connection to the database
                            Connection connection = DriverManager.getConnection(url, login,
    password);

                            //to get the driver version
                            DatabaseMetaData conMD = connection.getMetaData();
                            System.out.println("Driver Name:\t" + conMD.getDriverName());
                            System.out.println("Driver Version:\t" + conMD.getDriverVersion());
                            /*
                            //create a statement
                            Statement st = connection.createStatement();

                            //execute a query
                            ResultSet rs = st.executeQuery("SELECT * FROM
    master.dbo.sysprocesses");

                            // read the data and put it to the console
                            while (rs.next())
                            {
                                    for (int j = 1; j <= rs.getMetaData().getColumnCount(); j++)
                                    {
                                            System.out.print(rs.getObject(j) + "\t");
                                    }

                                    System.out.println();
                            }

                            //close the objects
                            st.close();
                            connection.close();
                            */
                    }
                    catch (Exception e)
                    {
                            e.printStackTrace();
                    }
              }
    }
    }
    </code>

    C:\temp>javac -verbose sqlTest.java
    [parsing started sqlTest.java]
    [parsing completed 60ms]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/Object.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/String.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/sql/SQLException.class)]
    [checking com.microsoft.jdbc.sqlserver.sqlTest]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/Throwable.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/Exception.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/Class.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/sql/Connection.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/sql/DriverManager.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/util/Properties.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/sql/DatabaseMetaData.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/System.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/io/PrintStream.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/io/FilterOutputStream.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/io/OutputStream.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/Error.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/ClassNotFoundException.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/RuntimeException.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/InstantiationException.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/IllegalAccessException.class)]
    [loading d:\jdk142\jre\lib\rt.jar(java/lang/StringBuffer.class)]
    [wrote sqlTest.class]
    [total 501ms]

    C:\temp>

    C:\temp>echo %CLASSPATH%
    d:\jdk142\lib;d:\jdk142\jre\lib;d:\temp;.

    C:\temp>java -classpath . sqlTest
    Exception in thread "main" java.lang.NoClassDefFoundError: sqlTest
    (wrong name: com/microsoft/jdbc/sqlserver/sqlTest)
            at java.lang.ClassLoader.defineClass0(Native Method)
            at java.lang.ClassLoader.defineClass(Unknown Source)
            at java.security.SecureClassLoader.defineClass(Unknown Source)
            at java.net.URLClassLoader.defineClass(Unknown Source)
            at java.net.URLClassLoader.access$100(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.ClassLoader.loadClassInternal(Unknown Source)

    Any ideas?

  • Next message: Joe Weinstein: "Re: Problem trying to connect to SQL using MS JDBC"
    Loading