Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » J2EE Pattern »

Re: Separating SQL from code

Jean-Christian Imbeault

2004-04-07

Replies:

> From: Sean Brydon
>
> a couple strategies to consider. One is that you can
> externalize the SQL and put it into an XML file. This is
> discussed at http://java.sun.com/blueprints/patterns/DAO.html
> and is implemented in the JavaPetstore. This is mostly done
> for portability since sometimes SQL is not that portable.

Thanks for the link. This seems to be exactly the kind of pattern/concept I
was looking for. Now I just need to figure out how it is implemented and
come up with a design that I can apply to our project.

If anyone else has any information or links on this kind of SQL
externalization and how to implement it please let me know!

> another strategy is to use CMP, Container Managed
> Persistence, with EJBs.

EJBs are beyond my comprehension at the moment :(

Thanks,

Jc

====================================================================
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)
©2008 junlu.com - Jax Systems, LLC, U.S.A.