Separating SQL from code

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Tomcat - JSP/Servlet container

Struts - A MVC web framework

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

JSP - A mailing list about Java Server Pages specification and reference

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Oracle Connection Pooling in 3 2 2
•	Servlet : Session invalidate
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Tomcat and webapplication specific java library path
•	Running a Simple JMS Example
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	Cannot find message resources under key org apache struts action MESSAGE
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	url string for connecting jboss to oracle
•	Value attribute of <html:checkbox
•	javax servlet ServletException: BeanUtils populate
•	HTTP Status 404 The requested resource is not available
•	5 0 18: Windows XP Pro vs Windows 2000

Separating SQL from code

Separating SQL from code

2004-04-07 - By Sean Brydon

Back

Reply: 1 2 3 4 5 6 7 8 9 10

Hi,

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 portsability since sometimes
SQL is not that portable.

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

hope that helps,
Sean

Jean-Christian Imbeault wrote:

>Hi, I'm somewhat new to patterns and J2EE but I was wondering if someone
>could help with a question I have.
>
>I'm wondering if there are any patterns of practices that document ways to
>extract SQL from code or that discuss if this is a good thing or not?
>
>I have read the J2EE Patterns book and done a bit of research (especially on
>DAO) but can find anything that talks about a total separation of SQL from
>code. I am wondering is removing SQL from code (and possibly placing it in a
>properties file or such) might be a good way of putting all the SQL in one
>place to make changes (maintenance) easier.
>
>The best I could find was this article which documents one approach but not
>the pros or cons:
>
>http://www.javapractices.com/Topic105.cjp
>
>Thanks!
>
>Jean-Christian Imbeault
>
>====================================================================
>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)