You can't access the generic datasource pool defined by the Struts config from the business tier. The closest you can come is to pass up the connection. The Struts generic datasource is really * not * the best way to go for most applications. I do not recommend using it for production applications.
Many DBMS packages and containers provide their own connection pools, including Tomcat 4 I believe. My best general recommendation is to grab Poolman 1.4 from http://sourceforge.net/project/showfiles.php?group_id=4899 and see: http://www.mail-archive.com/[email protected]/msg25554.html -- Ted Husted, Husted dot Com, Fairport NY US -- Developing Java Web Applications with Struts -- Tel: +1 585 737-3463 -- Web: http://husted.com/about/services rainer juenger wrote: > > Sorry but I am in another galaxy as you guys are. My problems are not that > complex yet and my knowledge isn't either. > I would only like to have a simple sample how I can access the Database > defined in the struts-config.xml without having to use any servlet depending > methodes/classes like pageContext, sessions or what so ever. There must be > a way! > > thanks 1000 times for a hint! > > Rainer > > ----- Original Message ----- > From: "Jerry Jalenak" <[EMAIL PROTECTED]> > To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]> > Sent: Monday, June 10, 2002 3:17 PM > Subject: RE: Database access design question > > > 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]>
