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 Jean-Christian Imbeault

Back

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

Thanks. Can you supply some online references or perhaps books? I would like
to study various ways of implementing this and weight the pros and cons to
see which would suit us best.

Jc

-- --Original Message-- --
From: Umesh Singh [mailto:USingh@(protected)]
Sent: Wednesday, April 07, 2004 6:39 PM
To: 'jean-christian.imbeault@(protected)';
J2EEPATTERNS-INTEREST@(protected)
Subject: RE: Separating SQL from code

Hi You can use DAO with Properties file to keep the SQL configurable. We are
using SQL as Private String at class level in the DAO. You can use this
approach also so it is manageable.

Regards,
Umesh

====================================================================
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)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face="ＭＳ Ｐゴシック"
color=#0000ff size=2><SPAN
class=843014209-07042004>Thanks. Can you supply some online references or
perhaps books? I would like to study various ways of implementing this and
weight the pros and cons to see which would suit us best.</SPAN></FONT></DIV>
<DIV><FONT face="ＭＳ Ｐゴシック"
color=#0000ff size=2><SPAN
class=843014209-07042004></SPAN></FONT> </DIV>
<DIV><FONT face="ＭＳ Ｐゴシック"
color=#0000ff size=2><SPAN
class=843014209-07042004>Jc</SPAN></FONT></DIV>
<DIV><FONT face="ＭＳ Ｐゴシック"
color=#0000ff size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-- --Original Message-- --<BR><B>From:</B> Umesh Singh
[mailto:USingh@(protected)] <BR><B>Sent:</B> Wednesday, April 07, 2004 6:39
PM<BR><B>To:</B> 'jean-christian.imbeault@(protected)';
J2EEPATTERNS-INTEREST@(protected)<BR><B>Subject:</B> RE: Separating SQL from
code<BR><BR></FONT></DIV>
<P><FONT size=2>Hi You can use DAO with Properties file to keep the SQL
configurable. We are using SQL as Private String at class level in the DAO.
You can use this approach also so it is manageable.</FONT></P>
<P><FONT size=2>Regards,</FONT> <BR><FONT
size=2>Umesh</FONT></P></BLOCKQUOTE></BODY></HTML>
====================================================================
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)