You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Steffen Gransow <sg...@quasa.de> on 2003/10/29 14:18:09 UTC
Struts and db access
Hi,
I am totally new to J2EE/EJB and Struts - so perhaps this is the wrong
place to ask. In this case I would like to know where I should ask my
question or what I should've read before again asking silly questions.
:-)
I have to use a Sun One Application Server and a PostGreSQL database for
a project. And I am sure that I want to use Struts because of the whole
MVC thing. I would like to know how I should access data in a
appropriate way. I think I want to use CMP and I am wondering where or
how I should address the database. Do I have to create a JDBC ressource
on the Sun One Application Server or do I have to define a datasource
using Struts DataSource manager?
I thought of something like:
------ Controller ------------ Actions
| (ActionServlet) |
| | |
Client ---- | |
| | |
| | |
------ View (JSPs) - - - - - - Model (Beans) ------ PostGreSQL
DB
And on the Model part of this simple ascii art I think it would be nice
to have something like:
Action ---
|
--- business logic bean ---
(use a facade?) |
--- data representaion (entity beans)
Is this approach okay? Back to my question stated above: How do I get
the entity beans "connected" to the database? Is struts independent of
this question? Should I try to do this by reading Sun's AppServer
documentation? ;)
Thanks in regards,
Steffen Gransow
----------------
newbie questioner
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
anyone used multiple struts configuration file and tiles work together?
Posted by kean <ke...@pcdom.org.my>.
doesn't seem to work on mine ... being spending sometime trying to
figure out:P Any help to point to the right direction will be appreciated.
I do it step by step and make sure it's work on single struts
configuration files and single tile configuration file, then I move it
to multiple struts configuration file and follow the example given by
Ted, but without using the tile. it's work fine. Then I put in the tiles
in, and thing start to get unstable, sometime it's display fine and
sometime it's wouldn't fine.
I can't seem to track down the problem, here is my configuration file:
*struts-config.xml*
<global-forwards>
<forward name="goToSystem" contextRelative="true"
path="/system/showIndex.do" />
</global-forwards>
*struts-system-config.xml*
<action type="org.apache.struts.actions.ForwardAction" validate="false"
parameter="system.index" scope="request" path="/showIndex" />
*tile-config.xml*
<definition name="system.index" extends="system.main">
<put name="body" value="/system/index.jsp" />
</definition>
the error message:
is path "system.index" doesn't start with the character "/"
my altimate goal is to used multiple struts configuration file and
multiple tiles configuration file, but now I would be happy to settle
for multiple struts configuration file and single tiles configuration file.
kean
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: was Re: Struts and db access: OT: pgSQL
Posted by Mark Lowe <ma...@talk21.com>.
I'm sold.. Thanks Oscar and Vic.
I never touch windows anyway because its silly, especially when its
anything to do with servers. I had the pleasure to setting up an oracle
server once and I wouldn't volunteer a second time (although it ran
okay once the fooker was up).
Cheers Mark
On Wednesday, October 29, 2003, at 05:35 PM,
struts@daydream.stanford.edu wrote:
> If you are on Linux/Unix I really think Postgresql is the way to go.
> It's
> easy to install and manage and supposedly will scale as well as just
> about
> any db on the market. MySQL is a little easier to install in Windows,
> cause w/Postgresql you'll need to install CygWin first.
>
> Keep in mind that the default install for Postgresql using resources is
> very, very conservative. So, you have to change a couple of values in
> the
> config file and that's it.
>
> I like using PgAccess, when I want to view/edit the database with a
> GUI.
>
> I have Postgres/PgAccess install instructions on my site:
> http://daydream.stanford.edu/install_web_services.html
>
> In my opinion, if you can afford Oracle and are a full-time Oracle
> admin,
> or you have a full-time Oracle admin working for you, then you may
> want to
> go with Oracle :)
>
> If you're in a DIY (Do it Yourself) situation, then I highly recommend
> Postgresql.
>
> Cheers,
> Oscar
>
> On Wed, 29 Oct 2003, David Friedman wrote:
>
>> This article seems very old. A significant portion
>> of what they talk about was fixed in the Version 4.0
>> of MySQL which has got to be at least 9 months old
>> or so.
>>
>> Regards,
>> David
>>
>> -----Original Message-----
>> From: news [mailto:news@sea.gmane.org]On Behalf Of Vic Cekvenich
>> Sent: Wednesday, October 29, 2003 12:17 PM
>> To: struts-user@jakarta.apache.org
>> Subject: was Re: Struts and db access: OT: pgSQL
>>
>>
>> oh and another link
>> http://det-dbalice.if.pw.edu.pl/det-dbalice/ttraczyk/db_compare/
>> db_compare.h
>> tml
>>
>> Mark Lowe wrote:
>>
>>> I didn't know the postgres was faster than oracle.. I agree that its
>>> the
>>> canine's genitalia .. But I still thought oracle was the daddy when
>>> it
>>> came to speed. Is that just read access or everything?
>>>
>>>
>>> On Wednesday, October 29, 2003, at 02:52 PM, Vic Cekvenich wrote:
>>>
>>>> This might confuse you more than help... but it is meant to be
>>>> helpful.
>>>> Look at iBatis.com PetStore 3.
>>>>
>>>> I use a iBatis DB layer as DAO to pgSQL for a DAO layer.
>>>>
>>>> And NO Struts does not specify or endorse a certain way to access
>>>> data. A formBean maps to a (JSP/HTML) form, and is data agnostic.
>>>> This
>>>> way people can chose.
>>>>
>>>> (pgSQL rocks!!! Free run time on windows and unix, stored procedure
>>>> support, ANSI SQL, faster than Oracle/MS SQL)
>>>>
>>>> .V
>>>>
>>>> Steffen Gransow wrote:
>>>>
>>>>> Hi,
>>>>> I am totally new to J2EE/EJB and Struts - so perhaps this is the
>>>>> wrong
>>>>> place to ask. In this case I would like to know where I should ask
>>>>> my
>>>>> question or what I should've read before again asking silly
>>>>> questions.
>>>>> :-)
>>>>> I have to use a Sun One Application Server and a PostGreSQL
>>>>> database for
>>>>> a project. And I am sure that I want to use Struts because of the
>>>>> whole
>>>>> MVC thing. I would like to know how I should access data in a
>>>>> appropriate way. I think I want to use CMP and I am wondering
>>>>> where or
>>>>> how I should address the database. Do I have to create a JDBC
>>>>> ressource
>>>>> on the Sun One Application Server or do I have to define a
>>>>> datasource
>>>>> using Struts DataSource manager?
>>>>> I thought of something like:
>>>>> ------ Controller ------------ Actions
>>>>> | (ActionServlet) |
>>>>> | | |
>>>>> Client ---- | |
>>>>> | | |
>>>>> | | |
>>>>> ------ View (JSPs) - - - - - - Model (Beans) ------
>>>>> PostGreSQL
>>>>> DB
>>>>> And on the Model part of this simple ascii art I think it would be
>>>>> nice
>>>>> to have something like:
>>>>> Action ---
>>>>> |
>>>>> --- business logic bean ---
>>>>> (use a facade?) |
>>>>> --- data representaion (entity
>>>>> beans)
>>>>> Is this approach okay? Back to my question stated above: How do I
>>>>> get
>>>>> the entity beans "connected" to the database? Is struts
>>>>> independent of
>>>>> this question? Should I try to do this by reading Sun's AppServer
>>>>> documentation? ;)
>>>>> Thanks in regards,
>>>>> Steffen Gransow
>>>>> ----------------
>>>>> newbie questioner
>>>>
>>>>
>>>> --
>>>> Victor Cekvenich,
>>>> Struts Instructor
>>>> (215) 321-9146
>>>>
>>>> Advanced Struts Training
>>>> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
>>>> training with Rich UI, mentoring, designs, samples and project
>>>> recovery
>>>> in North East.
>>>> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
>>>> Shopping and Credit processing, <http://basicportal.com> software,
>>>> ready
>>>> to develop/customize; requires a db to run.
>>>>
>>>>
>>>>
>>>> --------------------------------------------------------------------
>>>> -
>>>> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>>>>
>>
>> --
>> Victor Cekvenich,
>> Struts Instructor
>> (215) 321-9146
>>
>> Advanced Struts Training
>> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
>> training with Rich UI, mentoring, designs, samples and project
>> recovery
>> in North East.
>> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
>> Shopping and Credit processing, <http://basicportal.com> software,
>> ready
>> to develop/customize; requires a db to run.
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
RE: was Re: Struts and db access: OT: pgSQL
Posted by st...@daydream.stanford.edu.
If you are on Linux/Unix I really think Postgresql is the way to go. It's
easy to install and manage and supposedly will scale as well as just about
any db on the market. MySQL is a little easier to install in Windows,
cause w/Postgresql you'll need to install CygWin first.
Keep in mind that the default install for Postgresql using resources is
very, very conservative. So, you have to change a couple of values in the
config file and that's it.
I like using PgAccess, when I want to view/edit the database with a GUI.
I have Postgres/PgAccess install instructions on my site:
http://daydream.stanford.edu/install_web_services.html
In my opinion, if you can afford Oracle and are a full-time Oracle admin,
or you have a full-time Oracle admin working for you, then you may want to
go with Oracle :)
If you're in a DIY (Do it Yourself) situation, then I highly recommend
Postgresql.
Cheers,
Oscar
On Wed, 29 Oct 2003, David Friedman wrote:
> This article seems very old. A significant portion
> of what they talk about was fixed in the Version 4.0
> of MySQL which has got to be at least 9 months old
> or so.
>
> Regards,
> David
>
> -----Original Message-----
> From: news [mailto:news@sea.gmane.org]On Behalf Of Vic Cekvenich
> Sent: Wednesday, October 29, 2003 12:17 PM
> To: struts-user@jakarta.apache.org
> Subject: was Re: Struts and db access: OT: pgSQL
>
>
> oh and another link
> http://det-dbalice.if.pw.edu.pl/det-dbalice/ttraczyk/db_compare/db_compare.h
> tml
>
> Mark Lowe wrote:
>
> > I didn't know the postgres was faster than oracle.. I agree that its the
> > canine's genitalia .. But I still thought oracle was the daddy when it
> > came to speed. Is that just read access or everything?
> >
> >
> > On Wednesday, October 29, 2003, at 02:52 PM, Vic Cekvenich wrote:
> >
> >> This might confuse you more than help... but it is meant to be helpful.
> >> Look at iBatis.com PetStore 3.
> >>
> >> I use a iBatis DB layer as DAO to pgSQL for a DAO layer.
> >>
> >> And NO Struts does not specify or endorse a certain way to access
> >> data. A formBean maps to a (JSP/HTML) form, and is data agnostic. This
> >> way people can chose.
> >>
> >> (pgSQL rocks!!! Free run time on windows and unix, stored procedure
> >> support, ANSI SQL, faster than Oracle/MS SQL)
> >>
> >> .V
> >>
> >> Steffen Gransow wrote:
> >>
> >>> Hi,
> >>> I am totally new to J2EE/EJB and Struts - so perhaps this is the wrong
> >>> place to ask. In this case I would like to know where I should ask my
> >>> question or what I should've read before again asking silly questions.
> >>> :-)
> >>> I have to use a Sun One Application Server and a PostGreSQL database for
> >>> a project. And I am sure that I want to use Struts because of the whole
> >>> MVC thing. I would like to know how I should access data in a
> >>> appropriate way. I think I want to use CMP and I am wondering where or
> >>> how I should address the database. Do I have to create a JDBC ressource
> >>> on the Sun One Application Server or do I have to define a datasource
> >>> using Struts DataSource manager?
> >>> I thought of something like:
> >>> ------ Controller ------------ Actions
> >>> | (ActionServlet) |
> >>> | | |
> >>> Client ---- | |
> >>> | | |
> >>> | | |
> >>> ------ View (JSPs) - - - - - - Model (Beans) ------ PostGreSQL
> >>> DB
> >>> And on the Model part of this simple ascii art I think it would be nice
> >>> to have something like:
> >>> Action ---
> >>> |
> >>> --- business logic bean ---
> >>> (use a facade?) |
> >>> --- data representaion (entity beans)
> >>> Is this approach okay? Back to my question stated above: How do I get
> >>> the entity beans "connected" to the database? Is struts independent of
> >>> this question? Should I try to do this by reading Sun's AppServer
> >>> documentation? ;)
> >>> Thanks in regards,
> >>> Steffen Gransow
> >>> ----------------
> >>> newbie questioner
> >>
> >>
> >> --
> >> Victor Cekvenich,
> >> Struts Instructor
> >> (215) 321-9146
> >>
> >> Advanced Struts Training
> >> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
> >> training with Rich UI, mentoring, designs, samples and project recovery
> >> in North East.
> >> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
> >> Shopping and Credit processing, <http://basicportal.com> software, ready
> >> to develop/customize; requires a db to run.
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: struts-user-help@jakarta.apache.org
> >>
>
> --
> Victor Cekvenich,
> Struts Instructor
> (215) 321-9146
>
> Advanced Struts Training
> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
> training with Rich UI, mentoring, designs, samples and project recovery
> in North East.
> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
> Shopping and Credit processing, <http://basicportal.com> software, ready
> to develop/customize; requires a db to run.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
RE: was Re: Struts and db access: OT: pgSQL
Posted by David Friedman <hu...@ix.netcom.com>.
This article seems very old. A significant portion
of what they talk about was fixed in the Version 4.0
of MySQL which has got to be at least 9 months old
or so.
Regards,
David
-----Original Message-----
From: news [mailto:news@sea.gmane.org]On Behalf Of Vic Cekvenich
Sent: Wednesday, October 29, 2003 12:17 PM
To: struts-user@jakarta.apache.org
Subject: was Re: Struts and db access: OT: pgSQL
oh and another link
http://det-dbalice.if.pw.edu.pl/det-dbalice/ttraczyk/db_compare/db_compare.h
tml
Mark Lowe wrote:
> I didn't know the postgres was faster than oracle.. I agree that its the
> canine's genitalia .. But I still thought oracle was the daddy when it
> came to speed. Is that just read access or everything?
>
>
> On Wednesday, October 29, 2003, at 02:52 PM, Vic Cekvenich wrote:
>
>> This might confuse you more than help... but it is meant to be helpful.
>> Look at iBatis.com PetStore 3.
>>
>> I use a iBatis DB layer as DAO to pgSQL for a DAO layer.
>>
>> And NO Struts does not specify or endorse a certain way to access
>> data. A formBean maps to a (JSP/HTML) form, and is data agnostic. This
>> way people can chose.
>>
>> (pgSQL rocks!!! Free run time on windows and unix, stored procedure
>> support, ANSI SQL, faster than Oracle/MS SQL)
>>
>> .V
>>
>> Steffen Gransow wrote:
>>
>>> Hi,
>>> I am totally new to J2EE/EJB and Struts - so perhaps this is the wrong
>>> place to ask. In this case I would like to know where I should ask my
>>> question or what I should've read before again asking silly questions.
>>> :-)
>>> I have to use a Sun One Application Server and a PostGreSQL database for
>>> a project. And I am sure that I want to use Struts because of the whole
>>> MVC thing. I would like to know how I should access data in a
>>> appropriate way. I think I want to use CMP and I am wondering where or
>>> how I should address the database. Do I have to create a JDBC ressource
>>> on the Sun One Application Server or do I have to define a datasource
>>> using Struts DataSource manager?
>>> I thought of something like:
>>> ------ Controller ------------ Actions
>>> | (ActionServlet) |
>>> | | |
>>> Client ---- | |
>>> | | |
>>> | | |
>>> ------ View (JSPs) - - - - - - Model (Beans) ------ PostGreSQL
>>> DB
>>> And on the Model part of this simple ascii art I think it would be nice
>>> to have something like:
>>> Action ---
>>> |
>>> --- business logic bean ---
>>> (use a facade?) |
>>> --- data representaion (entity beans)
>>> Is this approach okay? Back to my question stated above: How do I get
>>> the entity beans "connected" to the database? Is struts independent of
>>> this question? Should I try to do this by reading Sun's AppServer
>>> documentation? ;)
>>> Thanks in regards,
>>> Steffen Gransow
>>> ----------------
>>> newbie questioner
>>
>>
>> --
>> Victor Cekvenich,
>> Struts Instructor
>> (215) 321-9146
>>
>> Advanced Struts Training
>> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
>> training with Rich UI, mentoring, designs, samples and project recovery
>> in North East.
>> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
>> Shopping and Credit processing, <http://basicportal.com> software, ready
>> to develop/customize; requires a db to run.
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>>
--
Victor Cekvenich,
Struts Instructor
(215) 321-9146
Advanced Struts Training
<http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
training with Rich UI, mentoring, designs, samples and project recovery
in North East.
Simple best practice basic Portal, a Struts CMS, Membership, Forums,
Shopping and Credit processing, <http://basicportal.com> software, ready
to develop/customize; requires a db to run.
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
was Re: Struts and db access: OT: pgSQL
Posted by Vic Cekvenich <ce...@baseBeans.com>.
oh and another link
http://det-dbalice.if.pw.edu.pl/det-dbalice/ttraczyk/db_compare/db_compare.html
Mark Lowe wrote:
> I didn't know the postgres was faster than oracle.. I agree that its the
> canine's genitalia .. But I still thought oracle was the daddy when it
> came to speed. Is that just read access or everything?
>
>
> On Wednesday, October 29, 2003, at 02:52 PM, Vic Cekvenich wrote:
>
>> This might confuse you more than help... but it is meant to be helpful.
>> Look at iBatis.com PetStore 3.
>>
>> I use a iBatis DB layer as DAO to pgSQL for a DAO layer.
>>
>> And NO Struts does not specify or endorse a certain way to access
>> data. A formBean maps to a (JSP/HTML) form, and is data agnostic. This
>> way people can chose.
>>
>> (pgSQL rocks!!! Free run time on windows and unix, stored procedure
>> support, ANSI SQL, faster than Oracle/MS SQL)
>>
>> .V
>>
>> Steffen Gransow wrote:
>>
>>> Hi,
>>> I am totally new to J2EE/EJB and Struts - so perhaps this is the wrong
>>> place to ask. In this case I would like to know where I should ask my
>>> question or what I should've read before again asking silly questions.
>>> :-)
>>> I have to use a Sun One Application Server and a PostGreSQL database for
>>> a project. And I am sure that I want to use Struts because of the whole
>>> MVC thing. I would like to know how I should access data in a
>>> appropriate way. I think I want to use CMP and I am wondering where or
>>> how I should address the database. Do I have to create a JDBC ressource
>>> on the Sun One Application Server or do I have to define a datasource
>>> using Struts DataSource manager?
>>> I thought of something like:
>>> ------ Controller ------------ Actions
>>> | (ActionServlet) |
>>> | | |
>>> Client ---- | |
>>> | | |
>>> | | |
>>> ------ View (JSPs) - - - - - - Model (Beans) ------ PostGreSQL
>>> DB
>>> And on the Model part of this simple ascii art I think it would be nice
>>> to have something like:
>>> Action ---
>>> |
>>> --- business logic bean ---
>>> (use a facade?) |
>>> --- data representaion (entity beans)
>>> Is this approach okay? Back to my question stated above: How do I get
>>> the entity beans "connected" to the database? Is struts independent of
>>> this question? Should I try to do this by reading Sun's AppServer
>>> documentation? ;)
>>> Thanks in regards,
>>> Steffen Gransow
>>> ----------------
>>> newbie questioner
>>
>>
>> --
>> Victor Cekvenich,
>> Struts Instructor
>> (215) 321-9146
>>
>> Advanced Struts Training
>> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
>> training with Rich UI, mentoring, designs, samples and project recovery
>> in North East.
>> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
>> Shopping and Credit processing, <http://basicportal.com> software, ready
>> to develop/customize; requires a db to run.
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>>
--
Victor Cekvenich,
Struts Instructor
(215) 321-9146
Advanced Struts Training
<http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
training with Rich UI, mentoring, designs, samples and project recovery
in North East.
Simple best practice basic Portal, a Struts CMS, Membership, Forums,
Shopping and Credit processing, <http://basicportal.com> software, ready
to develop/customize; requires a db to run.
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: Struts and db access
Posted by Vic Cekvenich <ce...@baseBeans.com>.
I did read a beanchmark on pgSQL faster vs Oracle et all, now I can't
find the link:
http://advocacy.postgresql.org/advantages/
.V
Mark Lowe wrote:
> I didn't know the postgres was faster than oracle.. I agree that its the
> canine's genitalia .. But I still thought oracle was the daddy when it
> came to speed. Is that just read access or everything?
>
>
> On Wednesday, October 29, 2003, at 02:52 PM, Vic Cekvenich wrote:
>
>> This might confuse you more than help... but it is meant to be helpful.
>> Look at iBatis.com PetStore 3.
>>
>> I use a iBatis DB layer as DAO to pgSQL for a DAO layer.
>>
>> And NO Struts does not specify or endorse a certain way to access
>> data. A formBean maps to a (JSP/HTML) form, and is data agnostic. This
>> way people can chose.
>>
>> (pgSQL rocks!!! Free run time on windows and unix, stored procedure
>> support, ANSI SQL, faster than Oracle/MS SQL)
>>
>> .V
>>
>> Steffen Gransow wrote:
>>
>>> Hi,
>>> I am totally new to J2EE/EJB and Struts - so perhaps this is the wrong
>>> place to ask. In this case I would like to know where I should ask my
>>> question or what I should've read before again asking silly questions.
>>> :-)
>>> I have to use a Sun One Application Server and a PostGreSQL database for
>>> a project. And I am sure that I want to use Struts because of the whole
>>> MVC thing. I would like to know how I should access data in a
>>> appropriate way. I think I want to use CMP and I am wondering where or
>>> how I should address the database. Do I have to create a JDBC ressource
>>> on the Sun One Application Server or do I have to define a datasource
>>> using Struts DataSource manager?
>>> I thought of something like:
>>> ------ Controller ------------ Actions
>>> | (ActionServlet) |
>>> | | |
>>> Client ---- | |
>>> | | |
>>> | | |
>>> ------ View (JSPs) - - - - - - Model (Beans) ------ PostGreSQL
>>> DB
>>> And on the Model part of this simple ascii art I think it would be nice
>>> to have something like:
>>> Action ---
>>> |
>>> --- business logic bean ---
>>> (use a facade?) |
>>> --- data representaion (entity beans)
>>> Is this approach okay? Back to my question stated above: How do I get
>>> the entity beans "connected" to the database? Is struts independent of
>>> this question? Should I try to do this by reading Sun's AppServer
>>> documentation? ;)
>>> Thanks in regards,
>>> Steffen Gransow
>>> ----------------
>>> newbie questioner
>>
>>
>> --
>> Victor Cekvenich,
>> Struts Instructor
>> (215) 321-9146
>>
>> Advanced Struts Training
>> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
>> training with Rich UI, mentoring, designs, samples and project recovery
>> in North East.
>> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
>> Shopping and Credit processing, <http://basicportal.com> software, ready
>> to develop/customize; requires a db to run.
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>>
--
Victor Cekvenich,
Struts Instructor
(215) 321-9146
Advanced Struts Training
<http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
training with Rich UI, mentoring, designs, samples and project recovery
in North East.
Simple best practice basic Portal, a Struts CMS, Membership, Forums,
Shopping and Credit processing, <http://basicportal.com> software, ready
to develop/customize; requires a db to run.
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: Struts and db access
Posted by Mark Lowe <ma...@talk21.com>.
I didn't know the postgres was faster than oracle.. I agree that its
the canine's genitalia .. But I still thought oracle was the daddy when
it came to speed. Is that just read access or everything?
On Wednesday, October 29, 2003, at 02:52 PM, Vic Cekvenich wrote:
> This might confuse you more than help... but it is meant to be helpful.
> Look at iBatis.com PetStore 3.
>
> I use a iBatis DB layer as DAO to pgSQL for a DAO layer.
>
> And NO Struts does not specify or endorse a certain way to access
> data. A formBean maps to a (JSP/HTML) form, and is data agnostic. This
> way people can chose.
>
> (pgSQL rocks!!! Free run time on windows and unix, stored procedure
> support, ANSI SQL, faster than Oracle/MS SQL)
>
> .V
>
> Steffen Gransow wrote:
>> Hi,
>> I am totally new to J2EE/EJB and Struts - so perhaps this is the wrong
>> place to ask. In this case I would like to know where I should ask my
>> question or what I should've read before again asking silly questions.
>> :-)
>> I have to use a Sun One Application Server and a PostGreSQL database
>> for
>> a project. And I am sure that I want to use Struts because of the
>> whole
>> MVC thing. I would like to know how I should access data in a
>> appropriate way. I think I want to use CMP and I am wondering where or
>> how I should address the database. Do I have to create a JDBC
>> ressource
>> on the Sun One Application Server or do I have to define a datasource
>> using Struts DataSource manager?
>> I thought of something like:
>> ------ Controller ------------ Actions
>> | (ActionServlet) |
>> | | |
>> Client ---- | |
>> | | |
>> | | |
>> ------ View (JSPs) - - - - - - Model (Beans) ------
>> PostGreSQL
>> DB
>> And on the Model part of this simple ascii art I think it would be
>> nice
>> to have something like:
>> Action ---
>> |
>> --- business logic bean ---
>> (use a facade?) |
>> --- data representaion (entity
>> beans)
>> Is this approach okay? Back to my question stated above: How do I get
>> the entity beans "connected" to the database? Is struts independent
>> of
>> this question? Should I try to do this by reading Sun's AppServer
>> documentation? ;)
>> Thanks in regards,
>> Steffen Gransow
>> ----------------
>> newbie questioner
>
> --
> Victor Cekvenich,
> Struts Instructor
> (215) 321-9146
>
> Advanced Struts Training
> <http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
> training with Rich UI, mentoring, designs, samples and project recovery
> in North East.
> Simple best practice basic Portal, a Struts CMS, Membership, Forums,
> Shopping and Credit processing, <http://basicportal.com> software,
> ready
> to develop/customize; requires a db to run.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: Struts and db access
Posted by Vic Cekvenich <ce...@baseBeans.com>.
This might confuse you more than help... but it is meant to be helpful.
Look at iBatis.com PetStore 3.
I use a iBatis DB layer as DAO to pgSQL for a DAO layer.
And NO Struts does not specify or endorse a certain way to access data.
A formBean maps to a (JSP/HTML) form, and is data agnostic. This way
people can chose.
(pgSQL rocks!!! Free run time on windows and unix, stored procedure
support, ANSI SQL, faster than Oracle/MS SQL)
.V
Steffen Gransow wrote:
> Hi,
>
> I am totally new to J2EE/EJB and Struts - so perhaps this is the wrong
> place to ask. In this case I would like to know where I should ask my
> question or what I should've read before again asking silly questions.
> :-)
>
> I have to use a Sun One Application Server and a PostGreSQL database for
> a project. And I am sure that I want to use Struts because of the whole
> MVC thing. I would like to know how I should access data in a
> appropriate way. I think I want to use CMP and I am wondering where or
> how I should address the database. Do I have to create a JDBC ressource
> on the Sun One Application Server or do I have to define a datasource
> using Struts DataSource manager?
>
> I thought of something like:
>
>
> ------ Controller ------------ Actions
> | (ActionServlet) |
> | | |
> Client ---- | |
> | | |
> | | |
> ------ View (JSPs) - - - - - - Model (Beans) ------ PostGreSQL
> DB
>
> And on the Model part of this simple ascii art I think it would be nice
> to have something like:
>
> Action ---
> |
> --- business logic bean ---
> (use a facade?) |
> --- data representaion (entity beans)
>
> Is this approach okay? Back to my question stated above: How do I get
> the entity beans "connected" to the database? Is struts independent of
> this question? Should I try to do this by reading Sun's AppServer
> documentation? ;)
>
> Thanks in regards,
>
> Steffen Gransow
>
> ----------------
> newbie questioner
--
Victor Cekvenich,
Struts Instructor
(215) 321-9146
Advanced Struts Training
<http://basebeans.com/do/cmsPg?content=TRAINING> Server Side Java
training with Rich UI, mentoring, designs, samples and project recovery
in North East.
Simple best practice basic Portal, a Struts CMS, Membership, Forums,
Shopping and Credit processing, <http://basicportal.com> software, ready
to develop/customize; requires a db to run.
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org