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
|