two servlets, one datasource

[Toby Davis]

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 ]

[Pradeep bhatt]

If u are going to use the same database with the same configuration values (e.g. user name,pool size etc) then go for the same datasource.

[arun sahni]

I think connection pooling is better option.

[Kelly Harris]

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.