Mailing-List: contact user-help@struts.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Struts Users Mailing List" <user@struts.apache.org>
Received-SPF: pass (herse.apache.org: domain of joegermuska@gmail.com
 designates 64.233.166.176 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
        b=fYHfV5OkdRRiPlAA3IBajr59ItSgW80bQpbSESUd75zJnkiAxblh1WH3esNvWCLBogJqvMmVSa0uM0Rf4R3ysnSu+XSI0rddTU9yyxA9Dlim3iFFfnNrmTPU9YzSU7IZZIHY5C96wzGgQkw4/HQTiX9QEDhJLpKARdkYnzkeIYk=
Message-ID: <242960fe0701160415uc2f9d44nac90102ab90bc659@mail.gmail.com>
Date: Tue, 16 Jan 2007 06:15:21 -0600
From: "Joe Germuska" <joe@germuska.com>
Sender: joegermuska@gmail.com
To: "Struts Users Mailing List" <user@struts.apache.org>
Subject: Re: [Struts 2] Database access
In-Reply-To: <200701161308.05393.plegal@appert44.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_28072_5389660.1168949721953"
References: <45aca582.4b.da9.737794952@inet.hr>
	 <200701161308.05393.plegal@appert44.org>

------=_Part_28072_5389660.1168949721953
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

This example is for Struts 1.x, not Struts 2.

Struts 2 provides no direct support for managing database connections,
although one could achieve something like this rather readily using Spring,
or probably with any other ObjectFactory.

Here's a tutorial which gets much more involved than your basic request, bu=
t
which might help.  Note that since the tutorial uses Hibernate, it isn't
exactly what you asked for, but it also demonstrates using Spring to
instantiate a Datasource, and then you could have Spring also instantiate
your Action Classes and "inject" the datasource dependency into them.

http://cwiki.apache.org/S2WIKI/struts-2-spring-2-jpa-ajax.html

Let me issue the standard disclaimer that if you are doing a lot of databas=
e
work in your Action classes, you may want to consider refactoring anyway.

Joe

On 1/16/07, Philippe Le Gal <plegal@appert44.org> wrote:
>
> Hi,
>
> Thanks again.
> Is it possible that you give me the complete listing of this example
> because,
> I've problem to find how to initialize the 'context' object.
>
> Thanks
>
> Philippe
>
> Le mardi 16 janvier 2007 11:14, Stanislav a =E9crit:
> > in java action class you can also connect through struts db mechanisam:
> > DataSource dataSource =3D (DataSource)
> > context.getAttribute("org.apache.struts.action.DATA_SOURCE"); conn =3D
> > dataSource.getConnection();
> > or direct to db
> > Connection conn =3D
> > DriverManager.getConnection
> (ConnectionURL,ConnectionUserName,ConnectionPass
> >word);
> >
> >
> >
> > From: Philippe Le Gal <plegal@appert44.org>
> > To: "Struts Users Mailing List" <user@struts.apache.org>
> > Subject: Re: [Struts 2] Database access
> > Date: Tue, 16 Jan 2007 11:08:28 +0100
> >
> > ----- Original Message Follows -----
> >
> > > Hi,
> > >
> > > Thanks for the information.
> > > I'm also looking for the mecanism of accessing the database in the
> java
> > > action class.
> > >
> > > Thanks
> > >
> > > Philippe
> > >
> > > Le mardi 16 janvier 2007 10:59, Stanislav a =E9crit :
> > > > in struts-config for sql database.
> > > >
> > > > <data-sources>
> > > >       <data-source type=3D"org.apache.commons.dbcp.BasicDataSource"=
>
> > > >          <set-property property=3D"driverClassName"
> > > > value=3D"com.microsoft.jdbc.sqlserver.SQLServerDriver" />
> > > >          <set-property property=3D"url"
> > > >
> value=3D"jdbc:microsoft:sqlserver://xxx.xxx.xxx.xxx:1433;DatabaseName=3Dx=
xx
> > > >xx;S electMethod=3DCursor" /> <set-property property=3D"username"
> > > > value=3D"xxxxx" /> <set-property property=3D"password" value=3D"xxx=
xx" />
> > > >          <set-property property=3D"maxActive" value=3D"0" />
> > > >          <set-property property=3D"maxWait" value=3D"5000" />
> > > >          <set-property property=3D"defaultAutoCommit" value=3D"fals=
e" />
> > > >          <set-property property=3D"defaultReadOnly" value=3D"false"=
 />
> > > >       </data-source>
> > > > </data-sources>
> > > >
> > > >
> > > > From: Philippe Le Gal <plegal@appert44.org>
> > > > To: user@struts.apache.org
> > > > Subject: [Struts 2] Database access
> > > > Date: Tue, 16 Jan 2007 10:53:12 +0100
> > > >
> > > > ----- Original Message Follows -----
> > > >
> > > > > Hi,
> > > > >
> > > > > I'm looking for a simple struts 2 database access example.
> > > > >
> > > > > Thanks for any url
> > > > >
> > > > > Philippe
> > > > >
> > > > >
> ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > > > For additional commands, e-mail: user-help@struts.apache.org
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > > For additional commands, e-mail: user-help@struts.apache.org
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > For additional commands, e-mail: user-help@struts.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>


--=20
Joe Germuska
Joe@Germuska.com * http://blog.germuska.com

"The truth is that we learned from Jo=E3o forever to be out of tune."
-- Caetano Veloso

------=_Part_28072_5389660.1168949721953--