| Kiran
See reply inline. 1.how can we change the name and version of database side by the profilename
In most cases the JDBCConnection handle this well. JDBCConnection.getProviderName() wud need to be overridden to provide the name that is displayed on DSE. JDBCConnection.getProviderVersion() for dealing with Version in a vendor specific way. 3.how can we add new child (Triggers)under database as a parent?
Get EMF/Ecore editor installed in your Eclipse. Import org.eclipse.datatools.modelbase / plugins / org.eclipse.datatools.modelbase.derby project into your workspace Open model/derby.ecore in the Ecore editor See how Synonym is added to Schema. Do similar bits for Trigger for your model to bring it to Schema
Following links are useful
4.how can we remove the trigger child under the table as parent and how to add the trigger to the schemas?
I am not cent percent sure on this; but hypothetically you may have to extend Table class and override getTriggers() to return null or empty list. I will leave experts to comment further on this.
Anthos
On 10/26/06, dtp-dev-request@xxxxxxxxxxx <dtp-dev-request@xxxxxxxxxxx > wrote: Send dtp-dev mailing list submissions to
dtp-dev@xxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
https://dev.eclipse.org/mailman/listinfo/dtp-dev
or, via email, send a message with subject or body 'help' to
dtp-dev-request@xxxxxxxxxxx
You can reach the person managing the list at
dtp-dev-owner@xxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of dtp-dev digest..."
Today's Topics:
1. Oda XML driver build timestamp changed. (Lin Zhu)
2. Re: Adhoc sql editor (Hui.Cao@xxxxxxxxxx)
3. Oda Flatfile driver build timestamp changed. (Lin Zhu)
4. Re: Adhoc sql editor (jograham@xxxxxxxxxx )
----------------------------------------------------------------------
Message: 1
Date: Wed, 25 Oct 2006 22:33:47 -0700
From: "Lin Zhu" <lzhu@xxxxxxxxxxx >
Subject: [dtp-dev] Oda XML driver build timestamp changed.
To: "DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
Message-ID:
< 21E318EED90BEE42BDA27AC8FED5D28009837978@xxxxxxxxxxxxxxxxxxxxx>
Content-Type: text/plain; charset="us-ascii"
The timestamp of org.eclipse.datatools.enablement.oda.xml.tests has been
changed to 1.0.0.200610261.
Thanks!
Lin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eclipse.org/pipermail/dtp-dev/attachments/20061026/862e5a9d/attachment.html
------------------------------
Message: 2
Date: Thu, 26 Oct 2006 14:48:16 +0800
From: Hui.Cao@xxxxxxxxxx
Subject: Re: [dtp-dev] Adhoc sql editor
To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
Message-ID:
< OF9883983B.835AFF7E-ON48257213.00251F88-48257213.002560BE@xxxxxxxxxx>
Content-Type: text/plain; charset="us-ascii"
Hi John,
Do you mean you can't "Execute selected text" or "Execute All" in
SQL Editor? If so, this is apparently a bug and I'll look into it ASAP. Do
you have the BZ number?
Best Regards!
Max ( Hui ) Cao
Sybase, Inc. Shanghai, China
jograham@xxxxxxxxxx
10/25/2006 11:50 PM
To
DTP development mailing list <dtp-dev@xxxxxxxxxxx>
cc
Subject
Re: [dtp-dev] Adhoc sql editor
I think there is a real need to have a component in DTP that allows for
simple, ad-hoc queries against a database connection profile. Most likely
this would be a view exposing the same functionality as today's SQL
Editor,
but without the need to associate it with a file in any manner. (Of
course,
having the ability to save the contents into a file would be great too.)
Also, I notice in recent builds that it is becoming harder to simply
create
a sql file and try out some queries. Whereas before I could "Execute
selected text" or "Execute All" on the editor context menu, now we
apparently have to set a "adhoc sql" launch configuration, which is a lot
more trouble.
I'd like to ask that the SQL Dev team considers these issues along with
community input to get a resolution in the 1.0 time frame.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/
Hui.Cao@xxxxxxxxx
m
Sent by: To
dtp-dev-bounces@e DTP development mailing list
clipse.org < dtp-dev@xxxxxxxxxxx>
cc
10/25/2006 12:25 Subject
AM Re: [dtp-dev] Adhoc sql editor
Please respond to
DTP development
mailing list
<dtp-dev@eclipse.
org>
Hi Anthos,
The sqlscrapbook plugin name is misleading. Although it's named
"scrapbook", in fact it's handling sql files. This name comes from WTP RDB
when we align with RDB efforts during the initial stage of DTP. It should
be renamed to sqlfileeditor instead. Please open a bug entry for this
problem.
Back to your question, to open a sql editor which is not backed by
a file, you can use SQLEditor with an instance of
SQLEditorStorageEditorInput.
Best Regards!
Max ( Hui ) Cao
Sybase, Inc. Shanghai, China
Anil Samuel <anil.samuel@xxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx
To
dtp-dev@eclip
10/25/2006 11:40 AM se.org
cc
Please respond to Subject
DTP development mailing list [dtp-dev]
<dtp-dev@xxxxxxxxxxx> Adhoc sql
editor
Hi
How do I open a (ScrapbookEditor) SQL Editor to edit a adhoc/dynamically
generated SQL ?
The ScrapbookEditorInput class is internal; so not available to external
plugins.
Note that the editor is not backed by a IFile instance when it is
started. Also should let user to save as usual.
Regards
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eclipse.org/pipermail/dtp-dev/attachments/20061026/9eb4afb5/attachment.html
------------------------------
Message: 3
Date: Thu, 26 Oct 2006 03:28:01 -0700
From: "Lin Zhu" < lzhu@xxxxxxxxxxx>
Subject: [dtp-dev] Oda Flatfile driver build timestamp changed.
To: "DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
Message-ID:
<21E318EED90BEE42BDA27AC8FED5D280098379A9@xxxxxxxxxxxxxxxxxxxxx>
Content-Type: text/plain; charset="us-ascii"
The timestamp of org.eclipse.datatools.enablement.oda.xml.tests has been
changed to 3.0.3.200610261.
Thanks!
Lin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eclipse.org/pipermail/dtp-dev/attachments/20061026/cb1f313b/attachment.html
------------------------------
Message: 4
Date: Thu, 26 Oct 2006 11:23:47 -0400
From: jograham@xxxxxxxxxx
Subject: Re: [dtp-dev] Adhoc sql editor
To: DTP development mailing list < dtp-dev@xxxxxxxxxxx>
Message-ID:
<OF08E57D65.828AEED4-ON85257213.005479B6-85257213.00549354@xxxxxxxxxx>
Content-Type: text/plain; charset=US-ASCII
Hi Hui:
Yes, that what I mean. I've entered the following bug for it:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=162243
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/
Hui.Cao@xxxxxxxxx
m
Sent by: To
dtp-dev-bounces@e DTP development mailing list
clipse.org <dtp-dev@xxxxxxxxxxx>
cc
10/26/2006 02:48 Subject
AM Re: [dtp-dev] Adhoc sql editor
Please respond to
DTP development
mailing list
<dtp-dev@eclipse.
org>
Hi John,
Do you mean you can't "Execute selected text" or "Execute All" in
SQL Editor? If so, this is apparently a bug and I'll look into it ASAP. Do
you have the BZ number?
Best Regards!
Max ( Hui ) Cao
Sybase, Inc. Shanghai, China
jograham@xxxxxxxxxx
10/25/2006 11:50 PM To
DTP development mailing list
< dtp-dev@xxxxxxxxxxx>
cc
Subject
Re: [dtp-dev] Adhoc sql editor
I think there is a real need to have a component in DTP that allows for
simple, ad-hoc queries against a database connection profile. Most likely
this would be a view exposing the same functionality as today's SQL Editor,
but without the need to associate it with a file in any manner. (Of course,
having the ability to save the contents into a file would be great too.)
Also, I notice in recent builds that it is becoming harder to simply create
a sql file and try out some queries. Whereas before I could "Execute
selected text" or "Execute All" on the editor context menu, now we
apparently have to set a "adhoc sql" launch configuration, which is a lot
more trouble.
I'd like to ask that the SQL Dev team considers these issues along with
community input to get a resolution in the 1.0 time frame.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/
Hui.Cao@xxxxxxxxx
m
Sent by: To
dtp-dev-bounces@e DTP development mailing list
clipse.org <dtp-dev@xxxxxxxxxxx>
cc
10/25/2006 12:25 Subject
AM Re: [dtp-dev] Adhoc sql editor
Please respond to
DTP development
mailing list
<dtp-dev@eclipse.
org>
Hi Anthos,
The sqlscrapbook plugin name is misleading. Although it's named
"scrapbook", in fact it's handling sql files. This name comes from WTP RDB
when we align with RDB efforts during the initial stage of DTP. It should
be renamed to sqlfileeditor instead. Please open a bug entry for this
problem.
Back to your question, to open a sql editor which is not backed by
a file, you can use SQLEditor with an instance of
SQLEditorStorageEditorInput.
Best Regards!
Max ( Hui ) Cao
Sybase, Inc. Shanghai, China
Anil Samuel < anil.samuel@xxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx
To
dtp-dev@eclip
10/25/2006 11:40 AM se.org
cc
Please respond to Subject
DTP development mailing list [dtp-dev]
<dtp-dev@xxxxxxxxxxx> Adhoc sql
editor
Hi
How do I open a (ScrapbookEditor) SQL Editor to edit a adhoc/dynamically
generated SQL ?
The ScrapbookEditorInput class is internal; so not available to external
plugins.
Note that the editor is not backed by a IFile instance when it is
started. Also should let user to save as usual.
Regards
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
End of dtp-dev Digest, Vol 15, Issue 22
***************************************
--
Thanks
Kiran _______________________________________________ dtp-dev mailing list
|
