| Hi Larry
My intention is to expose Oracle specific database objects on the DSE. org.eclipse.datatools.modelbase.dbdefinition.DatabaseVendorDefinition seems to have getters for Schema, Sequence, Udt etc. and these objects currently appear on DSE; So I thought this would be the starting point to extend to create Oracle specific DatabaseVendorDefinition and have specific objects like Materialized Views.
Or should I be extending org.eclipse.datatools.modelbase.sql.schema.Schema ? I have already tried it; but didnot get any far.
Regards Anthos
On 23/05/2006, at 4:44 AM, Lawrence E Dunnell wrote:
Anil,
The SQL Model and the DBDefinitions are actually two different models. What Brian was describing below refers to extending the SQL Model. The dbdefintion model is not intended to be extended but instead specific instances of the model are created for each vendor and version. The purpose of the dbdefinition is to store metadata about each vendor's database such as the datatypes supported, identifier lengths, etc.
There are two methods for creating an instance of the dbdefinition: 1) The method described in the whitepaper on the DTP website involves programmatically instantiating an instance of the dbdefinition model and setting the values, then saving the instance of the model or 2) just copy an existing dbdefinition model instance and hand edit it in a text editor so that it reflects the values of the database you are adding support for (this is the method used to create the existing dbdefinitions.) Many of the properties in the dbdefinition model have default values so all of the properties are not reflected in each dbdefinition instance. You'll need to look at the dbdefinition model to see all the properties supported.
The dbdefinition model is in org.eclipse.datatools.modelbase.dbdefinition. The individual instances of the model are in org.eclipse.datatools.connectivity.dbdefinition.*.
The SQL model lives in org.eclipse.datatools.modelbase.sql. And currently the only extention of the model lives in org.eclipse.datatools.modelbase.derby.
Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx
Hi
Could someone please explain how-to generate the code found in org.eclipse.datatools.connectivity.dbdefinition.oracle plugin ? I did have a look at the build scripts; but unable to figure out how .ecore and .genmodels are used for this purpose.
Regards
Anthos
On 5/19/06, Anil Samuel <anil.samuel@xxxxxxxxx> wrote:
Do you recommend any book ? I saw few on Amazon but the reviews didnot look that good.
back to the topic, meanwhile I like to get ahead with the model creation. So once Ihave the .ecore and .genmodel that extend from SQLModel, how do I generate the
artifacts found in plugins/org.eclipse.datatools.connectivity.dbdefinition.oracle_*/ ? especially runtime/vendor/ stuff.
Thanks again & Regards
Anthos
On 5/19/06, brian.fitzpatrick@xxxxxxxxxx < brian.fitzpatrick@xxxxxxxxxx> wrote:
Hi Anthos,
Not necessarily, you can create a new ecore that references the SQL Model
ecore file and then create a genmodel file and create it that way. It's a
little tricky with EMF, but there are some good EMF books out now that
should help you to go that route. The SQL Model folks like to use Rational
Rose. But it's not the only way.
Good luck!
"Anil Samuel"
<anil.samuel@gmai
l.com> To
Sent by: "DTP development mailing list"
dtp-dev-bounces@e <dtp-dev@xxxxxxxxxxx>
clipse.org cc
Subject
05/18/2006 09:05 Re: [dtp-dev] Add more nodes to
PM Schema tree node
Please respond to
DTP development
mailing list
<dtp-dev@eclipse.
org>
Hi Brian
Do I need to use Rational Rose to modify the Rose model to extend the SQL
Model's ecore EMF model definition ?
Regards
Anthos
On 2/4/06, brian.fitzpatrick@xxxxxxxxxx < brian.fitzpatrick@xxxxxxxxxx>
wrote:
Hi Anthos...
If you take a look at these two links, you'll see some code that provides
a
basic example of extending the model and adding your own objects to the
tree. I recently had to go through this process myself for one of the
Sybase databases.
http://www.eclipse.org/datatools/project_modelbase/modelbase_doc/EclipseWorld/EclipseWorld_701_Building_with_the_Data_Tools_project.ppt
http://www.eclipse.org/downloads/download.php?file=/datatools/downloads/eclipseworld05/DTP_EclipseWorld.zip
Basically it amounts to doing a few things...
1) Extending the base SQL Model's ecore EMF model definition and
generating
your own model extensions.
2) Creating a catalog loader (like Larry's suggesting).
3) Creating logical containment elements to add the new elements to the
view (logical containment extension point)
4) Creating navigator content extensions to put new elements in the tree
(along with the new node IVirtualNode classes)
5) Adding a label service (extension point) to contribute icons for those
nodes.
Hopefully the EclipseWorld example will help.
Brian Fitzpatrick
Senior Software Engineer/DTP Committer
Sybase, Inc.
Anil Samuel
<anil.samuel@gmai
l.com>
To
Sent by: DTP development mailing list
dtp-dev-bounces@e <dtp-dev@xxxxxxxxxxx>
clipse.org
cc
Subject
02/03/2006 03:38 Re: [dtp-dev] Add more nodes to
PM Schema tree node
Please respond to
DTP development
mailing list
<dtp-dev@eclipse.
org>
Thanks Larry. How about if I want to add nodes that are currently not
there
?
Anthos
On 2/4/06, Lawrence E Dunnell < ledunnel@xxxxxxxxxx > wrote:
The nodes already exist in the view, the model just needs to be
populated
so that the Triggers and Indexes will be displayed. The triggers and
indexes are currently displayed under the node of the associated table.
Larry Dunnell
Internet address: ledunnel@xxxxxxxxxx
Anil Samuel < anil.samuel@xxxxxxxxx
>
Sent by:
dtp-dev-bounces@xxxxxxxxxxx To
DTP development mailing
list
<dtp-dev@xxxxxxxxxxx >
02/02/2006 05:34 PM cc
Subject
Please respond to Re: [dtp-dev] Add more
nodes
DTP development mailing list < to Schema tree node
dtp-dev@xxxxxxxxxxx >
I am bit puzzled to tell you that I dont see any much code in
DerbyCatalogProvider which would add more nodes to the view.
http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.datatools.connectivity/plugins/org.eclipse.datatools.connectivity.derby/src/org/eclipse/datatools/connectivity/internal/derby/catalog/DerbyCatalogProvider.java?rev=HEAD&cvsroot=Datatools_Project&content-type=text/vnd.viewcvs-markup
Should I be using public void
setInitializationData(IConfigurationElement
config, String propertyName, Object data) method ?
Anthos _______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
--
Anil Samuel <anil.samuel@xxxxxxxxxx >
Principal Technical Member
Product Development
Oracle Corporation _______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
--
Anil Samuel < anil.samuel@xxxxxxxxxx>
Principal Technical Member
Product Development
Oracle Corporation
--
Anil Samuel <anil.samuel@xxxxxxxxxx>
Principal Technical Member
Product Development
Oracle Corporation _______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________ dtp-dev mailing list
|
