Re: Problem trying to connect to SQL using MS JDBC

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

Date: 25 Aug 2004 08:27:07 -0700

Joe Weinstein <joeNOSPAM@bea.com> wrote in message news:<#L7PmthiEHA.2908@TK2MSFTNGP10.phx.gbl>...
> ?fooguy? wrote:
>
> > This looks like a classpath problem, but I don't think it is:
>
> It is. Your classpath has to have msbase.jar, mssqlserver.jar and msutil.jar listed.
> Get those three jar files in your current directory, and do this:
>
> set CLASSPATH=%CLASSPATH%;.\msbase.jar;.\mssqlserver.jar;.\msutil.jar;.
>
> then
>
> java SQLTest

C:\temp>echo %CLASSPATH%
d:\jdk142\lib;d:\jdk142\jre\lib;d:\jdk142\lib\msbase.jar;d:\jdk142\lib\msutil.jar;d:\jdk142\lib\mssqlserver.jar;c:\temp

C:\temp>java sqlTest.class
Exception in thread "main" java.lang.NoClassDefFoundError:
sqlTest/class

C:\temp>java 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)

> Joe Weinstein at BEA
>
> >
> > <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?

Relevant Pages

  • RE: error establishing socket error
    ... For some common causes of this exception and troubleshooting, ... I would also recommend testing with Query Analyzer from the machine that ... whether this problem is specific to the JDBC driver or if you just cannot ... | public SqlTest() throws Exception ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Gutes Exception Handling
    ... Exception wirft, wird die close-Methode von SQLTest verlassen und die ... Resourcen für stmt und conn werden nicht geschlossen. ...
    (de.comp.lang.java)
  • Re: Gutes Exception Handling
    ... Exception wirft, wird die close-Methode von SQLTest verlassen und die ... Resourcen für stmt und conn werden nicht geschlossen. ...
    (de.comp.lang.java)
  • error establishing socket error
    ... public SqlTest() throws Exception ... public static void main throws Exception ... 2000 Driver for JDBC]Error establishing socket. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • NEWBIE: Exception: java.lang.NoClassDefFoundError: DisplayApp/java/
    ... I wrote my sample program using Eclipse. ... have all the jar files as displayed on the eclipse editor. ... Exception in thread "main" java.lang.NoClassDefFoundError: ... I used both upper and lower cases for the %CLASSPATH% to see whether ...
    (comp.lang.java.help)
Loading