Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Don't see any results in SQL Results view
Don't see any results in SQL Results view [message #9298] Mon, 06 March 2006 09:37 Go to next message
Tomer Mahlin is currently offline Tomer MahlinFriend
Messages: 2
Registered: July 2009
Junior Member
Hello,

I am seeking you advice on running SQL Development Tools component. In
addition I would like to ask a couple of questions regarding DTP
functionality.

1. Problem with SQL Development Tools component.

I am currently conducting BiDi (Hebrew + Arabic) test of DTP (a subset of
GVT). Running TCs created by Hui Cao (which I downloaded from GSA:
/gsa/rtpgsa/projects/w/wswb/anonymous/in/IES_3.2_EnablementT estCases/DATATOOL/attachment.pdf)
for SQL Development Tools I see that none of the SQL queries executed
against Derby / MS SQL / DB2 RDBMS do not produce any results in the SQL
Results view. I suspect that this might occur due to the fact that I don't
have lpg.jar file installed as explained on those pages:
http://www.eclipse.org/datatools/project_sqldevtools/index.h tml
http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/sqlqueryparser_lpg_readme.html
Unfortunately I could not locate this file on this site:
https://testcase.boulder.ibm.com/
Would you please let me know if missing lpg.jar file can cause the
described behavior (lack of results in SQL Results view) and if so where I
can find this jar file (what is its exact path on the
https://testcase.boulder.ibm.com/ site) ?

2. DTP Functionality related questions.
a. Interestingly enough you can add connections to various RDBMS from
Data Source Explorer ( I tried and was successful with Derby, DB2, MS
SQL). However, you can not associate sql script with any of those
connection except for connections to Derby RDBMS (the association is via
Set Connection Info option available in the context menu from SQL editor).
Is this a temporary restriction or it is part of the design ?
b. Using Run you can create Eclipse Data Tools configurations with
profiles defining connections not only to Derby RDBMS but also to other
RDBMS (e.g. DB2, MS SQL). Does it mean that running SQL queries from Run
dialog against those RDBMS are supported while from SQL editor it is not ?
c. Stored procedures appear in Data Source Explorer only for Derby
RDBMS. For MS SQL and DB2 they don't appear at all. Is this an expected
behavior ?

Thank you in advance,
Tomer.
Re: Don't see any results in SQL Results view [message #9368 is a reply to message #9298] Tue, 07 March 2006 08:32 Go to previous messageGo to next message
Hui Cao is currently offline Hui CaoFriend
Messages: 14
Registered: July 2009
Junior Member
Hi Tomer,
Please inline comments below:

Tomer Mahlin wrote:

> Hello,

> I am seeking you advice on running SQL Development Tools component. In
> addition I would like to ask a couple of questions regarding DTP
> functionality.

> 1. Problem with SQL Development Tools component.

> I am currently conducting BiDi (Hebrew + Arabic) test of DTP (a subset of
> GVT). Running TCs created by Hui Cao (which I downloaded from GSA:
>
/gsa/rtpgsa/projects/w/wswb/anonymous/in/IES_3.2_EnablementT estCases/DATATOOL/attachment.pdf)
> for SQL Development Tools I see that none of the SQL queries executed
> against Derby / MS SQL / DB2 RDBMS do not produce any results in the SQL
> Results view. I suspect that this might occur due to the fact that I don't
> have lpg.jar file installed as explained on those pages:
> http://www.eclipse.org/datatools/project_sqldevtools/index.h tml
>
http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/sqlqueryparser_lpg_readme.html
> Unfortunately I could not locate this file on this site:
> https://testcase.boulder.ibm.com/
> Would you please let me know if missing lpg.jar file can cause the
> described behavior (lack of results in SQL Results view) and if so where I
> can find this jar file (what is its exact path on the
> https://testcase.boulder.ibm.com/ site) ?

Your problem has nothing to do with lpg.jar. It's because SQL Results
View filters out the results. You can go to "Filters" menu in SQL Results
View to check on your connection profile.

> 2. DTP Functionality related questions.
> a. Interestingly enough you can add connections to various RDBMS from
> Data Source Explorer ( I tried and was successful with Derby, DB2, MS
> SQL). However, you can not associate sql script with any of those
> connection except for connections to Derby RDBMS (the association is via
> Set Connection Info option available in the context menu from SQL editor).
> Is this a temporary restriction or it is part of the design ?

SQL Dev Tools defines an extensible and reusable framework that needs
vendor-specific add-ons to enable the editing/debugging features.
Currently we only provide a exemplary Derby implementation.


> b. Using Run you can create Eclipse Data Tools configurations with
> profiles defining connections not only to Derby RDBMS but also to other
> RDBMS (e.g. DB2, MS SQL). Does it mean that running SQL queries from Run
> dialog against those RDBMS are supported while from SQL editor it is not ?

As mentioned above, in Data Tools launch configuration dialog,
non-supported RDBMS connection profiles should be filtered out. I've
checked in the code to make the launch configuration and editor in sync.


> c. Stored procedures appear in Data Source Explorer only for Derby
> RDBMS. For MS SQL and DB2 they don't appear at all. Is this an expected
> behavior ?

Although you can create connection profiles for other databases, to see
the catalog objects in DSE, an ICatalogProvider for that RDBMS is needed.
In short, the goal of DTP is to provide an extensible framework and only
Derby exemplary implementation is provided. As an open source project, the
success of DTP relies heavily on the community involvement. We truely
welcome and encourage people to contribute to this project.

Thanks & Regards!

Hui Cao
DTP SQL Dev Tools Committer
Sybase, Inc.
Re: Don't see any results in SQL Results view [message #9393 is a reply to message #9368] Tue, 07 March 2006 08:48 Go to previous messageGo to next message
Hui Cao is currently offline Hui CaoFriend
Messages: 14
Registered: July 2009
Junior Member
BTW, we've also noticed that filtering out the SQL results by default is
not user -friendly and we'll fix it soon.
Re: Don't see any results in SQL Results view [message #9415 is a reply to message #9393] Wed, 08 March 2006 05:38 Go to previous message
Dafan Yang is currently offline Dafan YangFriend
Messages: 2
Registered: July 2009
Junior Member
Hui Cao wrote:

> BTW, we've also noticed that filtering out the SQL results by default is
> not user -friendly and we'll fix it soon.

Already fixed this filter problem.
Re: Don't see any results in SQL Results view [message #571161 is a reply to message #9298] Tue, 07 March 2006 08:32 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 14
Registered: July 2009
Junior Member
Hi Tomer,
Please inline comments below:

Tomer Mahlin wrote:

> Hello,

> I am seeking you advice on running SQL Development Tools component. In
> addition I would like to ask a couple of questions regarding DTP
> functionality.

> 1. Problem with SQL Development Tools component.

> I am currently conducting BiDi (Hebrew + Arabic) test of DTP (a subset of
> GVT). Running TCs created by Hui Cao (which I downloaded from GSA:
>
/gsa/rtpgsa/projects/w/wswb/anonymous/in/IES_3.2_EnablementT estCases/DATATOOL/attachment.pdf)
> for SQL Development Tools I see that none of the SQL queries executed
> against Derby / MS SQL / DB2 RDBMS do not produce any results in the SQL
> Results view. I suspect that this might occur due to the fact that I don't
> have lpg.jar file installed as explained on those pages:
> http://www.eclipse.org/datatools/project_sqldevtools/index.h tml
>
http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/sqlqueryparser_lpg_readme.html
> Unfortunately I could not locate this file on this site:
> https://testcase.boulder.ibm.com/
> Would you please let me know if missing lpg.jar file can cause the
> described behavior (lack of results in SQL Results view) and if so where I
> can find this jar file (what is its exact path on the
> https://testcase.boulder.ibm.com/ site) ?

Your problem has nothing to do with lpg.jar. It's because SQL Results
View filters out the results. You can go to "Filters" menu in SQL Results
View to check on your connection profile.

> 2. DTP Functionality related questions.
> a. Interestingly enough you can add connections to various RDBMS from
> Data Source Explorer ( I tried and was successful with Derby, DB2, MS
> SQL). However, you can not associate sql script with any of those
> connection except for connections to Derby RDBMS (the association is via
> Set Connection Info option available in the context menu from SQL editor).
> Is this a temporary restriction or it is part of the design ?

SQL Dev Tools defines an extensible and reusable framework that needs
vendor-specific add-ons to enable the editing/debugging features.
Currently we only provide a exemplary Derby implementation.


> b. Using Run you can create Eclipse Data Tools configurations with
> profiles defining connections not only to Derby RDBMS but also to other
> RDBMS (e.g. DB2, MS SQL). Does it mean that running SQL queries from Run
> dialog against those RDBMS are supported while from SQL editor it is not ?

As mentioned above, in Data Tools launch configuration dialog,
non-supported RDBMS connection profiles should be filtered out. I've
checked in the code to make the launch configuration and editor in sync.


> c. Stored procedures appear in Data Source Explorer only for Derby
> RDBMS. For MS SQL and DB2 they don't appear at all. Is this an expected
> behavior ?

Although you can create connection profiles for other databases, to see
the catalog objects in DSE, an ICatalogProvider for that RDBMS is needed.
In short, the goal of DTP is to provide an extensible framework and only
Derby exemplary implementation is provided. As an open source project, the
success of DTP relies heavily on the community involvement. We truely
welcome and encourage people to contribute to this project.

Thanks & Regards!

Hui Cao
DTP SQL Dev Tools Committer
Sybase, Inc.
Re: Don't see any results in SQL Results view [message #571174 is a reply to message #9368] Tue, 07 March 2006 08:48 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 14
Registered: July 2009
Junior Member
BTW, we've also noticed that filtering out the SQL results by default is
not user -friendly and we'll fix it soon.
Re: Don't see any results in SQL Results view [message #571184 is a reply to message #9393] Wed, 08 March 2006 05:38 Go to previous message
Dafan Yang is currently offline Dafan YangFriend
Messages: 2
Registered: July 2009
Junior Member
Hui Cao wrote:

> BTW, we've also noticed that filtering out the SQL results by default is
> not user -friendly and we'll fix it soon.

Already fixed this filter problem.
Previous Topic:M3 Build Available
Next Topic:Installation Problem
Goto Forum:
  


Current Time: Fri Nov 21 19:30:26 GMT 2014

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

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