File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC in Applets, problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC in Applets, problems" Watch "JDBC in Applets, problems" New topic
Author

JDBC in Applets, problems

Joe Wolf
Ranch Hand

Joined: Jul 05, 2001
Posts: 42
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
Greenhorn

Joined: Jun 16, 2001
Posts: 21
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
Ranch Hand

Joined: Dec 16, 2000
Posts: 625
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC in Applets, problems