I am not sure but can I use JNDI when I configure the data-sources within
the struts-config.xml like:
<data-sources>
<data-source
autoCommit="true"
description="my Description"
driverClass="org.gjt.mm.mysql.Driver"
maxCount="4"
minCount="2"
password=""
url="jdbc:mysql://localhost:3306/mydb"
user="root"
/>
</data-sources>
How else can I access the datasource?
thx Rainer
> 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]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
