Home » Eclipse Projects » DTP » "No connection" on a database that I am connected to
| "No connection" on a database that I am connected to [message #42354] |
Thu, 28 February 2008 02:58  |
Eclipse User |
|
|
|
I have been going through the wiki article to set up Derby with DTP for
the first time:
http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
I have everything set up and I can execute the stored procedure talked
about in the article but when I try to execute my own sql as the article
describes, it doesn't work. The sql is:
SELECT * FROM SYS.SYSTABLES;
In the results view, the status field on the left shows as failed and it
says "no current connection" on the status tab to the right. I am
definately connected since I can browse through the database in the Data
Source Explorer and even execute stored procedures successfully. On my
sql file I have specified all the information in the connection profile.
I don't get it. Am I missing something here?
|
|
| | |
| Re: "No connection" on a database that I am connected to [message #42490 is a reply to message #42436] |
Thu, 28 February 2008 21:22  |
| Eclipse User |
|
|
|
Using the "Set Connection" menu item worked. If I right click on the
connection in the DSE and connect that way, I cannot execute the query
but if I connect through the "Set Connection" menu item, the query will
work. Is this a bug? I can't imagine it's supposed to work that way. It
seems like I should be able to set the connection using the drop down
boxes at the top of the SQL scrap book and never have to use the "Set
Connection" menu item if I don't want to, right?
Gigaplex wrote:
> Yeah, I filled out the stuff at the top and it shows "Status:
> Connected" there. That's why I'm so confused by this. I haven't tried
> right clicking and using "Set Connection" though so I will give that a
> shot. Don't they do the same thing though?
>
> Brian Fitzpatrick wrote:
>> If you right-click on the SQL scrapbook in a blank space, you should
>> see a "Set Connection" menu item. Also, at the top there is a series
>> of drop-down lists to select the type of connection profile (Derby),
>> name of th eprofile (MyProfile), and if it's connected, it'll show
>> "Status: Connected" in that bar also.
>>
>> Hope that helps.
>> --Fitz
>>
>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>> news:fq5plc$g42$1@build.eclipse.org...
>>> I have been going through the wiki article to set up Derby with DTP
>>> for the first time:
>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>
>>> I have everything set up and I can execute the stored procedure
>>> talked about in the article but when I try to execute my own sql as
>>> the article describes, it doesn't work. The sql is:
>>> SELECT * FROM SYS.SYSTABLES;
>>>
>>> In the results view, the status field on the left shows as failed
>>> and it says "no current connection" on the status tab to the right.
>>> I am definately connected since I can browse through the database in
>>> the Data Source Explorer and even execute stored procedures
>>> successfully. On my sql file I have specified all the information in
>>> the connection profile.
>>>
>>> I don't get it. Am I missing something here?
>>
>>
|
|
|
| Re: "No connection" on a database that I am connected to [message #42529 is a reply to message #42490] |
Thu, 28 February 2008 23:25 |
| Eclipse User |
|
|
|
Originally posted by: brianf.sybase.com
This certainly sounds like a bug. I'd register it against SQL Tools in DTP
if you could create a Bugzilla entry for it.
"Gigaplex" <gigaplex08@gmail.com> wrote in message
news:fq7qbc$468$1@build.eclipse.org...
> Using the "Set Connection" menu item worked. If I right click on the
> connection in the DSE and connect that way, I cannot execute the query but
> if I connect through the "Set Connection" menu item, the query will work.
> Is this a bug? I can't imagine it's supposed to work that way. It seems
> like I should be able to set the connection using the drop down boxes at
> the top of the SQL scrap book and never have to use the "Set Connection"
> menu item if I don't want to, right?
>
> Gigaplex wrote:
>> Yeah, I filled out the stuff at the top and it shows "Status: Connected"
>> there. That's why I'm so confused by this. I haven't tried right clicking
>> and using "Set Connection" though so I will give that a shot. Don't they
>> do the same thing though?
>>
>> Brian Fitzpatrick wrote:
>>> If you right-click on the SQL scrapbook in a blank space, you should see
>>> a "Set Connection" menu item. Also, at the top there is a series of
>>> drop-down lists to select the type of connection profile (Derby), name
>>> of th eprofile (MyProfile), and if it's connected, it'll show "Status:
>>> Connected" in that bar also.
>>>
>>> Hope that helps.
>>> --Fitz
>>>
>>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>>> news:fq5plc$g42$1@build.eclipse.org...
>>>> I have been going through the wiki article to set up Derby with DTP for
>>>> the first time:
>>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>>
>>>> I have everything set up and I can execute the stored procedure talked
>>>> about in the article but when I try to execute my own sql as the
>>>> article describes, it doesn't work. The sql is:
>>>> SELECT * FROM SYS.SYSTABLES;
>>>>
>>>> In the results view, the status field on the left shows as failed and
>>>> it says "no current connection" on the status tab to the right. I am
>>>> definately connected since I can browse through the database in the
>>>> Data Source Explorer and even execute stored procedures successfully.
>>>> On my sql file I have specified all the information in the connection
>>>> profile.
>>>>
>>>> I don't get it. Am I missing something here?
>>>
>>>
|
|
|
| Re: "No connection" on a database that I am connected to [message #590240 is a reply to message #42354] |
Thu, 28 February 2008 11:01 |
| Eclipse User |
|
|
|
If you right-click on the SQL scrapbook in a blank space, you should see a
"Set Connection" menu item. Also, at the top there is a series of drop-down
lists to select the type of connection profile (Derby), name of th eprofile
(MyProfile), and if it's connected, it'll show "Status: Connected" in that
bar also.
Hope that helps.
--Fitz
"Gigaplex" <gigaplex08@gmail.com> wrote in message
news:fq5plc$g42$1@build.eclipse.org...
>I have been going through the wiki article to set up Derby with DTP for the
>first time:
> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>
> I have everything set up and I can execute the stored procedure talked
> about in the article but when I try to execute my own sql as the article
> describes, it doesn't work. The sql is:
> SELECT * FROM SYS.SYSTABLES;
>
> In the results view, the status field on the left shows as failed and it
> says "no current connection" on the status tab to the right. I am
> definately connected since I can browse through the database in the Data
> Source Explorer and even execute stored procedures successfully. On my sql
> file I have specified all the information in the connection profile.
>
> I don't get it. Am I missing something here?
|
|
|
| Re: "No connection" on a database that I am connected to [message #590249 is a reply to message #42414] |
Thu, 28 February 2008 12:14 |
| Eclipse User |
|
|
|
Yeah, I filled out the stuff at the top and it shows "Status: Connected"
there. That's why I'm so confused by this. I haven't tried right
clicking and using "Set Connection" though so I will give that a shot.
Don't they do the same thing though?
Brian Fitzpatrick wrote:
> If you right-click on the SQL scrapbook in a blank space, you should see a
> "Set Connection" menu item. Also, at the top there is a series of drop-down
> lists to select the type of connection profile (Derby), name of th eprofile
> (MyProfile), and if it's connected, it'll show "Status: Connected" in that
> bar also.
>
> Hope that helps.
> --Fitz
>
> "Gigaplex" <gigaplex08@gmail.com> wrote in message
> news:fq5plc$g42$1@build.eclipse.org...
>> I have been going through the wiki article to set up Derby with DTP for the
>> first time:
>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>
>> I have everything set up and I can execute the stored procedure talked
>> about in the article but when I try to execute my own sql as the article
>> describes, it doesn't work. The sql is:
>> SELECT * FROM SYS.SYSTABLES;
>>
>> In the results view, the status field on the left shows as failed and it
>> says "no current connection" on the status tab to the right. I am
>> definately connected since I can browse through the database in the Data
>> Source Explorer and even execute stored procedures successfully. On my sql
>> file I have specified all the information in the connection profile.
>>
>> I don't get it. Am I missing something here?
>
>
|
|
|
| Re: "No connection" on a database that I am connected to [message #590269 is a reply to message #42436] |
Thu, 28 February 2008 21:22 |
| Eclipse User |
|
|
|
Using the "Set Connection" menu item worked. If I right click on the
connection in the DSE and connect that way, I cannot execute the query
but if I connect through the "Set Connection" menu item, the query will
work. Is this a bug? I can't imagine it's supposed to work that way. It
seems like I should be able to set the connection using the drop down
boxes at the top of the SQL scrap book and never have to use the "Set
Connection" menu item if I don't want to, right?
Gigaplex wrote:
> Yeah, I filled out the stuff at the top and it shows "Status:
> Connected" there. That's why I'm so confused by this. I haven't tried
> right clicking and using "Set Connection" though so I will give that a
> shot. Don't they do the same thing though?
>
> Brian Fitzpatrick wrote:
>> If you right-click on the SQL scrapbook in a blank space, you should
>> see a "Set Connection" menu item. Also, at the top there is a series
>> of drop-down lists to select the type of connection profile (Derby),
>> name of th eprofile (MyProfile), and if it's connected, it'll show
>> "Status: Connected" in that bar also.
>>
>> Hope that helps.
>> --Fitz
>>
>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>> news:fq5plc$g42$1@build.eclipse.org...
>>> I have been going through the wiki article to set up Derby with DTP
>>> for the first time:
>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>
>>> I have everything set up and I can execute the stored procedure
>>> talked about in the article but when I try to execute my own sql as
>>> the article describes, it doesn't work. The sql is:
>>> SELECT * FROM SYS.SYSTABLES;
>>>
>>> In the results view, the status field on the left shows as failed
>>> and it says "no current connection" on the status tab to the right.
>>> I am definately connected since I can browse through the database in
>>> the Data Source Explorer and even execute stored procedures
>>> successfully. On my sql file I have specified all the information in
>>> the connection profile.
>>>
>>> I don't get it. Am I missing something here?
>>
>>
|
|
|
| Re: "No connection" on a database that I am connected to [message #590287 is a reply to message #42490] |
Thu, 28 February 2008 23:25 |
| Eclipse User |
|
|
|
This certainly sounds like a bug. I'd register it against SQL Tools in DTP
if you could create a Bugzilla entry for it.
"Gigaplex" <gigaplex08@gmail.com> wrote in message
news:fq7qbc$468$1@build.eclipse.org...
> Using the "Set Connection" menu item worked. If I right click on the
> connection in the DSE and connect that way, I cannot execute the query but
> if I connect through the "Set Connection" menu item, the query will work.
> Is this a bug? I can't imagine it's supposed to work that way. It seems
> like I should be able to set the connection using the drop down boxes at
> the top of the SQL scrap book and never have to use the "Set Connection"
> menu item if I don't want to, right?
>
> Gigaplex wrote:
>> Yeah, I filled out the stuff at the top and it shows "Status: Connected"
>> there. That's why I'm so confused by this. I haven't tried right clicking
>> and using "Set Connection" though so I will give that a shot. Don't they
>> do the same thing though?
>>
>> Brian Fitzpatrick wrote:
>>> If you right-click on the SQL scrapbook in a blank space, you should see
>>> a "Set Connection" menu item. Also, at the top there is a series of
>>> drop-down lists to select the type of connection profile (Derby), name
>>> of th eprofile (MyProfile), and if it's connected, it'll show "Status:
>>> Connected" in that bar also.
>>>
>>> Hope that helps.
>>> --Fitz
>>>
>>> "Gigaplex" <gigaplex08@gmail.com> wrote in message
>>> news:fq5plc$g42$1@build.eclipse.org...
>>>> I have been going through the wiki article to set up Derby with DTP for
>>>> the first time:
>>>> http://wiki.eclipse.org/index.php/Getting_Started_with_DTP
>>>>
>>>> I have everything set up and I can execute the stored procedure talked
>>>> about in the article but when I try to execute my own sql as the
>>>> article describes, it doesn't work. The sql is:
>>>> SELECT * FROM SYS.SYSTABLES;
>>>>
>>>> In the results view, the status field on the left shows as failed and
>>>> it says "no current connection" on the status tab to the right. I am
>>>> definately connected since I can browse through the database in the
>>>> Data Source Explorer and even execute stored procedures successfully.
>>>> On my sql file I have specified all the information in the connection
>>>> profile.
>>>>
>>>> I don't get it. Am I missing something here?
>>>
>>>
|
|
|
Goto Forum:
Current Time: Sun Jul 06 10:04:22 EDT 2025
Powered by FUDForum. Page generated in 0.10872 seconds |
Home