I have tried this, with no luck. I also changed the driver name to a bogus title, and
received the same error message " No valid driver". I am using
"org.gjt.mm.mysql.Driver" as the driver name, which seems to be what is
needed. I have not changed the default localhost port, so the URL is used is
"jdbc:mysql://localhost:3306/test". Could the "Name" of the datasource affect anything
??
Lynn Walton wrote:
> Did you try putting the port number after localhost?
> jdbc:mysql://localhost:3306/test
> 3306 is mysql's default port ... or substitute your port if you have it running on
>something other than the default
>
> I don't know if that would make a difference but that's what I use with Jrun2.3.
>
> Lynn
>
> Jeff Ernst wrote:
>
> > I have my mm.mysql-2.0.3-src.jar in the /lib, /servers/lib, and
>/servers/admin/lib. From what I have seen in the archives, if I receive this error
>message it's a URL issue. Can you tell me if the URL is correct assuming
> > there is a working database named "test" in mySQL.
> >
> > Thanks ...
> >
> > Dave Daniels wrote:
> >
> > > This is a common error. The driver should be in the Admin Server classpath
> > > as well for the test to work.
> > >
> > > ----- Original Message -----
> > > From: Jeff Ernst <[EMAIL PROTECTED]>
> > > To: JRun-Talk <[EMAIL PROTECTED]>
> > > Sent: Tuesday, December 26, 2000 11:22 AM
> > > Subject: JBDC Configuration with mySQL
> > >
> > > > I am trying to configure my Jrun JDBC data source to connect to mySQL.
> > > > I have my driver in the proper class path, and the URL I am using is
> > > > jdbc:mysql://localhost/test?user=root. Both Jrun, and mySQL are on
> > > > the same PC. When trying to test, I get the " No valid driver" error
> > > > message. Is this the right URL ??, and what would be the datasource
> > > > name I would use as well. Thanks for any help ... Jeff
> > > >
> > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup
from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit
SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
