Linking jar files into java applets - Computer Programmers, Programming Forum

juddster · #1 06-13-2008

Hi Guys,

I have a question about how to link a jar file (the mysql connection one) in with a java applet. I have been playing around with it for about an hour now and I still keep getting the "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" exception.

I have run the applet through Eclipse and it works perfectly but when I tried to link it through a web page I get that error message. Can someone please point me in the right direction?

Code:

import java.applet.Applet;

import javax.swing.JLabel;
import javax.swing.JPanel;


public class

Code:

Hangman extends Applet
{
    Connect conn;
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    
    public void init ()
    {
        int userId = 1;//Integer.parseInt ( this.getParameter ( "uid" ) );
        String pwd = "test";//this.getParameter( "pass" );
        
        this.conn = new Connect();
        if ( this.conn.checkCreds( userId, pwd ) )
        {
            this.add(new game());
        }
        /*else
        {
            System.out.println ( "ERROR - Invalid User Id/Password Combination" );
        }*/
    }
    
    private class game extends JPanel
    {
        public game()
        {
            JLabel tmp = new JLabel ( "YAY" );
            this.add( tmp );
        }
    }

}

Code:

import java.lang.*;
import java.sql.*;
import java.util.*;

import javax.swing.JOptionPane;

public class Connect
{
    Connection myConn = null;        

    Statement stmt = null;
    ResultSet rs = null;
    
    public Connect()
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");

            myConn = DriverManager.getConnection("jdbc:mysql://databaselink:3306/tablename", "username", "password");

            stmt = myConn.createStatement();
            if ( stmt == null )
            {
                System.out.println ( "ERROR" );
                return;
            }
        }
        catch(Exception e)
        {
            System.err.println(e);
        }

    }
    
    public boolean checkCreds ( int userId, String pwd )
    {
        try
        {
            if ( stmt == null )
        {
            System.out.println ( "ERROR" );
            return false;
        }
            rs = stmt.executeQuery( "SELECT `id` FROM `users` WHERE `id` = " + userId + " AND password = '" + pwd + "'" );
            rs = stmt.getResultSet();
            rs.next();
            if ( rs.getInt("id") == userId )
            {
                return ( true );
            }
            else
            {
                return ( false );
            }
        }
        catch ( SQLException s )
        {
            return ( false );
        }
    }
}

Code:

<applet code="Hangman.class" width=200 height=200 CODEBASE="./">
<param name=pass value="test">
<param name=uid value="1">
<param name=archive value="Hangman.jar, mysql-connector.jar" />
</applet>

<APPLET CODE="Hangman.class" ARCHIVE="Hangman.jar, mysql-connector.jar" 
HEIGHT="500" WIDTH="400" ALIGN="bottom" CODEBASE="./">
<param name=pass value="test">
<param name=uid value="1">
<param name=archive value="Hangman.jar, mysql-connector.jar">
</APPLET>

<object classid="java:Hangman.class"
              type="application/x-java-applet"
              archive="Hangman.jar, mysql-connector.jar"
              height="40" width="200" >
              
<applet code=Hangman.class name=Hangman archive="Hangman.jar, mysql-connector.jar"
    width=300 height=300>
    <param name="bgcolor" value="ffffff">
    <param name="fontcolor" value="000000">
    Your browser is not Java enabled.
</applet>

<applet code=Hangman.class width="200" height="200" >

I have made both a jar file for the Hangman.class (Hangman.jar which contains the mysql-connector.jar).

Any help would be greatly appreciated.

Thanks,
~juddster

juddster · #2 06-13-2008

I just tried it again at home and got the following errors on my java console with all of those 4 java calls.

http://pastebin.com/f2770d5d3
Thank you very much,
~juddster

juddster · #3 06-13-2008

PS - I just noticed a little error in my first post but I don't want to touch it because apparently YC doesn't like me very much right now...so please just ignore the top code box ~juddster

juddster · #4 06-14-2008

I thought I hit Edit. This post can be deleted..

juddster · #5 06-14-2008

Okay...so I have it giving an "AccessControlException" when I try to connect to the database through the JDBC driver. Any suggestions on how to fix this?

http://pastebin.com/faef9c54

That is the output from Java Console.

Code:

<applet code="wrap.class" width=200 height=200>
<param name=pass value="test">
<param name=uid value="1">
<param name=archive value="mysql-connector.jar" />
</applet>

That is the code I use to display the applet. wrap is just a class I made that would try to connect to the database.

Any help would be greatly appreciated.

Thank you,
~juddster

juddster · #6 06-26-2008

No suggestions for me?

~juddster

Jhi · #7 06-26-2008

Code:

java.io.IOException: Server returned HTTP response code: 403 for URL: http://www.dev.cyopets.com/javaApplets/mysql-connector.jar

I'd look into that first.

juddster · #8 06-28-2008

I have that already dealt with. My post further down has a link to the new errors that I'm having.

~juddster

Jhi · #9 07-02-2008

Why do you think you're being denied access?

juddster · #10 07-03-2008

I have no idea why I'm getting the Access Denied...the server says that we are allowed to have java applets connecting. I made my database user info available through any IP Address so I don't think that is the problem...

Any ideas?

~juddster

Welcome to our forums...

Latest Posts

Forum Statistics

Partner Sites

Friends

Welcome to our forums...

Latest Posts

Forum Statistics

Partner Sites

Sponsor

Friends