[cobalt-developers] Cannot make JDBC connection to MySQL (Java Developers Kit package)

["Rick Archibald" <rick.archibald@xxxxxxx>]

Problem - cannot make JDBC connection to MySQL with the new Java Developers
Kit package.

Previously, I used JSP and servlets on my RaQ3 with a solution that had
been hacked together.  After Cobalt came out with a package for the Cobalt,
I decided I wanted to use that instead.  Here's what I did:
1.  Install latest patches:
     RaQ3-All-System-4.0.1-10659.pkg
     RaQ3-All-System-4.0.1-10765.pkg
     RaQ3-All-Security-4.0.1-10628.pkg
     RaQ3-All-Kernel-4.0.1-2.216C28III.pkg
2.  Remove old jakarta-tomcat directory, java sdk, and modifications to
configuration files.
3.  Installed Java Developers Kit package and Java Update package.

Everything installed fine, and my JSP and servlets work.  However, I can no
longer connect to the MySQL server.  When my JSP pages try to connect ,
they produce a 500 page which says "Cannot connect to MySQL server on
www.mysite.com:3306. Is there a MySQL server running on the machine/port
you are trying to connect to?"  I can telnet "telnet www.mysite.com 3306",
and I get a reply with the version of MySQL server followed by some
gibberish.  I also run "mysqladmin -p -h 'www.mysite.com' --port=3306
version", and I get a reply saying the connection is "www.mysite.com via
TCP/IP" and theTCP port is "3306".  Everything appears to work fine, except
I can't get my jsp pages to connect.

After encountering these problems, I upgraded the MySQL package from
3.23.36 to 3.23.37, but I still got the 500 page with the same message.  An
additional change I noted between the working solution I had before and the
current solution is that the jdbc driver is currently from the
mm.mysql.jdbc-1.2c.tar.gz (I think I used mm.mysql-2.0.4-bin.jar before).

Here are the parameters:
DRIVER = "org.gjt.mm.mysql.Driver";
USERNAME = "my_username";
PASSWORD = "my_password";
URL = "jdbc:mysql://www.mysite.com/database";

Here are the software packages I'm using:
MySQL - 3.23.37
JDBC driver - mm.mysql.jdbc-1.2c.tar.gz
Tomcat - 3.2.3
Java - jdk1.3.1



***********************************************************************
This e-mail and any attachments may contain information which is
confidential, privileged, proprietary or otherwise protected by law.
The information is solely intended for the named addressee (or a person
responsible for delivering it to the addressee).  If you are not the
intended recipient of this message, you are not authorized to read,
print, retain, copy or disseminate this message or any part of it.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and delete it from your computer.
***********************************************************************