Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 07:58 Go to next message
Jeff Lins is currently offline Jeff LinsFriend
Messages: 39
Registered: July 2009
Member
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 #42414 is a reply to message #42354] Thu, 28 February 2008 16:01 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: brianf.sybase.com

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 #42436 is a reply to message #42414] Thu, 28 February 2008 17:14 Go to previous messageGo to next message
Jeff Lins is currently offline Jeff LinsFriend
Messages: 39
Registered: July 2009
Member
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 #42490 is a reply to message #42436] Fri, 29 February 2008 02:22 Go to previous messageGo to next message
Jeff Lins is currently offline Jeff LinsFriend
Messages: 39
Registered: July 2009
Member
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] Fri, 29 February 2008 04:25 Go to previous message
Eclipse UserFriend
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 16:01 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 500
Registered: July 2009
Senior Member
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 17:14 Go to previous message
Jeff Lins is currently offline Jeff LinsFriend
Messages: 39
Registered: July 2009
Member
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] Fri, 29 February 2008 02:22 Go to previous message
Jeff Lins is currently offline Jeff LinsFriend
Messages: 39
Registered: July 2009
Member
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] Fri, 29 February 2008 04:25 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 500
Registered: July 2009
Senior Member
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?
>>>
>>>
Previous Topic:Connecting to Sybase via JDBC - Only see Schema under each Table
Next Topic:Connecting to Sybase via JDBC - Only see Schema under each Table
Goto Forum:
  


Current Time: Fri Mar 29 11:25:33 GMT 2024

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

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

Back to the top