New Data Set - Incomplete database results [message #18048] |
Thu, 29 June 2006 18:12 |
Eclipse User |
|
|
|
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 |
Eclipse User |
|
|
|
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 |
Eclipse User |
|
|
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.03247 seconds