Hi,
Not sure exactly what you are looking for, but in the blueprints
adventure builder, it has some common DAO functionality moved to a
utility class
http://java.sun.com/blueprints/code/adventure/1.0/src/com/sun/j2ee/blueprints/util/dao/DAOUtils.java.html
so that the DAOs dont all have the same code to close resources etc.
hope that helps,
Sean
Monde Hans wrote:

> I see there is some code duplication when you use a preparedStatement
> with DOA partten. Does anyone has an example or written article where he
> uses a prepared
> statement and have converters or something like that. To centralise the
> actual data retrieval. You have to dop all the creration, data
> rtetrieval and closing of prepared statements in all your DAO objects.
> If you could have one base class that at least does the creation seting
> of values, retrieval of values and closing of the prepared statements.
>
> Sean Brydon wrote:
>
>> hey,
>>
>> This is an excellent article, and summarizes some really useful tips. In
>> a web app with no EJBs especially, you have to be a bit more carfeul
>> when handling concurrency, transactions etc since your code doesn't run
>> in the managed environment of the EJB container. So it pays to be extra
>> careful when designing the model layer and data access.
>> We have some similiar material in our BluePrints adventure builder
>> application early access architecture/design document at
>> http://java.sun.com/blueprints/code/adventure/1.0/docs/architecture.html
>> where we discuss DAOs and transaction since the adventure builder
>> highlights a web-centric architecture(no ejbs). Your article really
>> captures a lot of good advice.
>>
>> hope that helps,
>> Sean
>>
>> Sullivan, Sean C - MWT wrote:
>>
>>> If you are using the DAO pattern, you may be interested
>>> in this article.
>>>
>>> Advanced DAO Programming
>>> http://www-106.ibm.com/developerworks/library/j-dao/
>>>
>>> -Sean
>>>
>>> ====================================================================
>>> Companion Site: http://www.corej2eepatterns.com
>>> J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
>>> List Archive:
>>> http://archives.java.sun.com/archives/j2eepatterns-interest.html
>>> Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
>>> listserv@(protected)
>>>
>>>
>>
>> ====================================================================
>> Companion Site: http://www.corej2eepatterns.com
>> J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
>> List Archive:
>> http://archives.java.sun.com/archives/j2eepatterns-interest.html
>> Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
>> listserv@(protected)
>
>
> ====================================================================
> Companion Site: http://www.corej2eepatterns.com
> J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
> List Archive:
> http://archives.java.sun.com/archives/j2eepatterns-interest.html
> Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
> listserv@(protected)

====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)