NoClassDefFoundError - please help

[NamelessNumberheadMan]

I'm using MyEclipse to make a quick one or two use jar utility file to connect to a database and run some updates. I can get everything to compile fine, and create the jar without an issue, but when I execute it from the command prompt I get a NoClassDefFoundError.

Here is the stack trace:

Exception in thread "main" java.lang.NoClassDefFoundError: com/microsoft/jdbc/sq
lserver/SQLServerDriver
at com.dbinterface.DatabaseAccess.execute(DatabaseAcc ess.java:108)
at com.dbinterface.DatabaseAccess.loadSqlfiles(Databa seAccess.java:81)
at com.dbinterface.DatabaseAccess.getFileList(Databas eAccess.java:39)
at com.dbinterface.RunSqlScripts.main(RunSqlScripts.j ava:24)

This is the method where the error is thrown -

public void execute(StringBuffer sb)
    {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
 
        try{
            DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
            conn = DriverManager.getConnection(Constants.DATABASE_NAME, Constants.USERNAME, Constants.PASSWORD);
            stmt = conn.createStatement();            
 
            stmt.execute(sb.toString());
 
            rs.close();
            stmt.close();
            conn.close();            
 
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }        
        finally
        {
            try{
                if(null != rs)
                    rs.close();
                if(null != stmt)
                    stmt.close();
                if(null != conn)
                    conn.close();
            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
        }
    }

All the forums I find ask about the classpaths so here is my .classpath file created by MyEclipse:

[HTML]<?xml version="1.0" encoding="UTF-8"?>
<classpath>
<classpathentry kind="src" path="src"/>
<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/sqljdbc.jar"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/msbase.jar"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/mssqlserver.jar"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/msutil.jar"/>
<classpathentry kind="output" path="bin"/>
</classpath>[/HTML]

My jar file is located in C:/temp/dbInterface.

This is what my MANIFEST.MF file contains:

Manifest-Version: 1.0
Main-Class: com.dbinterface.RunSqlScripts

Please help. As far as I see my classpaths are correct. I'm not sure what to try from here.

------------UPDATE------------

I just attempted adding the classpaths to my manifest so it would now look like:

Manifest-Version: 1.0
Class-Path: .;C:\temp\dbInterface\msbase.jar;C:\temp\dbInterfa ce\mssqlserver.jar;C:\temp\dbInterface\msutil.jar; C:\temp\dbInterface\sqljdbc.jar
Main-Class: com.dbinterface.RunSqlScripts


Still didn't work. I quite desperate at this point.

[JosAH]

I'm using MyEclipse to make a quick one or two use jar utility file to connect to a database and run some updates. I can get everything to compile fine, and create the jar without an issue, but when I execute it from the command prompt I get a NoClassDefFoundError.

Here is the stack trace:

Exception in thread "main" java.lang.NoClassDefFoundError: com/microsoft/jdbc/sq
lserver/SQLServerDriver
at com.dbinterface.DatabaseAccess.execute(DatabaseAcc ess.java:108)
at com.dbinterface.DatabaseAccess.loadSqlfiles(Databa seAccess.java:81)
at com.dbinterface.DatabaseAccess.getFileList(Databas eAccess.java:39)
at com.dbinterface.RunSqlScripts.main(RunSqlScripts.j ava:24)

This is the method where the error is thrown -

public void execute(StringBuffer sb)
    {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
 
        try{
            DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
            conn = DriverManager.getConnection(Constants.DATABASE_NAME, Constants.USERNAME, Constants.PASSWORD);
            stmt = conn.createStatement();            
 
            stmt.execute(sb.toString());
 
            rs.close();
            stmt.close();
            conn.close();            
 
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }        
        finally
        {
            try{
                if(null != rs)
                    rs.close();
                if(null != stmt)
                    stmt.close();
                if(null != conn)
                    conn.close();
            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
        }
    }

All the forums I find ask about the classpaths so here is my .classpath file created by MyEclipse:

[HTML]<?xml version="1.0" encoding="UTF-8"?>
<classpath>
<classpathentry kind="src" path="src"/>
<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/sqljdbc.jar"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/msbase.jar"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/mssqlserver.jar"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/msutil.jar"/>
<classpathentry kind="output" path="bin"/>
</classpath>[/HTML]

My jar file is located in C:/temp/dbInterface.

This is what my MANIFEST.MF file contains:

Manifest-Version: 1.0
Main-Class: com.dbinterface.RunSqlScripts

Please help. As far as I see my classpaths are correct. I'm not sure what to try from here.

------------UPDATE------------

I just attempted adding the classpaths to my manifest so it would now look like:

Manifest-Version: 1.0
Class-Path: .;C:\temp\dbInterface\msbase.jar;C:\temp\dbInterfa ce\mssqlserver.jar;C:\temp\dbInterface\msutil.jar; C:\temp\dbInterface\sqljdbc.jar
Main-Class: com.dbinterface.RunSqlScripts


Still didn't work. I quite desperate at this point.

In which .jar file is the class com.microsoft.jdbc.sqlserver.SQLServerDriver stored?
That's the class that can not be found so it definitely is missing in your classpath.

Tip: you can use winzip to inspect your jars.

kind regards,

Jos

[NamelessNumberheadMan]

In which .jar file is the class com.microsoft.jdbc.sqlserver.SQLServerDriver stored?
That's the class that can not be found so it definitely is missing in your classpath.

Tip: you can use winzip to inspect your jars.

kind regards,

Jos

I did notice one mistake. I was hitting the mssqlserver.jar which is for SQLServer2000. I want to hit sqljdbc.jar which if for SQLServer 2005. So I change my registerDriver to:

DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());

I also eliminated the other jars since I ruled those out.

so my .classpath file now contains:

[HTML]<?xml version="1.0" encoding="UTF-8"?>
<classpath>
<classpathentry kind="src" path="src"/>
<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
<classpathentry exported="true" kind="lib" path="C:/temp/dbInterface/sqljdbc.jar"/>
<classpathentry kind="output" path="bin"/>
</classpath>[/HTML]

and my MANIFEST.MF contains:

Manifest-Version: 1.0
Class-Path: .;C:\temp\dbInterface\sqljdbc.jar
Main-Class: com.dbinterface.RunSqlScripts

I'm still getting this error (and yes SQLServerDriver is in the sqljdbc.jar file). Where can I define my classpath? The command line I guess?
-classpath .
-or-
-classpath C:\temp\dbInterface\sqljdbc.jar

These also don't seem to be working. I'm sure it has to be something small that I'm missing. Any ideas?

[JosAH]

Where can I define my classpath? The command line I guess?
-classpath .
-or-
-classpath C:\temp\dbInterface\sqljdbc.jar

These also don't seem to be working. I'm sure it has to be something small that I'm missing. Any ideas?

You could define your classpath like that but what is the purpose of that xml file
then? It seems as if it defines your classpath in some way but evidently that
xml file isn't processed or even seen.

Try to run your class from the command line and pass the correct classpath
value as you indicated yourself and see what happens.

kind regards,

Jos