Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » How to execute SQL script?
How to execute SQL script? [message #22782] Wed, 08 November 2006 10:25 Go to next message
Eclipse UserFriend
Originally posted by: joerg.von.frantzius.artnology.com

Maybe this one is really just me not seeing the obvious, but so far I
haven't found a way to simply execute an SQL script on a given connection.

I have configured some connection that I can access in the Data Source
Explorer, and I opened an SQL script using the "SQL File Editor". In the
editor, I successfully set the connection which is now shown in the status
bar for the editor. However, I can't see how I can actually run the SQL
script.

Thanks for any hints,
Jörg
Re: How to execute SQL script? [message #22827 is a reply to message #22782] Wed, 08 November 2006 10:28 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: joerg.von.frantzius.artnology.com

That's with DTP 1.0M3 on Eclipse 3.2.1, by the way. And I can't see any
"Execute all" option in the editor's context menu (as it is mentioned
somehwere in http://wiki.eclipse.org/index.php/Getting_Started_with_DTP).

Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius:

> Maybe this one is really just me not seeing the obvious, but so far I
> haven't found a way to simply execute an SQL script on a given connection.
>
> I have configured some connection that I can access in the Data Source
> Explorer, and I opened an SQL script using the "SQL File Editor". In the
> editor, I successfully set the connection which is now shown in the status
> bar for the editor. However, I can't see how I can actually run the SQL
> script.
>
> Thanks for any hints,
> Jörg
Re: How to execute SQL script? [message #22915 is a reply to message #22827] Thu, 09 November 2006 01:40 Go to previous messageGo to next message
Anil Samuel is currently offline Anil SamuelFriend
Messages: 108
Registered: July 2009
Senior Member
I remember some earlier builds missing the Execute options in the
context menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4)
Nightly 11/08/06, seems fine in this case; as seen in
http://static.flickr.com/112/292702011_987556ab26.jpg

Anthos
Jörg von Frantzius wrote:
> That's with DTP 1.0M3 on Eclipse 3.2.1, by the way. And I can't see any
> "Execute all" option in the editor's context menu (as it is mentioned
> somehwere in http://wiki.eclipse.org/index.php/Getting_Started_with_DTP).
>
> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius:
>
>
>>Maybe this one is really just me not seeing the obvious, but so far I
>>haven't found a way to simply execute an SQL script on a given connection.
>>
>>I have configured some connection that I can access in the Data Source
>>Explorer, and I opened an SQL script using the "SQL File Editor". In the
>>editor, I successfully set the connection which is now shown in the status
>>bar for the editor. However, I can't see how I can actually run the SQL
>>script.
>>
>>Thanks for any hints,
>>Jörg
>
>
Re: How to execute SQL script? [message #23129 is a reply to message #22915] Wed, 15 November 2006 11:23 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: joerg.von.frantzius.artnology.com

This is a multi-part message in MIME format.
--------------060405000904090103090106
Content-Type: text/html; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-15"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Anil,<br>
<br>
thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
unfortunately that build has other problems that stop me even earlier
in what I want to do... Sigh. It always says "There is no connection
profile assocciated with this resource. Select a connectin profile
type/name" even though I *do* have a profile selected.<br>
<br>
<img alt="screenshot of problem dialog"
src="cid:part1.05040709.05010806@artnology.com" height="352"
width="610"><br>
<br>
I can browse the connection (see tables) in the Database Explorer view.<br>
<br>
Anil T Samuel wrote:
<blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
remember some earlier builds missing the Execute options in the context
menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
11/08/06, seems fine in this case; as seen in
<a class="moz-txt-link-freetext"
href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
<br>
<br>
Anthos <br>
J
Re: How to execute SQL script? [message #23169 is a reply to message #23129] Wed, 15 November 2006 16:40 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: zklopman.somewhere.nospam

I use an even earleir version (1.0.0.200610271), and it works for basic
"standard" SQL commands. When I try to run any Informix-specific commands,
such as "UPDATE STATISTICS" or "ALTER FRAGMENT" it doesn't know what to do
with it.

Zachi


Jörg von Frantzius wrote:

> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content="text/html;charset=ISO-8859-15"
> http-equiv="Content-Type">
> <title></title>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> Hi Anil,<br>
> <br>
> thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
> unfortunately that build has other problems that stop me even earlier
> in what I want to do... Sigh. It always says "There is no connection
> profile assocciated with this resource. Select a connectin profile
> type/name" even though I *do* have a profile selected.<br>
> <br>
> <img alt="screenshot of problem dialog"
> src="cid:part1.05040709.05010806@artnology.com" height="352"
> width="610"><br>
> <br>
> I can browse the connection (see tables) in the Database Explorer view.<br>
> <br>
> Anil T Samuel wrote:
> <blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
> remember some earlier builds missing the Execute options in the context
> menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
> 11/08/06, seems fine in this case; as seen in
> <a class="moz-txt-link-freetext"
>
href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
> <br>
> <br>
> Anthos <br>
> Jörg von Frantzius wrote: <br>
> <blockquote type="cite">That's with DTP 1.0M3 on Eclipse 3.2.1, by
> the way. And I can't see any <br>
> "Execute all" option in the editor's context menu (as it is mentioned <br>
> somehwere in
> <a class="moz-txt-link-freetext"
>
href="http://wiki.eclipse.org/index.php/Getting_Started_with_DTP">http://wiki.eclipse.org/index.php/Getting_Started_with_DTP</a>).
> <br>
> <br>
> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius: <br>
> <br>
> <br>
> <blockquote type="cite">Maybe this one is really just me not seeing
> the obvious, but so far I <br>
> haven't found a way to simply execute an SQL script on a given
> connection. <br>
> <br>
> I have configured some connection that I can access in the Data Source <br>
> Explorer, and I opened an SQL script using the "SQL File Editor". In
> the <br>
> editor, I successfully set the connection which is now shown in the
> status <br>
> bar for the editor. However, I can't see how I can actually run the SQL
> <br>
> script. <br>
> <br>
> Thanks for any hints, <br>
> Jörg <br>
> </blockquote>
> <br>
> <br>
> </blockquote>
> </blockquote>
> <br>
> <br>
> </body>
> </html>
Re: How to execute SQL script? [message #24243 is a reply to message #23129] Tue, 12 December 2006 10:52 Go to previous messageGo to next message
Hui Cao is currently offline Hui CaoFriend
Messages: 14
Registered: July 2009
Junior Member
I can't reproduce the problem you mentioned using the DTP1.0RC1. Please
verify it again on the latest build and open a BZ inluding the reproducing
steps if it still exists. Thanks
Hui Cao
Jörg von Frantzius wrote:

> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content="text/html;charset=ISO-8859-15"
> http-equiv="Content-Type">
> <title></title>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> Hi Anil,<br>
> <br>
> thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
> unfortunately that build has other problems that stop me even earlier
> in what I want to do... Sigh. It always says "There is no connection
> profile assocciated with this resource. Select a connectin profile
> type/name" even though I *do* have a profile selected.<br>
> <br>
> <img alt="screenshot of problem dialog"
> src="cid:part1.05040709.05010806@artnology.com" height="352"
> width="610"><br>
> <br>
> I can browse the connection (see tables) in the Database Explorer view.<br>
> <br>
> Anil T Samuel wrote:
> <blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
> remember some earlier builds missing the Execute options in the context
> menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
> 11/08/06, seems fine in this case; as seen in
> <a class="moz-txt-link-freetext"
>
href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
> <br>
> <br>
> Anthos <br>
> Jörg von Frantzius wrote: <br>
> <blockquote type="cite">That's with DTP 1.0M3 on Eclipse 3.2.1, by
> the way. And I can't see any <br>
> "Execute all" option in the editor's context menu (as it is mentioned <br>
> somehwere in
> <a class="moz-txt-link-freetext"
>
href="http://wiki.eclipse.org/index.php/Getting_Started_with_DTP">http://wiki.eclipse.org/index.php/Getting_Started_with_DTP</a>).
> <br>
> <br>
> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius: <br>
> <br>
> <br>
> <blockquote type="cite">Maybe this one is really just me not seeing
> the obvious, but so far I <br>
> haven't found a way to simply execute an SQL script on a given
> connection. <br>
> <br>
> I have configured some connection that I can access in the Data Source <br>
> Explorer, and I opened an SQL script using the "SQL File Editor". In
> the <br>
> editor, I successfully set the connection which is now shown in the
> status <br>
> bar for the editor. However, I can't see how I can actually run the SQL
> <br>
> script. <br>
> <br>
> Thanks for any hints, <br>
> Jörg <br>
> </blockquote>
> <br>
> <br>
> </blockquote>
> </blockquote>
> <br>
> <br>
> </body>
> </html>
Re: How to execute SQL script? [message #24369 is a reply to message #24243] Mon, 18 December 2006 15:10 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: joerg.von.frantzius.artnology.com

Hi Hui,

I tried it again using DTP 1.0 RC2 on Eclipse 3.3 M4, and I'm getting
the exact same problem again. Please see
https://bugs.eclipse.org/bugs/show_bug.cgi?id=168411

Regards,
Jörg

Hui Cao wrote:
> I can't reproduce the problem you mentioned using the DTP1.0RC1.
> Please verify it again on the latest build and open a BZ inluding the
> reproducing steps if it still exists. Thanks
> Hui Cao
> Jörg von Frantzius wrote:
>
>> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
>> <html>
>> <head>
>> <meta content="text/html;charset=ISO-8859-15"
>> http-equiv="Content-Type">
>> <title></title>
>> </head>
>> <body bgcolor="#ffffff" text="#000000">
>> Hi Anil,<br>
>> <br>
>> thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
>> unfortunately that build has other problems that stop me even earlier
>> in what I want to do... Sigh. It always says "There is no connection
>> profile assocciated with this resource. Select a connectin profile
>> type/name" even though I *do* have a profile selected.<br>
>> <br>
>> <img alt="screenshot of problem dialog"
>> src="cid:part1.05040709.05010806@artnology.com" height="352"
>> width="610"><br>
>> <br>
>> I can browse the connection (see tables) in the Database Explorer
>> view.<br>
>> <br>
>> Anil T Samuel wrote:
>> <blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
>> remember some earlier builds missing the Execute options in the context
>> menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
>> 11/08/06, seems fine in this case; as seen in
>> <a class="moz-txt-link-freetext"
>>
> href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
>
>> <br>
>> <br>
>> Anthos <br>
>> Jörg von Frantzius wrote: <br>
>> <blockquote type="cite">That's with DTP 1.0M3 on Eclipse 3.2.1, by
>> the way. And I can't see any <br>
>> "Execute all" option in the editor's context menu (as it is mentioned
>> <br>
>> somehwere in
>> <a class="moz-txt-link-freetext"
>>
> href="http://wiki.eclipse.org/index.php/Getting_Started_with_DTP">http://wiki.eclipse.org/index.php/Getting_Started_with_DTP</a>).
>
>> <br>
>> <br>
>> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius: <br>
>> <br>
>> <br>
>> <blockquote type="cite">Maybe this one is really just me not seeing
>> the obvious, but so far I <br>
>> haven't found a way to simply execute an SQL script on a given
>> connection. <br>
>> <br>
>> I have configured some connection that I can access in the Data
>> Source <br>
>> Explorer, and I opened an SQL script using the "SQL File Editor". In
>> the <br>
>> editor, I successfully set the connection which is now shown in the
>> status <br>
>> bar for the editor. However, I can't see how I can actually run the SQL
>> <br>
>> script. <br>
>> <br>
>> Thanks for any hints, <br>
>> Jörg <br>
>> </blockquote>
>> <br>
>> <br>
>> </blockquote>
>> </blockquote>
>> <br>
>> <br>
>> </body>
>> </html>
>
Another new user has been stuck [message #32195 is a reply to message #23169] Tue, 10 July 2007 07:49 Go to previous messageGo to next message
Braini is currently offline BrainiFriend
Messages: 10
Registered: July 2009
Junior Member
Hi out there,

yesterday I downloaded and worked with edt for the first time. I
integrated it in the newest eclipse version and connected to an Oracle
10g database.

(1) Everything worked fine until I tried to execute SQL commands in the
scrap book. I was not able to really "execute" them and/ or watch the
results.

(2) Today I reopened eclipse and for some strange reason my profile from
yesterday in the "Data Source Explorer" was moved from the folder
"Databases" to a new folder named "Unsupported" and I can't connect with
it anymore. Setting up a new connection profile is also impossible: the
profile type "oracle database" is not existing anymore.

How can something like this happen? For one moment I was afraid somebody
really stole my database!
Re: Another new user has been stuck [message #32231 is a reply to message #32195] Tue, 10 July 2007 08:22 Go to previous message
Braini is currently offline BrainiFriend
Messages: 10
Registered: July 2009
Junior Member
Problem (2) has been solved.
I used two copies of eclipse for testing purposes.

Problem (1) still remains.
I cannot execute sql statements. Not through the Scrapbook and not
through the "SQL Results" tab. No error - nothing happens.






Braini schrieb:
> Hi out there,
>
> yesterday I downloaded and worked with edt for the first time. I
> integrated it in the newest eclipse version and connected to an Oracle
> 10g database.
>
> (1) Everything worked fine until I tried to execute SQL commands in the
> scrap book. I was not able to really "execute" them and/ or watch the
> results.
>
> (2) Today I reopened eclipse and for some strange reason my profile from
> yesterday in the "Data Source Explorer" was moved from the folder
> "Databases" to a new folder named "Unsupported" and I can't connect with
> it anymore. Setting up a new connection profile is also impossible: the
> profile type "oracle database" is not existing anymore.
>
> How can something like this happen? For one moment I was afraid somebody
> really stole my database!
>
>
Re: How to execute SQL script? [message #582946 is a reply to message #22782] Wed, 08 November 2006 10:28 Go to previous message
Eclipse UserFriend
Originally posted by: joerg.von.frantzius.artnology.com

That's with DTP 1.0M3 on Eclipse 3.2.1, by the way. And I can't see any
"Execute all" option in the editor's context menu (as it is mentioned
somehwere in http://wiki.eclipse.org/index.php/Getting_Started_with_DTP).

Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius:

> Maybe this one is really just me not seeing the obvious, but so far I
> haven't found a way to simply execute an SQL script on a given connection.
>
> I have configured some connection that I can access in the Data Source
> Explorer, and I opened an SQL script using the "SQL File Editor". In the
> editor, I successfully set the connection which is now shown in the status
> bar for the editor. However, I can't see how I can actually run the SQL
> script.
>
> Thanks for any hints,
> Jörg
Re: How to execute SQL script? [message #582985 is a reply to message #22827] Thu, 09 November 2006 01:40 Go to previous message
Anil Samuel is currently offline Anil SamuelFriend
Messages: 108
Registered: July 2009
Senior Member
I remember some earlier builds missing the Execute options in the
context menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4)
Nightly 11/08/06, seems fine in this case; as seen in
http://static.flickr.com/112/292702011_987556ab26.jpg

Anthos
Jörg von Frantzius wrote:
> That's with DTP 1.0M3 on Eclipse 3.2.1, by the way. And I can't see any
> "Execute all" option in the editor's context menu (as it is mentioned
> somehwere in http://wiki.eclipse.org/index.php/Getting_Started_with_DTP).
>
> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius:
>
>
>>Maybe this one is really just me not seeing the obvious, but so far I
>>haven't found a way to simply execute an SQL script on a given connection.
>>
>>I have configured some connection that I can access in the Data Source
>>Explorer, and I opened an SQL script using the "SQL File Editor". In the
>>editor, I successfully set the connection which is now shown in the status
>>bar for the editor. However, I can't see how I can actually run the SQL
>>script.
>>
>>Thanks for any hints,
>>Jörg
>
>
Re: How to execute SQL script? [message #583056 is a reply to message #22915] Wed, 15 November 2006 11:23 Go to previous message
Eclipse UserFriend
Originally posted by: joerg.von.frantzius.artnology.com

This is a multi-part message in MIME format.
--------------060405000904090103090106
Content-Type: text/html; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-15"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Anil,<br>
<br>
thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
unfortunately that build has other problems that stop me even earlier
in what I want to do... Sigh. It always says "There is no connection
profile assocciated with this resource. Select a connectin profile
type/name" even though I *do* have a profile selected.<br>
<br>
<img alt="screenshot of problem dialog"
src="cid:part1.05040709.05010806@artnology.com" height="352"
width="610"><br>
<br>
I can browse the connection (see tables) in the Database Explorer view.<br>
<br>
Anil T Samuel wrote:
<blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
remember some earlier builds missing the Execute options in the context
menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
11/08/06, seems fine in this case; as seen in
<a class="moz-txt-link-freetext"
href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
<br>
<br>
Anthos <br>
J
Re: How to execute SQL script? [message #583072 is a reply to message #23129] Wed, 15 November 2006 16:40 Go to previous message
Eclipse UserFriend
Originally posted by: zklopman.somewhere.nospam

I use an even earleir version (1.0.0.200610271), and it works for basic
"standard" SQL commands. When I try to run any Informix-specific commands,
such as "UPDATE STATISTICS" or "ALTER FRAGMENT" it doesn't know what to do
with it.

Zachi


Jörg von Frantzius wrote:

> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content="text/html;charset=ISO-8859-15"
> http-equiv="Content-Type">
> <title></title>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> Hi Anil,<br>
> <br>
> thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
> unfortunately that build has other problems that stop me even earlier
> in what I want to do... Sigh. It always says "There is no connection
> profile assocciated with this resource. Select a connectin profile
> type/name" even though I *do* have a profile selected.<br>
> <br>
> <img alt="screenshot of problem dialog"
> src="cid:part1.05040709.05010806@artnology.com" height="352"
> width="610"><br>
> <br>
> I can browse the connection (see tables) in the Database Explorer view.<br>
> <br>
> Anil T Samuel wrote:
> <blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
> remember some earlier builds missing the Execute options in the context
> menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
> 11/08/06, seems fine in this case; as seen in
> <a class="moz-txt-link-freetext"
>
href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
> <br>
> <br>
> Anthos <br>
> Jörg von Frantzius wrote: <br>
> <blockquote type="cite">That's with DTP 1.0M3 on Eclipse 3.2.1, by
> the way. And I can't see any <br>
> "Execute all" option in the editor's context menu (as it is mentioned <br>
> somehwere in
> <a class="moz-txt-link-freetext"
>
href="http://wiki.eclipse.org/index.php/Getting_Started_with_DTP">http://wiki.eclipse.org/index.php/Getting_Started_with_DTP</a>).
> <br>
> <br>
> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius: <br>
> <br>
> <br>
> <blockquote type="cite">Maybe this one is really just me not seeing
> the obvious, but so far I <br>
> haven't found a way to simply execute an SQL script on a given
> connection. <br>
> <br>
> I have configured some connection that I can access in the Data Source <br>
> Explorer, and I opened an SQL script using the "SQL File Editor". In
> the <br>
> editor, I successfully set the connection which is now shown in the
> status <br>
> bar for the editor. However, I can't see how I can actually run the SQL
> <br>
> script. <br>
> <br>
> Thanks for any hints, <br>
> Jörg <br>
> </blockquote>
> <br>
> <br>
> </blockquote>
> </blockquote>
> <br>
> <br>
> </body>
> </html>
Re: How to execute SQL script? [message #583469 is a reply to message #23129] Tue, 12 December 2006 10:52 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 14
Registered: July 2009
Junior Member
I can't reproduce the problem you mentioned using the DTP1.0RC1. Please
verify it again on the latest build and open a BZ inluding the reproducing
steps if it still exists. Thanks
Hui Cao
Jörg von Frantzius wrote:

> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content="text/html;charset=ISO-8859-15"
> http-equiv="Content-Type">
> <title></title>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> Hi Anil,<br>
> <br>
> thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
> unfortunately that build has other problems that stop me even earlier
> in what I want to do... Sigh. It always says "There is no connection
> profile assocciated with this resource. Select a connectin profile
> type/name" even though I *do* have a profile selected.<br>
> <br>
> <img alt="screenshot of problem dialog"
> src="cid:part1.05040709.05010806@artnology.com" height="352"
> width="610"><br>
> <br>
> I can browse the connection (see tables) in the Database Explorer view.<br>
> <br>
> Anil T Samuel wrote:
> <blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
> remember some earlier builds missing the Execute options in the context
> menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
> 11/08/06, seems fine in this case; as seen in
> <a class="moz-txt-link-freetext"
>
href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
> <br>
> <br>
> Anthos <br>
> Jörg von Frantzius wrote: <br>
> <blockquote type="cite">That's with DTP 1.0M3 on Eclipse 3.2.1, by
> the way. And I can't see any <br>
> "Execute all" option in the editor's context menu (as it is mentioned <br>
> somehwere in
> <a class="moz-txt-link-freetext"
>
href="http://wiki.eclipse.org/index.php/Getting_Started_with_DTP">http://wiki.eclipse.org/index.php/Getting_Started_with_DTP</a>).
> <br>
> <br>
> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius: <br>
> <br>
> <br>
> <blockquote type="cite">Maybe this one is really just me not seeing
> the obvious, but so far I <br>
> haven't found a way to simply execute an SQL script on a given
> connection. <br>
> <br>
> I have configured some connection that I can access in the Data Source <br>
> Explorer, and I opened an SQL script using the "SQL File Editor". In
> the <br>
> editor, I successfully set the connection which is now shown in the
> status <br>
> bar for the editor. However, I can't see how I can actually run the SQL
> <br>
> script. <br>
> <br>
> Thanks for any hints, <br>
> Jörg <br>
> </blockquote>
> <br>
> <br>
> </blockquote>
> </blockquote>
> <br>
> <br>
> </body>
> </html>
Re: How to execute SQL script? [message #583506 is a reply to message #24243] Mon, 18 December 2006 15:10 Go to previous message
Eclipse UserFriend
Originally posted by: joerg.von.frantzius.artnology.com

Hi Hui,

I tried it again using DTP 1.0 RC2 on Eclipse 3.3 M4, and I'm getting
the exact same problem again. Please see
https://bugs.eclipse.org/bugs/show_bug.cgi?id=168411

Regards,
Jörg

Hui Cao wrote:
> I can't reproduce the problem you mentioned using the DTP1.0RC1.
> Please verify it again on the latest build and open a BZ inluding the
> reproducing steps if it still exists. Thanks
> Hui Cao
> Jörg von Frantzius wrote:
>
>> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
>> <html>
>> <head>
>> <meta content="text/html;charset=ISO-8859-15"
>> http-equiv="Content-Type">
>> <title></title>
>> </head>
>> <body bgcolor="#ffffff" text="#000000">
>> Hi Anil,<br>
>> <br>
>> thanks for answering. I just tried dtp-sdk_1.0M4_N111406 and
>> unfortunately that build has other problems that stop me even earlier
>> in what I want to do... Sigh. It always says "There is no connection
>> profile assocciated with this resource. Select a connectin profile
>> type/name" even though I *do* have a profile selected.<br>
>> <br>
>> <img alt="screenshot of problem dialog"
>> src="cid:part1.05040709.05010806@artnology.com" height="352"
>> width="610"><br>
>> <br>
>> I can browse the connection (see tables) in the Database Explorer
>> view.<br>
>> <br>
>> Anil T Samuel wrote:
>> <blockquote cite="mideiu1ag$5bm$1@utils.eclipse.org" type="cite">I
>> remember some earlier builds missing the Execute options in the context
>> menu in SQL Editor. Latest build DTP 1.0 Milestone 4 (M4) Nightly
>> 11/08/06, seems fine in this case; as seen in
>> <a class="moz-txt-link-freetext"
>>
> href="http://static.flickr.com/112/292702011_987556ab26.jpg">http://static.flickr.com/112/292702011_987556ab26.jpg</a>
>
>> <br>
>> <br>
>> Anthos <br>
>> Jörg von Frantzius wrote: <br>
>> <blockquote type="cite">That's with DTP 1.0M3 on Eclipse 3.2.1, by
>> the way. And I can't see any <br>
>> "Execute all" option in the editor's context menu (as it is mentioned
>> <br>
>> somehwere in
>> <a class="moz-txt-link-freetext"
>>
> href="http://wiki.eclipse.org/index.php/Getting_Started_with_DTP">http://wiki.eclipse.org/index.php/Getting_Started_with_DTP</a>).
>
>> <br>
>> <br>
>> Am Wed, 08 Nov 2006 11:25:21 +0100 schrieb Jörg von Frantzius: <br>
>> <br>
>> <br>
>> <blockquote type="cite">Maybe this one is really just me not seeing
>> the obvious, but so far I <br>
>> haven't found a way to simply execute an SQL script on a given
>> connection. <br>
>> <br>
>> I have configured some connection that I can access in the Data
>> Source <br>
>> Explorer, and I opened an SQL script using the "SQL File Editor". In
>> the <br>
>> editor, I successfully set the connection which is now shown in the
>> status <br>
>> bar for the editor. However, I can't see how I can actually run the SQL
>> <br>
>> script. <br>
>> <br>
>> Thanks for any hints, <br>
>> Jörg <br>
>> </blockquote>
>> <br>
>> <br>
>> </blockquote>
>> </blockquote>
>> <br>
>> <br>
>> </body>
>> </html>
>
Another new user has been stuck [message #586280 is a reply to message #23169] Tue, 10 July 2007 07:49 Go to previous message
Braini is currently offline BrainiFriend
Messages: 10
Registered: July 2009
Junior Member
Hi out there,

yesterday I downloaded and worked with edt for the first time. I
integrated it in the newest eclipse version and connected to an Oracle
10g database.

(1) Everything worked fine until I tried to execute SQL commands in the
scrap book. I was not able to really "execute" them and/ or watch the
results.

(2) Today I reopened eclipse and for some strange reason my profile from
yesterday in the "Data Source Explorer" was moved from the folder
"Databases" to a new folder named "Unsupported" and I can't connect with
it anymore. Setting up a new connection profile is also impossible: the
profile type "oracle database" is not existing anymore.

How can something like this happen? For one moment I was afraid somebody
really stole my database!
Re: Another new user has been stuck [message #586295 is a reply to message #32195] Tue, 10 July 2007 08:22 Go to previous message
Braini is currently offline BrainiFriend
Messages: 10
Registered: July 2009
Junior Member
Problem (2) has been solved.
I used two copies of eclipse for testing purposes.

Problem (1) still remains.
I cannot execute sql statements. Not through the Scrapbook and not
through the "SQL Results" tab. No error - nothing happens.






Braini schrieb:
> Hi out there,
>
> yesterday I downloaded and worked with edt for the first time. I
> integrated it in the newest eclipse version and connected to an Oracle
> 10g database.
>
> (1) Everything worked fine until I tried to execute SQL commands in the
> scrap book. I was not able to really "execute" them and/ or watch the
> results.
>
> (2) Today I reopened eclipse and for some strange reason my profile from
> yesterday in the "Data Source Explorer" was moved from the folder
> "Databases" to a new folder named "Unsupported" and I can't connect with
> it anymore. Setting up a new connection profile is also impossible: the
> profile type "oracle database" is not existing anymore.
>
> How can something like this happen? For one moment I was afraid somebody
> really stole my database!
>
>
Previous Topic:Ecore & ODA
Next Topic:Ecore ODA provider packaging
Goto Forum:
  


Current Time: Sun Dec 21 08:45:34 GMT 2014

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

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