From: fredt <fr...@us...> - 2005-05-26 19:20:19
|
I could write some code to collect such data, but this is not in the scop= e=20 of the project. I provide professional support and consultancy services f= or=20 HSQLDB, which you are welcome to use. Regards Fred ----- Original Message -----=20 From: "Ostermueller Erik - eoster" <Eri...@ac...> To: <hsq...@li...> Sent: 26 May 2005 18:11 Subject: RE: [Hsqldb-user] Walking the objects created by the SQL parser. Fred, I'd love to take the approach your suggesting, but it takes 18 hours to run this once-a-month process. We use more than a terabyte for the who thing and use a lot of Oracle-specific features. Not only do I need to answer these questions for what is already coded, I need to answer the same questions for proposed (mostly incremental) designs. So, I plan on modeling the flow of data with an object graph. This is why I need an SQL parser. The bulk of the mappings I'll get from the SELECT lists, which are not oracle specific. --Erik -----Original Message----- From: hsq...@li... [mailto:hsq...@li...] On Behalf Of fredt Sent: Wednesday, May 25, 2005 11:47 AM To: hsq...@li... Subject: Re: [Hsqldb-user] Walking the objects created by the SQL parser. If you only want to find out the data in which columns change, you can put data with distinct values (e.g. Integer.MAX_VALUE) and check the before / after values. Otherwise, Session.execute() contains the top level code that executes various commands by calling different methods. Fred ----- Original Message -----=20 From: "Ostermueller Erik - eoster" <Eri...@ac...> To: <hsq...@li...> Sent: 25 May 2005 16:23 Subject: [Hsqldb-user] Walking the objects created by the SQL parser. Fred and Dan, thanks for your quick replies. My list subscription isn't working quite right, so bear with me if this reply doesn't match the previous ones. Dan wrote: >>If I recall, JavaCC had an SQL grammar that maybe you can adapt.. As kind of parallel effort, I'm working on getting the javacc sql gramar in shape. There is a lot of work to do. For anyone interested, here's the file: http://www.cobase.cs.ucla.edu/pub/javacc/sql-oracle.jj >> Depends on the meaning of "analyze"... I want to answer this question: If you put a data-item into tablex.columny and then process 100 scripts, which data items will be impacted by the change? Quest's 'SQL Impact' approaches this, but only tells you which sql _scripts_ are impacted -- not the names of the columns. Fred wrote: >> Depends on the SQL commands I want object graphs for a bunch of "CREATE TABLE AS SELECT" statements. I can easily submit these w/o the 'CREATE TABLE AS' part. >>The calls go through the Session class, which you >>reuse in your code. If being a newbie weren't bad enough, I'm a little slow. I've looked at the Session class a bit, but I still can't quite tell what you're suggesting. Thanks again, --Erik O. ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ------------------------------------------------------- SF.Net email is sponsored by: GoToMeeting - the easiest way to collaborate online with coworkers and clients while avoiding the high cost of travel and communications. There is no equipment to buy and you can meet as often as you want. Try it free.http://ads.osdn.com/?ad_idt02&alloc_id=16135&op=3Di= ck _______________________________________________ Hsqldb-user mailing list Hsq...@li... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------- SF.Net email is sponsored by: GoToMeeting - the easiest way to collaborate online with coworkers and clients while avoiding the high cost of travel and communications. There is no equipment to buy and you can meet as often as you want. Try it free.http://ads.osdn.com/?ad_idt02&alloc_id=16135&op=3Di= ck _______________________________________________ Hsqldb-user mailing list Hsq...@li... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=3Dfad-ysdn-ostg-q2200= 5 _______________________________________________ Hsqldb-user mailing list Hsq...@li... https://lists.sourceforge.net/lists/listinfo/hsqldb-user=20 |