Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » New Data Set - Incomplete database results
New Data Set - Incomplete database results [message #18048] Thu, 29 June 2006 18:12 Go to next message
Eclipse UserFriend
Originally posted by: al.luego.gmail.com

Side: I'm not sure what you call them. It's the window under "Available
Items:" when defining a query. The window contains the database name
with groups, tables, and fields. For this post I'm calling it "database".
(Groups being the "nodes"?, "schema?")

Problem: In creating a new data set there is only part of the database
that shows. The dbname.dbo "group" contains around 100 tables, most of
which have 30+ fields. The results in the "Available Items:" windows
shows less than half of the tables I know exist. This occurs for both
Microsoft's JDBC driver and jTDS JDBC driver - no difference of results.

Details:

Installation location = c:\BIRT

Installed packages =
eclipse-SDK-3.2RC7-win32.zip
emf-sdo-xsd-SDK-2.2.0RC9a.zip
GEF-ALL-3.2.zip
birt-report-framework-2.1RC6.zip
dtp_0.9RC5_N061606.zip

itext-1.3.jar was installed correctly.

Created c:\BIRT\jdbc drivers
Added jdbc drivers =
jtds-1.2.jar
msbase.jar
mssqlserver.jar
msutil.jar

Driver Class, URL, and other details in setting up the drivers appear to
be correct since the "check connection" attempts were successful.


Note: SQLExplorer is not installed. I was not sure that there is a
version of that plug-in for Eclipse 3.2.

Developer Plug-In perspective shows no errors in the error log.


The following google searches did not provide anything I could recognize:
eclipse 3.2 query not full database
eclipse 3.2 incomplete data set
eclipse 3.2 jdbc partial connection

I did find a jTDS and MS SQL Driver question by Neil Bartlett from mid
May 06 but it doesn't appear to be the same thing.

I appreciate any help you could provide.
Re: New Data Set - Incomplete database results (resolved) [message #18823 is a reply to message #18048] Wed, 05 July 2006 13:42 Go to previous message
Eclipse UserFriend
Originally posted by: al.luego.gmail.com

I guess this was a BIRT issue not DTP, but for anyone searching for this
later...

FIX for limited tables appearing: Window > Preferences > Report Design >
Data Set Editor > JDBC Data Set : Change "Max # of tables in each
schema to display".
https://bugs.eclipse.org/bugs/show_bug.cgi?id=149342 (has a screenshot)


NetCog wrote:
> Side: I'm not sure what you call them. It's the window under "Available
> Items:" when defining a query. The window contains the database name
> with groups, tables, and fields. For this post I'm calling it "database".
> (Groups being the "nodes"?, "schema?")
>
> Problem: In creating a new data set there is only part of the database
> that shows. The dbname.dbo "group" contains around 100 tables, most of
> which have 30+ fields. The results in the "Available Items:" windows
> shows less than half of the tables I know exist. This occurs for both
> Microsoft's JDBC driver and jTDS JDBC driver - no difference of results.
>
> Details:
>
> Installation location = c:\BIRT
>
> Installed packages =
> eclipse-SDK-3.2RC7-win32.zip
> emf-sdo-xsd-SDK-2.2.0RC9a.zip
> GEF-ALL-3.2.zip
> birt-report-framework-2.1RC6.zip
> dtp_0.9RC5_N061606.zip
>
> itext-1.3.jar was installed correctly.
>
> Created c:\BIRT\jdbc drivers
> Added jdbc drivers =
> jtds-1.2.jar
> msbase.jar
> mssqlserver.jar
> msutil.jar
>
> Driver Class, URL, and other details in setting up the drivers appear to
> be correct since the "check connection" attempts were successful.
>
>
> Note: SQLExplorer is not installed. I was not sure that there is a
> version of that plug-in for Eclipse 3.2.
>
> Developer Plug-In perspective shows no errors in the error log.
>
>
> The following google searches did not provide anything I could recognize:
> eclipse 3.2 query not full database
> eclipse 3.2 incomplete data set
> eclipse 3.2 jdbc partial connection
>
> I did find a jTDS and MS SQL Driver question by Neil Bartlett from mid
> May 06 but it doesn't appear to be the same thing.
>
> I appreciate any help you could provide.
Re: New Data Set - Incomplete database results (resolved) [message #580603 is a reply to message #18048] Wed, 05 July 2006 13:42 Go to previous message
Eclipse UserFriend
Originally posted by: al.luego.gmail.com

I guess this was a BIRT issue not DTP, but for anyone searching for this
later...

FIX for limited tables appearing: Window > Preferences > Report Design >
Data Set Editor > JDBC Data Set : Change "Max # of tables in each
schema to display".
https://bugs.eclipse.org/bugs/show_bug.cgi?id=149342 (has a screenshot)


NetCog wrote:
> Side: I'm not sure what you call them. It's the window under "Available
> Items:" when defining a query. The window contains the database name
> with groups, tables, and fields. For this post I'm calling it "database".
> (Groups being the "nodes"?, "schema?")
>
> Problem: In creating a new data set there is only part of the database
> that shows. The dbname.dbo "group" contains around 100 tables, most of
> which have 30+ fields. The results in the "Available Items:" windows
> shows less than half of the tables I know exist. This occurs for both
> Microsoft's JDBC driver and jTDS JDBC driver - no difference of results.
>
> Details:
>
> Installation location = c:\BIRT
>
> Installed packages =
> eclipse-SDK-3.2RC7-win32.zip
> emf-sdo-xsd-SDK-2.2.0RC9a.zip
> GEF-ALL-3.2.zip
> birt-report-framework-2.1RC6.zip
> dtp_0.9RC5_N061606.zip
>
> itext-1.3.jar was installed correctly.
>
> Created c:\BIRT\jdbc drivers
> Added jdbc drivers =
> jtds-1.2.jar
> msbase.jar
> mssqlserver.jar
> msutil.jar
>
> Driver Class, URL, and other details in setting up the drivers appear to
> be correct since the "check connection" attempts were successful.
>
>
> Note: SQLExplorer is not installed. I was not sure that there is a
> version of that plug-in for Eclipse 3.2.
>
> Developer Plug-In perspective shows no errors in the error log.
>
>
> The following google searches did not provide anything I could recognize:
> eclipse 3.2 query not full database
> eclipse 3.2 incomplete data set
> eclipse 3.2 jdbc partial connection
>
> I did find a jTDS and MS SQL Driver question by Neil Bartlett from mid
> May 06 but it doesn't appear to be the same thing.
>
> I appreciate any help you could provide.
Previous Topic:ODA Extension - how to access Data Source properties?
Next Topic:Problem using Serena Plugin for Eclipse.
Goto Forum:
  


Current Time: Fri Mar 29 12:39:37 GMT 2024

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

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

Back to the top