Problem in JDBC

[Preethi]

I'm getting this erro only after downloading JDBC Driver for sqlserver2005.
Can anyone say me how to remove it or how to solve the problem.(I have searched for it in add or remove
programs in control panel,but couldn't find...But i have included mssqlserver.jar,msutil.jar,msbase.jar in my classpath)

basic: Modality pushed
basic: Modality popped
basic: Registered modality listener
liveconnect: Invoking JS method: document
liveconnect: Invoking JS method: URL
basic: Referencing classloader: sun.plugin.ClassLoaderInfo@15efa6a, refcount=1
basic: Added progress listener: sun.plugin.util.GrayBoxPainter@14b389
basic: Loading applet ...
basic: Initializing applet ...
basic: Starting applet ...
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
	at sun.applet.AppletClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.applet.AppletClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at xmlTrail.XMLReading.fileParsing(XMLReading.java:86)
	at xmlTrail.MD2$Imagepanel.prepareData(MD2.java:517)
	at xmlTrail.MD2$Imagepanel.<init>(MD2.java:139)
	at xmlTrail.MD2.init(MD2.java:56)
	at sun.applet.AppletPanel.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\Documents and Settings\com\microsoft\sqlserver\jdbc\SQLServerDriver.class (The system cannot find the path specified)
	at java.io.FileInputStream.open(Native Method)
	at java.io.FileInputStream.<init>(Unknown Source)
	at java.io.FileInputStream.<init>(Unknown Source)
	at sun.net.www.protocol.file.FileURLConnection.connect(Unknown Source)
	at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown Source)
	at sun.applet.AppletClassLoader.getBytes(Unknown Source)
	at sun.applet.AppletClassLoader.access$100(Unknown Source)
	at sun.applet.AppletClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)

[Eku]

have added those jar file in the
..\Java\jdk1.6.0_05\jre\lib\ext\ Folder

[masijade]

have added those jar file in the
..\Java\jdk1.6.0_05\jre\lib\ext\ Folder

DON'T add it there. Never add anything to the jre lib directories. That ext folder is for language extensions (the meaning of ext) and a JDBC Driver is far from a language extension. Besides, what happens when you upgrade Java? What happens, when for one app you need a newer version of a Driver, and for an older app you need an older version?

Add the jarfile to your CLASSPATH (not your system classpath as the older/newer version problem still exists there, and most web containers and IDE's won't use that anyway), but rather, if you are using a jarfile, to the manifest, and if you are not using a jarfile, to the command line -cp option, or if you are using a web container/IDE configure it there.

[masijade]

Ach, and your problem is that you're using an applet. In that case you must provide the Driver classes yourself (unpacked form in the "codebase" directory, or in the jarfile if using a jarfile) or, make url (or RMI or someother remote protocol) to a self-written server that will interface with the db for you and just send you the results.

[Niveditha]

I think it ll be in "SQL-Installation path/Lib", correct me if ia m wrong.
Check this too
HOW TO: Get Started with Microsoft JDBC

[AnilKanike]

Hi,

You might have missed out some .jar files to be included. Try to add its corresponding jar files and then try out.

[masijade]

To both of the last posters. He is using an Applet. That means that the application itself will be running on a client machine that he may (and probably should) have no control over. That he means, whatever he writes will have access to core java, and core java, only, unless he provides it from the "codebase" he defines in the Applet tag.

@OP: Make sure the Driver is freely distributable, though, otherwise you will be violating license restrictions, and that could become very costly in terms of both money (fines) and time (prison).

[rajeshbehera]

for using sqlserver type 4 database you have to download 3 jar files.and keep it in lib folder before running your web application

[masijade]

It's not a web application. It's an applet, so he must provide all three of those jarfiles (in unpacked format, as already noted) as part of the "codebase".

[sofia]

I need some help with connecting to oracle database. I had a java application which has a servelt and a java class that does the connection to Oracle (thin) and another Java Bean class that process the result statement and the index.jsp that display the returned information. The application worked well but we noticed that the Oracle server crashed after like 80 requests, we noticed that the connection wasn't closing eventhough I have the Close method called to close the connection.
Can you please help me figure out what is the right way to connect to Oracle, my application is used by almost 700 people almost every day.
Let me know if you need me to post any code.

[masijade]

Start your own thread, don't hijack another.

[sofia]

this is my first time on this forum.