|
| Re: Don't see any results in SQL Results view [message #9368 is a reply to message #9298] |
Tue, 07 March 2006 08:32   |
 Hui Cao
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 #571161 is a reply to message #9298] |
Tue, 07 March 2006 08:32 |
Hui Cao
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.
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03068 seconds
] 
Search
Help
Register
Login
Home
