Re: Database Best Practices

Here is one example: http://ibatis.apache.org/petstore.html It's use of struts is different, but the database access approach is solid. Larry On 8/17/05, C.F. Scheidecker Antunes <[EMAIL PROTECTED]> wrote: > Hello all, > > In order to access a Database on my Model layer, which one is best? >

Re: Database Best Practices

This might overwhelm you question, but it is worth: have a look at Persistence Frameworks: Hibernate or similar. C.F. Scheidecker Antunes wrote: > Hello all, > > In order to access a Database on my Model layer, which one is best? > > 1) A DataSource declared on the struts-config.xml. Then get th

Re: Database Best Practices

I would say: 3) Create a class that will look up the DataSource via JNDI lookup and cache that reference during initialization, and use that reference to get connections to distribute in your getConnection method. Only if the DataSource (aka connection pool) fails or is turned off would you nee