Using Tomcat 4.1.18 container managed pooled connections, by placing the
following in my Context in server.xml:
<Resource name="jdbc/mydb" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydb">
...config here...
</ResourceParams>
As I understand it this results in a BasicDataSource being created and used to
implement the pool. Works like a charm, btw. ;-)
I'm pretty sure the PoolableConnections returned from this data source do not
by default pool prepared statements. On looking further I see that there is
definitely at least planned support for doing so (PoolingConnection &
PoolablePreparedStatement), but it doesn't look like the BasicDataSource Tomcat
creates right now will do the job:
BasicDataSource.java, r1.12
// Set up the poolable connection factory we will use
PoolableConnectionFactory connectionFactory = null;
try {
connectionFactory =
new PoolableConnectionFactory(driverConnectionFactory,
connectionPool,
null, // FIXME - stmtPoolFactory?
So my question-- is this functionality planned for BasicDataSource, will I need
to manually write my own object factory to dispense PooledConnections, or is
there some JNDI configuration which will get Tomcat to handle all this for me?
Thanks,
Jason Pettiss
[EMAIL PROTECTED]
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
