trying to connect MSSql server 2000 through jdbc

[Anand Sivathanu]

I am trying to connect MSSql server 2000 through jdbc.I have put the jar files and it is complied successfully.but when i hit the servlet(using weblogic)

    
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class simpleServlet extends HttpServlet
{
	public void doGet(HttpServletRequest req,HttpServletResponse res)throws IOException
	{
		PrintWriter out = res.getWriter();
		try
		{
                        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			out.println("connection established");
		}
		catch (Exception e)
		{
			out.println("unable to load driver");
			out.println(e.toString());
		}

		try
		{

                        Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa","admin");
                        out.println("ready to access db");
                        
		}
		catch (Exception e)
		{
			out.println("unable to connection2");
			out.println(e.toString());
		}
                
	}
}

I can see the below error.

Error 500--Internal Server Error
java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseDriver
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:502)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:250)
at java.net.URLClassLoader.access$100(URLClassLoader.java:54)
at java.net.URLClassLoader$1.run(URLClassLoader.java:193)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:292)
at java.lang.ClassLoader.loadClass(ClassLoader.java:292)
at java.lang.ClassLoader.loadClass(ClassLoader.java:292)
at java.lang.ClassLoader.loadClass(ClassLoader.java:292)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:223)
at weblogic.utils.classloaders.ChangeAwareClassLoader.loadClass(ChangeAwareClassLoader.java:41)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at simpleServlet.doGet(simpleServlet.java:12)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6310)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)

can you help?....

[Scott Selikoff]

You need the Jar to both compile and run the code. Since you are able to compile, I suspect that part is fine. The Jar is probably not in the right place to execute on the server. You can put it in the WEB-INF/lib directory of the WAR or in the server's class path.

[Anand Sivathanu]

I have classpath.bat which is used to compile the java files.

I donot know about server classpath.

how can i set the classpath for a weblogic server 8.1?

can you help me?