RE: [dtp-dev] Extending DTP query parser

["David Meng" <dmeng@xxxxxxx>]

Sorry typo: I can't fit in my own OracleSQLLexer class.
 
David
________________________________

From: dtp-dev-bounces@xxxxxxxxxxx [mailto:dtp-dev-bounces@xxxxxxxxxxx]
On Behalf Of David Meng
Sent: Wednesday, June 07, 2006 5:20 PM
To: DTP development mailing list
Subject: [dtp-dev] Extending DTP query parser


Hi Rupesh,
 
I have got some question regarding DTP parser, if I want to extend
generic SQL query parser to support Oracle function e.g. "sysdate", do I
have to extend both parser and lexer? I looked at the code in
org.eclipse.datatools.sqltools.parsers.sql.xml.query, but I did not find
any extension to lexer.
 
Here is what I did:
 
Modify corresponding parser and lexer grammer file and generate the
following parser and lexer classes:
 
OracleSQLQueryParser extends AbstractSQLQueryParser
OracleSQLLexer extends AbstractSQLLexer
 
However in the base class SQLParserManager, the protected method
createLexer() dictates the return type of SQLLexer, in this case, I can
fit in my own OracleSQLLexer class.
 
Another question is why the lexer is put in an separate plug-in instead
of same plugin as the parser, since you need to modify both anyway.
 
Thanks for your help!
 
Regards,
David
________________________________

From: dtp-dev-bounces@xxxxxxxxxxx [mailto:dtp-dev-bounces@xxxxxxxxxxx]
On Behalf Of Rupesh A Kartha
Sent: Wednesday, May 31, 2006 6:25 PM
To: DTP development mailing list
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. 



---------------------------------------------------------------------
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.