applet does not connects to database in browser

[innspiron]

Hello programmers,

could someone point me where to start for this problem:

created applet using NetBeans. Part of the applet is to connect to database. When I run it on NetBeans - works fine, but when open .html file (auto created by NetBeans in build folder) connection does not happen. Everything works but does not connect. I am working at the moment on localhost.

Code in html:
<APPLET codebase="classes" code="nwt/name_applet.class" width=650 height=700></APPLET>

Where do start to look for problem? Please help.

Thank you.

[doWhile]

View the console output. I know firefox has an option to view the java console and view println's or any exceptions being thrown (My guess is that a SecurityException is being thrown, in which case you need to sign your applet)

[innspiron]

thanks doWhile.

I did what you said, console gave me an error
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

How do I fix this? Why loading from NetBeans everyhing works fine?
please advise.

[innspiron]

+ displayed error:

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/....

[doWhile]

You need to add the driver to your classpath. There are probably hundreds of posts here that describe how to do this so rather than reproduce all that info I recommend you do a search of the forums. For example, here is a recent post that discusses this: Problem loading JDBC SQL driver.
This situation may be a bit different because it is an applet, you need to add the jar to the appropriate server location and add it to the archive tag of the applet

[innspiron]

thanks man.