From: "Katja" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: New proposal to make DAS/SDO HOW TO
Date: Thu, 16 Nov 2006 09:14:28 +0100
Hi!
Is it possible to add a Timestamp or DateTime column to the database? I am
very interested in how to access these columns with DAS and MySQL because I
have not succeeded in doing this.
Thanks,
Katja
-------- Original-Nachricht --------
Datum: Thu, 16 Nov 2006 03:44:18 -0400
Von: "Adriano Crestani" <[EMAIL PROTECTED]>
An: [email protected]
Betreff: Re: New proposal to make DAS/SDO HOW TO
> Willian, I created these tables, that will possible be used in the
> shopping
> cart app. It's simple, but I think a howto sample must be simple. And if
> you
> want to add anything, feel free ; )
>
> CREATE TABLE CART (
> ID INTEGER,
> PRIMARY KEY (ID)
> );
>
> CREATE TABLE ITEM (
> ID INTEGER,
> ITEM VARCHAR(30),
> UNITS INTEGER,
> CART_ID INTEGER,
> PRIMARY KEY (ID),
> FOREIGN KEY (CART_ID) REFERENCES CART(ID)
> );
>
>
>
> On 11/16/06, Luciano Resende <[EMAIL PROTECTED]> wrote:
> >
> > Hey Guys
> >
> > Very good to see some progress and some contents being generated. I
> > agree
> > with you guys when you say this is becoming more like a user guide,
> > instead
> > of a How To, and building it describing a new scenario would probably
> make
> > things more clear, altough let's try to keep it simple on the
beginning,
> > otherwise we are going to get a White paper :)
> >
> > I think we should describe actions that you would take when trying
to
> > create an application and describe how you would do it (e.g Now we
need
> to
> > execute a query to read the list of products, and this is how you
would
> do
> > using DAS), and point the user to further documentation in case it
> > needs/want to know more about the specific feature (e.g if they want
to
> > learn the whole syntax/xsd of the das config file).
> >
> > I think couple things should not be covered on the How to :
> > - How to build a war file
> > - How to create a database (altough you might provide the SQL
> > statements to create the tables you would use or at least describe the
> DB
> > schema)
> >
> > Now, talking about what should be in this how-to
> > - We could start very simple... 1 product table, and one simple
> jsp
> > that gives you a list of the products available
> > - Using MySQL is good, altough this how to should not really be
> > database dependent, right ? we could point it to any database, and you
> > guys
> > could maybe elaborate on what change would be necessary to do this :)
> >
> > Also, I think this how to does not necessarily need to produce a
> > working
> > application, as it's intended to show how people would use DAS. If we
> want
> > to spend time creating an application, I'd suggest doing this as
another
> > task, and finish the one I have started as part of
> > http://issues.apache.org/jira/browse/TUSCANY-800
> >
> > Let me know if you have any further questions... let's continue to
> > updating
> > the wiki, and please let me know when you guys want me to take a look
> and
> > provide a feedback on the contents...
> >
> > BTW, others are welcome to voice their opinion on what direction we
> should
> > take here...
> >
> >
> > - Luciano Resende
> > Apache Tuscany
> >
> >
> > On 11/15/06, Adriano Crestani <[EMAIL PROTECTED]> wrote:
> > >
> > > I've decribed the XML configuration file, but it's still looking
like
> a
> > > user
> > > guide than a howto. I think the CompanyWeb sample is to simple and
> > doesn't
> > > cover well all the DAS features. So lets make this Shopping Cart
> > > application
> > > trying to use all the DAS features. Then we will be able to do a
very
> > > useful
> > > howto.
> > >
> > > My propose is that this app must have at least:
> > >
> > > - 1 functionality that requires a SQL command with arguments.
> Then
> > we
> > > cover how to deal with arguments in SQL commands.
> > >
> > > - 1 table that has one autoincrement key column to cover the
> > > "genarated"
> > > attribute on the howto.
> > >
> > > - 1 table that requires a concurrency control to cover the
> > > "concurrency"
> > > attribute on the howto.
> > >
> > > - 1 table containing a foreign key to cover how to explicit in
the
> > XML
> > > configuration file the link between two tables. There will probabily
> be
> > a
> > > foreign key in its database anyway. ; )
> > >
> > > I think also a good idea to use the MySql as the database server,
once
> > > it's
> > > the most used server on webapps ; )
> > >
> > > We must discuss how will be the Shopping Cart GUI, it must be simple
> > once
> > > it's not the focus of our howto. I think a simple html genarated by
a
> > jsp
> > > is
> > > enough. ; )
> > >
> > > Adriano Crestani
> > >
> > > On 11/15/06, Willian Yabusame Maja <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Hello Tuscany Community!
> > > >
> > > > Adriano Crestani and I are working together on a HelloWorld
DAS
> > "How
> > > > To". I have uploaded what we have done so far to
> > > >
> > >
> >
>
http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/RDBDAS_HOWTO_HelloDASApp
> > > >
> > > > We were using the CompanyWeb sample application to make this
> > > > step-by-step how-to and teach how to use the DAS/SDO Features. We
> are
> > > not
> > > > liking what this is becoming, as it's looking more like a
> > > user-gide/readme
> > > > then really a how-to, so we would like to do a new proposal :
> > > >
> > > > Use the scenario of a Shopping cart, and use it to explain
more
> > > about
> > > > how to build it using DAS to handle the persistence part of the
> app...
> > > >
> > > > The topics would be:
> > > > Introducing the scenario and the motivation to use DAS/SDO
> > > > Initial Setup and environment assumptions
> > > > Building the application
> > > > - database
> > > > - DAS commands
> > > > - Configuring the XML and how to make the commands
> > > > Explain the DAS/SDO and how to read/get results
> > > > conclusion
> > > >
> > > >
> > > > Before we change our path to this new approach, we would like
to
> > > hear
> > > > some feedback on what you guys think about this new approach....
> > > >
> > > > Willian Yabusame Maja
> > > >
> > >
> > >
> >
> >
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
