Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / September 2004

Tip: Looking for answers? Try searching our database.

problem with mysql 5.0 and java connector

Thread view: 
wildsurfer - 25 Sep 2004 18:16 GMT
I've a strange message when I try to connect to my db using java
connector ( mysql-connector-java-3.1.4-beta ):

javax.servlet.ServletException: Cannot connect to MySQL server on
localhost:3306. Is there a MySQL server running on the machine/port
you are trying to connect to? (java.lang.NumberFormatException)

I'm using tomcat 5.0.
Note that i don't have any problem to connect to the sql server using
for example mysql front or querying the server directly.
before I was using mysql 4.0.13 and everything just worked fine!
I wanted to upgrade my mysql server to the newer version, but I don't
know how to fix this problem.
I suppose that I had to unistall the old version and install mysql
5.0, but it doesn't work any more!do i have to change something else?
why the jdbc connector doesn't work any more?

this is what I use to connect to my db (I'm using dreamweawer and this
is the connection file)

<%
// FileName="Connection_jdbc_conn.htm"
// Type="JDBC" ""
// DesigntimeType="JDBC"
// HTTP="true"
// Catalog=""
// Schema=""
String MM_top11_DRIVER = "org.gjt.mm.mysql.Driver";
String MM_top11_USERNAME = "root";
String MM_top11_PASSWORD = "";
String MM_top11_STRING = "jdbc:mysql://localhost:3306/mydb";
%>

Thank you very much
Andrea
Dieter Bender - 26 Sep 2004 11:17 GMT
Hi,

which java version do you run at the Database client (the tomcat machine?)
there are prerequesits for the connector (1.4 +)

Dieter Bender

> I've a strange message when I try to connect to my db using java
> connector ( mysql-connector-java-3.1.4-beta ):
[quoted text clipped - 31 lines]
> Thank you very much
> Andrea


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.