I'm needing to move my data access from my Actions to a 'pure' business bean. Does anyone have a good example (or link) on how to create and use DAO?
Thanks. Jerry -----Original Message----- From: Vikram Goyal01 [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 3:43 AM To: Struts Users Mailing List Subject: RE: Database access design question 1. Do not use the session bean to access the datasource... create a data access object which locates the datasource. 2. Lookup the datasource using a jndi name not a servlet. Register your datasource with the jndi server. (Does the servlet api implement such a method ??) 3. If using a connection pool (which you should really), get the connection object out of the pool and use it to access the database. HTH Vikram -----Original Message----- From: rainer juenger [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 2:04 PM To: Struts Users Mailing List Subject: Re: Database access design question I want to accesss the database from a business logic bean that should not emplement *.servelet.* classes. But how can I then initialize the DataSource? like: dataSource = servlet.findDataSource(null); ?? Thanks Rainer > What exactly is your question? > The samples given with Struts do not necessarily following the best practices, they are more like proof of concepts than anything else. > > Rgs > Vikram > > -----Original Message----- > From: rainer juenger [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 10, 2002 1:45 PM > To: Struts Users Mailing List > Subject: Database access design question > > > Hi, > > I am using the Struts Database pooling. > My database connection is realised after the sample in the Struts User's > Guide. > http://jakarta.apache.org/struts/userGuide/building_model.html#databases > But I think the sample is very contradicting. > In chapter 2.5 Business Logic Beans is said: > "For maximum code re-use, business logic beans should be designed and > implemented so that they do not know they are being executed in a web > application environment. If you find yourself having to import a > javax.servlet.* class in your bean, you are tying this business logic to the > web application environment. " > > but chapter 2.6 is Accessing the Database in the sample via a ActionServlet: > public ActionForward > perform(ActionMapping mapping, > ActionForm form, > HttpServletRequest request, > HttpServletResponse response) > { > javax.sql.DataSource dataSource; > java.sql.Connection myConnection; > > try { > dataSource = servlet.findDataSource(null); > myConnection = dataSource.getConnection(); > > Now I am pretty confused since I want to implement the Database Access in a > buiseness logic bean. > > > Thanks for your help! > > Rainer > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> This transmission (and any information attached to it) may be confidential and is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient or the person responsible for delivering the transmission to the intended recipient, be advised that you have received this transmission in error and that any use, dissemination, forwarding, printing, or copying of this information is strictly prohibited. If you have received this transmission in error, please immediately notify LabOne at (800)388-4675. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
