JDBC in Applets, problems

[Joe Wolf]

I've found code for DB Connectivity in Java Apps but I haven't found any Applet specific ones. Are there any special DB related additions I must include in applet code for it to work?
I ask this because I'm trying to connect to a mysql db from an applet and my applet will print only as far as "Attempting a connection..." and then will not print out any of the SQL table. My code looks like this:
import java.sql.*;
import java.applet.Applet;
import java.awt.*;
public class DBConnectApplet1 extends Applet {
public void paint(Graphics g) {
//try to load JDBC driver
g.drawString("Attempting to load driver...",0,0);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
g.drawString("Driver Found",100,0);
}
catch(ClassNotFoundException ee) {
ee.printStackTrace();
g.drawString("Driver Not Found",100,0);
}
//attempt to establish connection with database
String url = "jdbc:mysql://localhost/thedew";
String user = "guest";
String password = "";
Connection con = null;
// open connection
try {
g.drawString("Attempting a connection...",0,50);
con = DriverManager.getConnection(url, user, password);
g.drawString("Connection Established",100,50);
}
catch(SQLException e) {
e.printStackTrace();
g.drawString("Connection Failed",100,50);
}
//issue SQL statements...
Anyone have ideas about why this is so. I've read that replacing localhost with your ip address works but it didn't seem to make a difference with me. Thanks.

[Bharat Agarwal]

I too had the same problem. What I did was that i used the classes11.zip in the same directory as of the html file and also added the classes11.zip in the html page. The applet requires (as I got my code working) classes11.zip to be downloaded on the client side.

[Sean Casey]

I like to put a servlet in between the two. That works fine, as I let the applet talk to the servlet and the servlet does all the talking to MySQL.