RE: [dtp-dev] DTP 0.9 RC5 5/31 build

[Hui.Cao@xxxxxxxxxx]

Hi David,
        The
JavaCC parser is used in DTP to do content assist and syntax validation.
Syntax highlighting is a simple feature and does not need a parser. Semantic
validation is more complicated than syntax validation in that it requires
embeded java code in the JavaCC parser. JavaCC's JJTree feature allows
you to build AST a tree by parsing, so you can get the parameters or other
information. The problem of the current resulting AST tree is that it is
not compliant with the SQL query model, but this will change along with
the generic SQL parser API.
        The
fact that we use two parsers is because we want to accommodate existing
sql parsers as much as possible. If you have an existing sql parser using
a particular parser generator technology, you don't want to rewrite it
in the official or designated parser technology, right? So the generic
sql parser API will help us to achieve this goal. DTP will only interact
with the parser using the generic parser API, no matter what the underlying
parser it is.
        Hope
that helps!

Best Regards!

Max ( Hui ) Cao
DTP SQL Dev Tools Committer
Sr S/W Eng - Dev
Sybase, Inc. Shanghai, China

"David Meng" <dmeng@xxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

06/01/2006 11:17 PM

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>

To	"DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
cc
Subject	RE: [dtp-dev] DTP 0.9 RC5 5/31 build

Hi Max,
 
Thanks for your input, however
I am a little confused about the fact that we use two different parsers
(JavaCC, LPG) in the framework, why don't we just use one parser?
 
I read the EclipseCon tutorials,
if I understand correctly, JavaCC is used only for content assist and syntax
highlighting etc. whereas LPG is more powerful and flexible, it supports
semantic validation and also generates QueryStatement which I can use to
extract parameters and result columns information (this is very important
to me). So I am confused at the point as to which parser I should extend,
JavaCC or LPG? Does JavaCC parser also provide the similar function as
LPG?
 
One last question, is IBM LPG
parser used in the devtools the same as open source as http://sourceforge.net/projects/lpg,
because I am little concern about the license issue with IBM parser.
 
David

---

From: dtp-dev-bounces@xxxxxxxxxxx
[mailto:dtp-dev-bounces@xxxxxxxxxxx] On Behalf Of Hui.Cao@xxxxxxxxxx
Sent: Thursday, June 01, 2006 4:10 AM
To: DTP development mailing list
Subject: Re: [dtp-dev] DTP 0.9 RC5 5/31 build


Hi David, 
        Just a reminder that currently only JavaCC
parser is integrated with the DTP editor framework. You can check out the
EclipseCon 2006 DTP tutorial slides for details about how to contribute
your own parser: http://eclipsezilla.eclipsecon.org/php/attachment.php?bugid=130

Best Regards!

Max ( Hui ) Cao
DTP SQL Dev Tools Committer
Sr S/W Eng - Dev
Sybase, Inc. Shanghai, China

"David Meng" <dmeng@xxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

06/01/2006 08:00 AM

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>

To	<dtp-dev@xxxxxxxxxxx>
cc
Subject	Re: [dtp-dev] DTP 0.9 RC5 5/31 build

Hi Rupesh,

Thank you very much for your suggestion, I am really apprecite.

David
--------------------------
Sent from my BlackBerry Wireless Handheld


-----Original Message-----
From: dtp-dev-bounces@xxxxxxxxxxx <dtp-dev-bounces@xxxxxxxxxxx>
To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
Sent: Wed May 31 18:24:59 2006
Subject: RE: [dtp-dev] DTP 0.9 RC5 5/31 build

Hi David
Thanks for your interest.A common parser API (for callers to work with
any parser) is planned in the next release of DTP (post DTP 0.9 ). Changes
are expected in the current parser and its extension mechanism as well
. I think it is will be good to get involved and start with the extension
when this work begins. 

At present, there is no documentation on extending the parser.If interested
you can look at .lpg files in org.eclipse.datatools.sqltools.parsers.sql.xml.query
plugin to get an idea of the grammar. This plugin can be thought of an
extension of the query parser (org.eclipse.datatools.sqltools.parsers.sql.query)
to support the SQL/XML functions.An Oracle dialect extension will be similar.
 LPG is opensource at http://sourceforge.net/projects/lpg

Thanks,

Rupesh Kartha,
Phone: 408 463 5804 T/L - 543 5804
Fax: 408 463 3834 T/L- 543 3834
Email: rkartha@xxxxxxxxxx

"David Meng" <dmeng@xxxxxxx>




                    
                     
                     
  "David Meng" <dmeng@xxxxxxx> 
                    
                     
                     
  Sent by: dtp-dev-bounces@xxxxxxxxxxx 

                    
                     
                     
  05/31/2006 11:06 AM 
                    
                     
                     
                     
                     
                     
    Please respond to
                    
                     
                     
  DTP development mailing list <dtp-dev@xxxxxxxxxxx>
                    
                     
                     
                   



To
                
"DTP development mailing list" <dtp-dev@xxxxxxxxxxx>  
              


cc
                
                


Subject
                
RE: [dtp-dev] DTP 0.9 RC5 5/31 build          
      
                    
            

Hi,

I need to extend DTP SQL parser to support Oracle dialect, can anyone
give some suggestion on how to do this? Or is there any example or
tutorial on this? ,thank a lot in advance.

David

-----Original Message-----
From: dtp-dev-bounces@xxxxxxxxxxx [mailto:dtp-dev-bounces@xxxxxxxxxxx]
On Behalf Of jograham@xxxxxxxxxx
Sent: Wednesday, May 31, 2006 12:17 PM
To: dtp-dev@xxxxxxxxxxx
Subject: [dtp-dev] DTP 0.9 RC5 5/31 build


The DTP 0.9 RC5 5/31 build is now available on the download site.

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/

_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev



---------------------------------------------------------------------
This transmission (including any attachments) may contain confidential
information, privileged material (including material protected by the solicitor-client
or other applicable privileges), or constitute non-public information.
Any use of this information by anyone other than the intended recipient
is prohibited. If you have received this transmission in error, please
immediately reply to the sender and delete this information from your system.
Use, dissemination, distribution, or reproduction of this transmission
by unintended recipients is not authorized and may be unlawful.
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev





---------------------------------------------------------------------
This transmission (including any attachments) may contain confidential
information, privileged material (including material protected by the solicitor-client
or other applicable privileges), or constitute non-public information.
Any use of this information by anyone other than the intended recipient
is prohibited. If you have received this transmission in error, please
immediately reply to the sender and delete this information from your system.
Use, dissemination, distribution, or reproduction of this transmission
by unintended recipients is not authorized and may be unlawful.
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev

---

This transmission (including any attachments) may contain
confidential information, privileged material (including material protected
by the solicitor-client or other applicable privileges), or constitute
non-public information. Any use of this information by anyone other than
the intended recipient is prohibited. If you have received this transmission
in error, please immediately reply to the sender and delete this information
from your system. Use, dissemination, distribution, or reproduction of
this transmission by unintended recipients is not authorized and may be
unlawful._______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev