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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Rick > Archibald > Sent: Monday, October 01, 2001 7:28 PM > To: [EMAIL PROTECTED] > 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 > > > > *********************************************************************** > 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. > *********************************************************************** > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers > > _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
