I am writing a small application using struts. I plan to use Data Access Object (DAO) pattern for my Model. I am connfused if I should use application server specific conection pooling or some external packages. If I use app server specific than how much code I need to re write if I move to another app server? I know it depends on how I design the code - Is there any place where I can read more about it? What about using external packages? any opensource available for free?
Thanks Jeanne for your response. I do not plan to write my own connection pooling package. Currently I am working with WSAD that comes with WS 5.1 Test environment. If I use connection pooling provided by WS and down the road decided to move to another App Server say Apache, do I need to write the code again to use Apache Connection pooling?
What is the difference between using app server connection pooling vs. external package?
Connection pooling provided by an app server will generally give you access to said data source via JNDI so your code shouldn't need to change at all with the exception of the JNDI name, which should probably be in a config file of some sort anyway.