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

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

Hi, Alex!

Changing the URL to localhost resolved my problem!

Thanks so much for your help!

Rick Archibald



Hi,

use this URL: jdbc:mysql://localhost/database
or set this permission to the appropriate virtaul host:
permission java.net.SocketPermission "mysite.com:1024-",
"listen,connect,resolve";
if you want to use mysite.com in URL.

Place your mysql driver to <appropriate virtual site>/WEB-INF/lib
or grant java.security.AllPermission to your mysql driver if you
place it in another place.
Are you sure that you use correct file - mm.mysql.jdbc-1.2c.tar.gz?
You need to use jar file instead to gz file. You wrote that you use
correct mm.mysql-2.0.4-bin.jar before, use it now.

Hope it help to you.
Regards,
Alex

> -----Original Message-----
> From: cobalt-developers-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Rick
> Archibald
> Sent: Monday, October 01, 2001 7:28 PM
> To: cobalt-developers@xxxxxxxxxxxxxxx
> Subject: [cobalt-developers] Cannot make JDBC connection to MySQL
> (Java Developers Kit package)
>
>
> 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
>


_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers





***********************************************************************
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.
***********************************************************************