Eclipse Community Forums: DTP » How to go about a DDL parser

Home » Eclipse Projects » DTP » How to go about a DDL parser

How to go about a DDL parser [message #51603]

Wed, 19 November 2008 11:01

Eclipse User

I'm new to the DTP project. I scan the newsgroups and other resources
and it is confusing.
In the articles
( http://www.eclipse.org/datatools/project_modelbase/modelbase _doc/DTP%20Modelbase%20White%20paper.htm)
it shows that there is an extension point that will create a DDL parser
but I can not find the extension point.

In other article
( http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/SQL%20Query%20Parser%20User%20documentation.htm)
I found code that parses SQL commands but not the "CREATE" command.
Does some one have sample code (plugin) that will parse DDL?

I saw few newsgroup entries talking about getting the EMF model of the
DDL but no reference to how to go about doing it.

In my current project I need to create a list of tables and columns that
are created by the DDL. I would like to use the DTP to shorten the
development time of a parser.

Any help?

Thanks
Yigal

Re: How to go about a DDL parser [message #52232 is a reply to message #51603]

Mon, 12 January 2009 18:40

Eclipse User

Yigal,

The DDL parser extension point mentioned in the first article is defined
in plugin org.eclipse.datatools.connectivity.sqm.core. See plugin
org.eclipse.datatools.connectivity.apache.derby for an example of a
plugin that implements the interfaces defined in sqm.core.

The second article describes a parser that is focused on parsing DML
rather than DDL. It can be extended to parse DDL statements, but it
would take some work.

Regards,
Brian Payton
SQL and XQuery Tools Development
IBM Information Management

Yigal wrote:
> I'm new to the DTP project. I scan the newsgroups and other resources
> and it is confusing.
> In the articles
> ( http://www.eclipse.org/datatools/project_modelbase/modelbase _doc/DTP%20Modelbase%20White%20paper.htm)
> it shows that there is an extension point that will create a DDL parser
> but I can not find the extension point.
>
> In other article
> ( http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/SQL%20Query%20Parser%20User%20documentation.htm)
> I found code that parses SQL commands but not the "CREATE" command.
> Does some one have sample code (plugin) that will parse DDL?
>
> I saw few newsgroup entries talking about getting the EMF model of the
> DDL but no reference to how to go about doing it.
>
> In my current project I need to create a list of tables and columns that
> are created by the DDL. I would like to use the DTP to shorten the
> development time of a parser.
>
> Any help?
>
> Thanks
> Yigal

Re: How to go about a DDL parser [message #594204 is a reply to message #51603]

Mon, 12 January 2009 18:40

Eclipse User

Previous Topic:	question about add predefined data type
Next Topic:	sql server 2005 error only with data:sample contents

Goto Forum:

-=] Back to Top [=-

Current Time: Thu May 01 05:17:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter