Using pooled connection may be of little use here .Because the same connection is used throughout the operation that is one connection/per entity. If I use a pooled connection I still need to get the same no:of connections. That is why we did not have that configuration If you really need it you can implement a PooledJdbcDataSource --Noble
On Tue, Jul 29, 2008 at 12:33 PM, Jeremy Hinegardner <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm using the DataImportHandler, and its working great. What I would > like to do is configure the <dataSource> to use a pooled conncation from > our Servlet container (Jetty) instead of having the DataImportHandler > instantiate and hold a new connection for each entity in our > dataimport-config.xml (which is what it appears to be doing right now). > > I'm not sure it can though. My quick perusal of the code seems to > indicate that it is using DriverManager.getConnection() instead of a > JNDI lookup. I'm assuming I'm wrong here, I've been out of java > development for quite some time. > > I'd like to be able to do something along these lines: > > <dataSource name="myDB" url="java:comp/env/jdbc/myDB" /> > > I may be completely missing something obvious here too, for instance the > right driver="" value to put in soemthing that will get a pooled > connection from the servlet container. > > enjoy, > > -jeremy > > -- > ======================================================================== > Jeremy Hinegardner [EMAIL PROTECTED] > > -- --Noble Paul
