Hi Willian! Thank you for the example! You tested with a Date-Column, that worked in my application, too, because no conversion between the column and the data object value is necessary.
With DateTime a converter is needed: SDO format: 2006-11-16T17:22 MySQL format: 2006-11-16 17:22 The bigbank sample has a DateConverter for this issue, but this does only work with Derby and not with MySQL. I don't know why. I posted the error last time: http://www.mail-archive.com/[email protected]/msg10725.html It would be great, if you could test again with a DateTime or Timestamp column and tell me your solution. Thanks, Katja -------- Original-Nachricht -------- Datum: Thu, 16 Nov 2006 16:08:48 +0000 Von: "Willian Maja" <[EMAIL PROTECTED]> An: [email protected] Betreff: Re: New proposal to make DAS/SDO HOW TO > Hi Katja, > > I've just tested to read Date column, and it works. I'm going to paste > my code here for you: > > This will be the test table, it's just a simple table with a DateTime > Column. > > CREATE TABLE test (ID integer not null AUTO_INCREMENT, date_column date); > INSERT INTO test (date_column) VALUES ("06-11-16"); > > Now you should create your Das connection. In my code example I'll not use > XML configuration. I'm going to create the Command: > > Command read = das.createCommand("select * from test"); //Create > the > Command > DataObject root = read.executeQuery(); > DataObject row = root.getDataObject("teste[1]"); // Get the first > row from test table; > System.out.println(row.getDate("date_column")); // Print the > DateTime > > > I think this will help you :). > > Bye. > > > > > >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] > > > > _________________________________________________________________ > MSN Busca: fácil, rápido, direto ao ponto. http://search.msn.com.br > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- 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]
