Thanks again Nix, but latest mysql driver is *definitely* in
%catalina_home%\common\lib :
C:\>dir %catalina_home%\common\lib
Volume in drive C is BOOT
Volume Serial Number is D4DF-165E
Directory of c:\jakarta-tomcat-5.5.9\common\lib
19/05/2005 19:25 <DIR> .
19/05/2005 19:25 <DIR> ..
11/05/2004 12:54 54,829 activation.jar
26/03/2005 14:22 112,341 commons-el.jar
26/03/2005 14:22 918,743 jasper-compiler-jdt.jar
26/03/2005 14:22 383,134 jasper-compiler.jar
26/03/2005 14:22 76,664 jasper-runtime.jar
26/03/2005 14:22 50,493 jsp-api.jar
12/10/2004 13:20 347,137 mail.jar
14/04/2005 22:44 409,191 mysql-connector-java-3.1.8-bin.jar
26/03/2005 14:22 154,101 naming-factory-dbcp.jar
26/03/2005 14:22 36,333 naming-factory.jar
26/03/2005 14:22 46,606 naming-resources.jar
26/03/2005 14:22 97,693 servlet-api.jar
12 File(s) 2,687,265 bytes
2 Dir(s) 2,182,369,280 bytes free
OK, so now I'm struggling.
So I'm going to take a punt and say that I think there may be some kind of
class loading problem. I say this because:
- I have fresh installed TC, mysql and jdk;
- mysql works from the command line using my datasource username/pw;
- I have checked and rechecked my config a thousand times;
- the mysql driver is in the right folder;
- the error is suggestive of the fact that TC can't find the driver.
However, the driver it is there in the common/lib folder, plain for anyone
to see. I can only assume this is to do with security/classloading. I've
eliminated security, because TC runs as a service under the system account,
and I've checked that this account has read access to the file.
I'm almost tired of looking - if I can't solve it tomorrow, I'll be (very
reluctantly) setting aside TC 5.5 and carrying on with 5.0.28. I don't want
to do that, because 5.0.28 has some sesssion management bugs I'd like to get
past, and also because I've now spent 3 days trying to make 5.5 work.
So, any help would be most gratefully received :)
Original post here for those that missed it:
http://marc.theaimsgroup.com/?l=tomcat-user&m=111660199623420&w=2
> -----Original Message-----
> From: Nikola Milutinovic [mailto:[EMAIL PROTECTED]
> Sent: Saturday 21 May 2005 13:42
> To: Tomcat Users List
> Subject: Re: DBCP datasource works on 5.0.28 but fails on 5.5.9
>
>
> Steve Kirk wrote:
>
> >Thanks nix.
> >
> >
> >
> >>Could it be that you've missed the fact that
> >>DataSource JNDI resource setup definition has changed in TC
> >>5.5? It is
> >>no longer with those
> >><parameter><name>...</name><value>...</value></parameter>.
> >>
> >>
> >
> >Yes I already changed that. I used to use the approach you
> mention in
> >5.0.28, i.e.:
> >
> > <ResourceParams name="jdbc/myResource">
> > <parameter>
> > <name>username</name>
> > <value>...</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value>...</value>
> > </parameter>
> >
> > etc
> >
> > </ResourceParams>
> >
> >But noticed that the new 5.5 DBCP example used this approach:
> >
> ><Resource username="...." password="..." etc />
> >
> >So I switched to that, but still no joy.
> >
> >PS does it actually say in the docs anywhere that the
> ><parameter><name>...</name><value>...</value></parameter>
> approach is *NOT*
> >valid in 5.5? If so then I've missed some docs somewhere,
> maybe there is
> >other new stuff that I haven't seen.
> >
> >
>
> It definitely does not work in 5.5. I've used the config from
> the docs
> page with PostgreSQL and it worked. Other possible problem is
> that the
> driver class didn't load. Where have you placed the JDBC JAR? It goes
> either in ${CATALINA_HOME}/common/lib since it must be
> accessable to TC.
>
> Nix.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
