Mysql problem

[Nick15]

Hi everybody I am trying to do a basic library system.
the problem is:
I downloaded MySQL driver (connector/j) I copied .jar in CLASSPATH/jre/lib/ext
but it didn't work, I tried to copy the .jar in the directory of my application where I have my .java (or .class in execution time)
but when I execute the application the following error appear:

java.lang.ClassNotFoundException: Resource not found:
com/mysql/jdbc/Driver.class

this is the code:

Code:

try{
     
Class.forName("com.mysql.jdbc.Driver").newInstance();
aqui parece estar el error.
      String url =
"jdbc:mysql://mysql.webcindario.com";
      String login = "user";
      String password = "password";
      Connection conn =
DriverManager.getConnection(url,login,password);  
      if (conn != null)
      {
        JOptionPane.showMessageDialog(null,
"conexion", "alert", JOptionPane.ERROR_MESSAGE);
        conn.close();
      } 
    }
    catch(SQLException sql)
    {
      sql.printStackTrace();
    }
    catch(ClassNotFoundException cnfe)
    {
      cnfe.printStackTrace();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

Please help me
Nick

[pegitha]

Is this a web app ?

[Freddie]

I give you 2 solutions:

1 the official one: Add the driver to classpath, never mind where the applet and the connector are
it would be something like this:
JAVA_HOME=/usr/local/jdk1.x
export JAVA_HOME
CLASSPATH=${JAVA_HOME}/lib/tools.jar
CLASSPATH=${CLASSPATH}:${JAVA_HOME}/jre/lib/ext/theconnector.jar
export CLASSPATH
(is an example)

2. not official one (but it works!): unzip connector.jar, do it with winrar (WinRAR archiver, a powerful tool to process RAR and ZIP files) when you unzip there are folders in a hierarchy order,
start with 'com' folder,explorer it: com->mysql->jdbc, copy 'com' folder (with its content) into directory where there are the applet whose connect to mysql
and that is!

good luck!