Thank you!
(and thanks to Chuck also)
Lloyd Chambers
http://diglloyd.com
http://macperformanceguide.com/
[Mac OS X 10.5.7 Intel, Tomcat 6.0.20]
On Aug 3, 2009, at 3:05 PM, Christopher Schultz wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Digilloyd,
On 7/31/2009 1:59 PM, DIGLLOYD INC wrote:
Thank you. Any snippet on the right way to to the Realm/Resource
thing?
It's been so long I don't remember the right way
Simple: just put this in your WEB-INF/context.xml file:
<Resource name="jdbc/MyDataSource"
description="[whatever]"
auth="Container"
type="javax.sql.DataSource"
maxActive="1"
maxIdle="1"
maxWait="10000"
url="@DATABASE_URL@"
username="@DATABASE_USERNAME@"
password="@DATABASE_PASSWORD@"
driverClassName="@DATABASE_DRIVER@"
removeAbandoned="true"
removeAbandonedTimeout="30"
logAbandoned="true"
testOnBorrow="true"
validationQuery="/* ping */ SELECT 1"
/>
Obviously, fill-in the appropriate values above.
You should also have in your web.xml something like this:
<resource-ref>
<description>[whatever]</description>
<res-ref-name>jdbc/MyDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
...but I've found that it is not strictly necessary. I think it's
because Tomcat knows that any <Resource> in WEB-INF/context.xml should
automatically be available in the visible JNDI context for the webapp.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkp3XxcACgkQ9CaO5/Lv0PDGcgCePI8NTUrVpCUyYKPBBOhhRnnW
aUQAoJAJEt2j0asnrgCDla49v5G1FQ7F
=F0rT
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org