-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
David Smith wrote:
>>Despite my posting - and I really hope someone chips in concerning the
>>question I raised about the <resource-ref> being redundant in the
deployment
>>descriptor (!) - the first thing to say is, have faith!
>>
>>Connection pooling works, and it is actually quite simple, so do not
give up
>>on it.
>
>
> Cheers for the advice Harry... here's where I'm at....
>
> I have no choice on the giving up side of things, need to implement it
> for some client code I'm working on
>
> ;-)
>
> I've been doing a lot of googling to try and get answers so I may have
> got crossed wires, I had a version working (or thinking it was working)
> with the info in $JAKARTA_HOME/conf/server.xml but I wasn't happy with
> this solution (preferring to have the connection defined in
> $JAKARTA_HOME/conf/Catalina/localhost/<app_name>.xml for good reasons...
>
> so I'm basically restarting and I now have the following config
>
> $JAKARTA_HOME/conf/Catalina/localhost/<app_name>.xml
>
> <?xml version='1.0' encoding='utf-8'?>
> <Context docBase="dev-sstl" path="/dev-sstl" reloadable="true"
> useNaming="false">
>
> <Resource
> name="jdbc/mysql"
> type="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"
> auth="Container"/>
Dave,
You don't want to do this, as Tomcat's DBCP doesn't wrap connection pool
data sources currently (or if they do, I can't find it documented anywhere).
If you follow the example given in the Tomcat documentation
_to_the_letter_ things work out fine. Once you have _that_ working, then
start tweaking from there. I've found that trying to plug the right
magic values from scratch into server.xml never works as you'd expect.
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
Meet the MySQL Team! April 14-16, 2004 http://www.mysql.com/uc2004/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFATfR1tvXNTca6JD8RAmfvAJ9dkmmyQmwAht6DmAsB/OrZPiiKVgCePuVs
Zqkj0tMidrTKUMuAX5b3ekA=
=Q5rH
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
