Applet to MySQL DB connection Success!!!!

Gregg Bolinger

Ranch Hand

Posts: 15304

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ok, I have been trying to get this to work for about a week now and I finally did it!! So, for all those struggling with it, here is a complete instruction set on what I did.
System Specs
Server - Windows 2000 Advanced Server running as Web Server
Database - MySQL Max 4.0
MySQL Driver - mm.mysql.jdbc-1.2c
JDK 1.3.1_02
Java Editor - JCreator Pro 2.0
CLASSPATH INSTRUCTIONS
I had to set the CLASSPATH inside my editor and point it to the MySQL Driver. I had initially set the CLASSPATH in my Environment Variables, however, my editor was over-riding those.
JAR instructions
For testing purposes here were my files:
LoadDriver.java

package classes;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import java.applet.Applet;
import java.awt.Toolkit;

public class LoadDriver extends Applet {
Toolkit t = Toolkit.getDefaultToolkit();
Driver drv;

public void init() {

JButton button = new JButton("Push Me");
this.add(button);

button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ee) {

String createString;
                createString = "create table TESTTABLE1 " +
                               "(COF_NAME VARCHAR(32), " +
                               "SUP_ID INTEGER, " +
                               "PRICE FLOAT, " +
                               "SALES INTEGER, " +
                               "TOTAL INTEGER)";
        java.sql.Statement stmt;

try {

Class.forName("org.gjt.mm.mysql.Driver", true, this.getClass().getClassLoader());

}catch (Exception E) {System.err.println("Unable to load driver.");
        
        t.beep();
        }
 
 try {
 
 Connection con = DriverManager.getConnection("jdbc:mysql://IP of Server:3306/test");
 
 stmt = con.createStatement();
            stmt.executeUpdate(createString);
            stmt.close();
            con.close();
                
        }catch (SQLException E) {
        System.out.println("SQLException: " + E.getMessage());
            System.out.println("SQLState:     " + E.getSQLState());
            System.out.println("VendorError:  " + E.getErrorCode());
        }
        
      }});
            
    }
 
 
 public void destroy() {

}
       
}

Test.html

JAR Command Line
JAR cvf test1.jar classes\*.*
As you can see in my HTML file, I then point the archive PARAM to my test1.jar as well as my mySQL_uncomp.jar. This way, the applet knows where all the code is.
Misc Hints
I did not use any certification or trust policies, nor did I jarsign my JAR files. The reason I didn't have to is because the only file system I am accessing is the same one the Applet originates from, the Web Server. However, if you wish to manipulate anything on the client machine, you must authenticate your applet to the browser and make it a trusted applet.
I hope that this helps some people having the same problem I was having. If anyone has any question about what I did, please feel free to contact me.
Thanks for everyones help in me resolving this issue.

Suzana Shah

Greenhorn

Posts: 12

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Greg
Say if I had the following system specs:
Server - Tomcat server but on win98 platform
Database - MySQL 3.23.44-max
MySQL Driver - mm.mysql.jdbc-1.2c
JDK 1.3
Java Editor - JCreator Pro 2.0
Then in the above case, would i have to change the code, or shall i try using what you have done, would there be any changes to it?
Thanks
Suzi

Gregg Bolinger

Ranch Hand

Posts: 15304

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am not that familiar with the Tomcat Web Server, but I don't think you would have to change anything. Everything else is the same. There may be some Security differences in the Web Server that may have to be adjusted, but that's all I can tell.