cannot connect to mysql

[pa...@nexus.net.mx]

Hi! I have installed Tomcat as a standalone server
with jdk-1.3. I have installed JDBC driver but
this script cannot contact to mysql:
//------------------------------------VARIABLES--------------------------------------

  String error;  // an error message.
  private String login;
  private String password;
  private String dbname;
  private String constring;
  private int tipoCon;

  Connection con;

  public DBMBean()
  {
     login="";
     password="";
     dbname="";
     tipoCon=0;
  }

//------------------------------------CONECTAR---------------------------------------

  public void conectar() throws
ClassNotFoundException, SQLException, Exception
  {
    try
    {

    // Cargar el archivo de la clase del manejador
    //Drivers:
    //         * ODBC:
"sun.jdbc.odbc.JdbcOdbcDriver"
    //         * mysql: "org.gjt.mm.mysql.Driver"
    // Hacer la conexi�n a la fuente de ODBC, sin
username o password.
       if(tipoCon==0)
       {
        
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         con =
DriverManager.getConnection("jdbc:odbc:"+dbname,login,
password);
       }
       else
       {
         Class.forName("org.gjt.mm.mysql.Driver");
         con =
DriverManager.getConnection("jdbc:mysql://localhost/"+dbname);
       }
        
    }

    catch (ClassNotFoundException cnfe)
    {
      error = "ClassNotFoundException: Could not
locate DB driver.";
      throw new ClassNotFoundException(error);
and so on.. I don't know much about Java i;m only
admin and this is not my script. Starting tomcat
it shows mm.driver on its path: Setting
TOMCAT_HOME to
/usr/local/jakarta-tomcat-3.2.1/bin/..
Using classpath:
/usr/local/jakarta-tomcat-3.2.1/bin/../lib/ant.jar:/usr/local/jakarta-tomcat-3.2.1/bin/../lib/jasper.jar:/usr/local/jakarta-tomcat-3.2.1/bin/../lib/jaxp.jar:/usr/local/jakarta-tomcat-3.2.1/bin/../lib/META-INF:/usr/local/jakarta-tomcat-3.2.1/bin/../lib/mm.mysql-2.0.14:...
Other things jsp examples servlets compiling beans
with javac and working with mysql on terminal are
ok. We have tried also connect with password and
username but, no connection. Is the problem
script, mm.driver, or something in MySQL? There is
also Apache running on the same machine, but at
least now Tomcat and Apache are
standalones.

---------------------------------------------
Mensaje enviado usando el Webmail de Nexus Net.
http://www.nexus.net.mx/webmail/



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>