Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Executing SQL programmatically
Executing SQL programmatically [message #25149] Tue, 09 January 2007 09:02 Go to next message
Gunnar Wagenknecht is currently offline Gunnar WagenknechtFriend
Messages: 486
Registered: July 2009
Location: San Francisco ✈ Germany
Senior Member

Hi!

I'm in the process of migrating from WTP to DTP. The problem is that
some easy to use API seems to be missing for connecting to a database
and executing some sql statements contained in a file.

Any ideas where I should start looking? I don't want to start messing
around with profile name or ids or other sort of settings. In WTP I had
a ConnectionSelectionDialog which I could use to obtain a ConnectionInfo
just having a Shell.

Cu, Gunnar

--
Gunnar Wagenknecht
gunnar@wagenknecht.org
http://wagenknecht.org/
Re: Executing SQL programmatically [message #25230 is a reply to message #25149] Wed, 10 January 2007 20:04 Go to previous messageGo to next message
Rob Cernich is currently offline Rob CernichFriend
Messages: 56
Registered: July 2009
Member
Created BZ entry 170130 for this. Will target for the Europa release.

Regards,
Rob
Re: Executing SQL programmatically [message #25310 is a reply to message #25149] Thu, 11 January 2007 02:59 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: hcao.sybase.com

Hi Gunnar,
In DTP, there's a similiar ConnectionInfoDialog which can give you an
instance of ISQLEditorConnectionInfo. This dialog can be invoked via the
context menu "Set connection info" and the ISQLEditorConnectionInfo object
will be associated with the sql file. Is this what you're looking for?

Regards,
Max (Hui) Cao
Sybase Inc.

"Gunnar Wagenknecht" <gunnar@wagenknecht.org> wrote in message
news:envlmo$vqv$1@utils.eclipse.org...
> Hi!
>
> I'm in the process of migrating from WTP to DTP. The problem is that
> some easy to use API seems to be missing for connecting to a database
> and executing some sql statements contained in a file.
>
> Any ideas where I should start looking? I don't want to start messing
> around with profile name or ids or other sort of settings. In WTP I had
> a ConnectionSelectionDialog which I could use to obtain a ConnectionInfo
> just having a Shell.
>
> Cu, Gunnar
>
> --
> Gunnar Wagenknecht
> gunnar@wagenknecht.org
> http://wagenknecht.org/
Re: Executing SQL programmatically [message #25467 is a reply to message #25310] Thu, 11 January 2007 20:04 Go to previous message
Gunnar Wagenknecht is currently offline Gunnar WagenknechtFriend
Messages: 486
Registered: July 2009
Location: San Francisco ✈ Germany
Senior Member

Hui Cao wrote:
> In DTP, there's a similiar ConnectionInfoDialog which can give you an
> instance of ISQLEditorConnectionInfo. This dialog can be invoked via the
> context menu "Set connection info" and the ISQLEditorConnectionInfo object
> will be associated with the sql file. Is this what you're looking for?

Yes, probably. I'll comment in bug 170130.

Cu, Gunnar

--
Gunnar Wagenknecht
gunnar@wagenknecht.org
http://wagenknecht.org/
Re: Executing SQL programmatically [message #583864 is a reply to message #25149] Wed, 10 January 2007 20:04 Go to previous message
Rob Cernich is currently offline Rob CernichFriend
Messages: 56
Registered: July 2009
Member
Created BZ entry 170130 for this. Will target for the Europa release.

Regards,
Rob
Re: Executing SQL programmatically [message #583894 is a reply to message #25149] Thu, 11 January 2007 02:59 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 29
Registered: July 2009
Junior Member
Hi Gunnar,
In DTP, there's a similiar ConnectionInfoDialog which can give you an
instance of ISQLEditorConnectionInfo. This dialog can be invoked via the
context menu "Set connection info" and the ISQLEditorConnectionInfo object
will be associated with the sql file. Is this what you're looking for?

Regards,
Max (Hui) Cao
Sybase Inc.

"Gunnar Wagenknecht" <gunnar@wagenknecht.org> wrote in message
news:envlmo$vqv$1@utils.eclipse.org...
> Hi!
>
> I'm in the process of migrating from WTP to DTP. The problem is that
> some easy to use API seems to be missing for connecting to a database
> and executing some sql statements contained in a file.
>
> Any ideas where I should start looking? I don't want to start messing
> around with profile name or ids or other sort of settings. In WTP I had
> a ConnectionSelectionDialog which I could use to obtain a ConnectionInfo
> just having a Shell.
>
> Cu, Gunnar
>
> --
> Gunnar Wagenknecht
> gunnar@wagenknecht.org
> http://wagenknecht.org/
Re: Executing SQL programmatically [message #583955 is a reply to message #25310] Thu, 11 January 2007 20:04 Go to previous message
Gunnar Wagenknecht is currently offline Gunnar WagenknechtFriend
Messages: 486
Registered: July 2009
Location: San Francisco ✈ Germany
Senior Member

Hui Cao wrote:
> In DTP, there's a similiar ConnectionInfoDialog which can give you an
> instance of ISQLEditorConnectionInfo. This dialog can be invoked via the
> context menu "Set connection info" and the ISQLEditorConnectionInfo object
> will be associated with the sql file. Is this what you're looking for?

Yes, probably. I'll comment in bug 170130.

Cu, Gunnar

--
Gunnar Wagenknecht
gunnar@wagenknecht.org
http://wagenknecht.org/
Previous Topic:DTP 1.0: Connection profiles don't get saved between Eclipse sessions?
Next Topic:Configure Parameter popup
Goto Forum:
  


Current Time: Fri Mar 29 15:00:19 GMT 2024

Powered by FUDForum. Page generated in 0.02768 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top