I have a named JDBC datasource with pooling enabled that's maintained in my application server (i.e. JRun, WebSphere, etc). Is it smart to have two different servlets using the same named datasource? Or is it better practice to have one datasource per servlet (even though each datasource ties into the same database)? (If this is too simplified and more detail is needed, pls let me know) --- [ May 21, 2002: Message edited by: Toby Davis ]
Data Pooling is great the only caveat you have to pay attention to is the number of connections. Older versions of Access only allowed a small number of connections (like 20) at the same time. More recent versions of the drivers allow a more realistic amount.