Best Approach for Database Access?

[Paul Idusogie <Pa...@stellent.com>]

Could you kindly provide guidance on the best approach to implement database access.?
I have encountered various schools of thought in my reading, that suggest extracting the business logic and database code from the jsp into a jsp bean or ejb or servlet.

Thanks,

Paul Idusogie 
Technical Architect 
Consulting Services
Stellent Inc.
7777 Golden Triangle Drive
Eden Prairie, MN 55104
Desk: 952.656.2755
Fax: 952.903.2115
Email: paul.idusogie@stellent.com
website: http://www.stellent.com

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Best Approach for Database Access?

[Keith Chew <ke...@jungledrum.co.nz>]

Hi Paul

I follow this design practice for both EJB and non-EJB applications. The
ones marked with * live at the application server JVM.

(1) Non-EJB environment
=======================
JSP -> ActionBean -> ServiceBean -> DaoBean -> DB

(2) EJB environment (BMP or Session)
====================================
JSP -> ActionBean -> * ServiceBean -> * DaoBean -> DB

(3) EJB environment (CMP)
=========================
JSP -> ActionBean -> * ServiceBean -> DB

Notes:
======
ActionBeans are the action classes of Struts
DaoBeans are normal JavaBean classes which knows how to communicate with the
DB, ie all SQL code goes here.
In (1), you need to take care of transactions on your own.
The ServiceBean in (1) is a normal JavaBean, but an EJB in (2) and (3)
In (3), we do not need a Dao, since the CMP does all that work for us.

Hope this helps
Keith

-----Original Message-----
From: Paul Idusogie [mailto:Paul.Idusogie@stellent.com]
Sent: Wednesday, 13 February 2002 9:38 a.m.
To: struts-user@jakarta.apache.org
Subject: Best Approach for Database Access?
Importance: High


Could you kindly provide guidance on the best approach to implement database
access.?
I have encountered various schools of thought in my reading, that suggest
extracting the business logic and database code from the jsp into a jsp bean
or ejb or servlet.

Thanks,

Paul Idusogie
Technical Architect
Consulting Services
Stellent Inc.
7777 Golden Triangle Drive
Eden Prairie, MN 55104
Desk: 952.656.2755
Fax: 952.903.2115
Email: paul.idusogie@stellent.com
website: http://www.stellent.com

--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>