tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <ku...@inwind.it>
Subject Re: using a MySQL remote database
Date Tue, 08 Apr 2003 13:22:57 GMT
Hello,
the error was simply that i wasnt calling the newInstance() on Class.forName
(mysql_class_driver),
i added that and now it is working.
Sorry for my silly error :)
Anyway many thanks, Tomcat is nicely supported by you all!

Greetings,
groton

-----Messaggio Originale-----
Da: "Jon Wingfield" <jon.wingfield@mkodo.com>
A: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Data invio: martedì 8 aprile 2003 12.05
Oggetto: Re: using a MySQL remote database


> And you're specifying a port?
>
> this connection string works for me:
> jdbc:mysql://remote.server:3306/dbname
>
> Of course the mysql user must have permission to access the database
> from your app server box. Check the user permissions defined in the
> mysql database of your mysql instance.
>
>
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Connection_access
>
> HTH,
>
> Jon
>
> kurtc@inwind.it wrote:
> > Ok, i followed both the tips by Greg and this one in the email at the
bottom
> > of this email ( :) ),
> > but with no success.
> > I did exactly what the README (containbed in the MySQL connector
archive)
> > explains:
> >
> > snip from the README file:
> > ================================
> >   Issue:
> >   "My application throws a SQLException 'No Suitable Driver'".
> >   Resolution:
> >   One of two things are happening. Either the driver is not in
> >   your CLASSPATH (see the "USAGE AND INSTALLATION" section above), or
your
> >   URL format is incoorect (once again see "USAGE AND INSTALLATION").
> > ================================
> >
> > Eh, that error above is the error i got!
> > Although I installed correctly the connector for MySQL in TomCat, im
still
> > getting the errors above. Reading again the USAGE AND INSTALLATION will
not
> > help me.
> >
> > Finally I tryed to copy the jar containing the MySQL connector every
where
> > in the "lib"s dirs, i also had extracted the class files contained in
that
> > .jar in all the "classes" dirs, and still getting those error :|
> >
> > Any help? Or Any other way to connect to a MySQL server? Notice that
using
> > others servlet containers like Orion it works perfectly :o
> > luca
> >
> > Da: "dwightHugget" <jamaican@concentric.net>
> > A: "Tomcat Users List" <tomcat-user@jakarta.apache.org>;
<kurtc@inwind.it>
> > Data invio: domenica 6 aprile 2003 23.15
> > Oggetto: Re: using a MySQL remote database
> >
> >
> > On Sunday 06 April 2003 10:43, kurtc@inwind.it professed:
> >
> >>Hello,
> >>
> >>I would like to use a remote MySQL database. I already used that with
> >
> > ORION
> >
> >>with no problem, but with Tomcat i cant. I added the mmsql.jar file into
> >>shared/lib but accessing the database (using
> >> DriverManager.getConnection ("jdbc:mysql://host.host/databasename",
> >>username, password); ), i get always the error:
> >>
> >>SQLEXCEPTION = No suitable driver
> >>SQLSTATE = 08001
> >>
> >>Any help?
> >>
> >>luca
> >>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message