Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Dataset results are incomplete(SQL database Dataset setup with JDBC)
Dataset results are incomplete [message #1004116] Tue, 22 January 2013 16:00 Go to next message
Steve Hernandez is currently offline Steve HernandezFriend
Messages: 1
Registered: January 2013
Junior Member
My connecton to a SQL database seems to be made but when I create a new data set it returns an incomplete tables list. It is from a Maximo asset management system and sent to me as maxdb75.bak. I restored the file in MS SQL server 2012 and can see all the tables there. When I set up a datasource and data set in BIRT I only get aboout 10% of the table list. My driver is: com.microsoft.sqlserver.jdbc.SQLServerDriver ( v4.0) and my URL is: jdbc:sqlserver://JAS1LT00130;databaseName=maxdb75
Re: Dataset results are incomplete [message #1004691 is a reply to message #1004116] Wed, 23 January 2013 17:11 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1663
Registered: July 2009
Senior Member

Go to Window->Preferences->Report Design->JDBC Data Set and increase your limit for visible tables/schemas.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Dataset results are incomplete [message #1058409 is a reply to message #1004691] Tue, 14 May 2013 02:19 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1663
Registered: July 2009
Senior Member

You're very welcome. Let us know whenever you have questions! Smile

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Dataset results are incomplete [message #1064487 is a reply to message #1058409] Wed, 19 June 2013 13:22 Go to previous messageGo to next message
Joe Gilvary is currently offline Joe GilvaryFriend
Messages: 2
Registered: June 2013
Junior Member
I'm seeing the same sort of issue now, but with a twist. I'm using BIRT 2.6.2 because it's the only officially supported version for creating reports with HP's WebInspect Enterprise vulnerability scanner.

I have a good connection to our SQLServer 2008 with the com.microsoft.sqlserver.jdbc.SQLServerDriverv 4.0 jdbc driver, but I only see a subset of the tables and views. I've set the max number of schemas to 200 and max number of tables in each to 500 for the display. Even after restarting Eclipse, it has no effect.

Any ideas what else I can try?

TIA,

Joe
Re: Dataset results are incomplete [message #1064537 is a reply to message #1064487] Wed, 19 June 2013 18:28 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1663
Registered: July 2009
Senior Member

How many are you expecting and how many are you seeing? If you write a query for one that you don't see, does the query still run? If so, I know you are bound to 2.6.2, but can you try a different version just to see if you get a different result?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Dataset results are incomplete [message #1064646 is a reply to message #1064537] Thu, 20 June 2013 11:52 Go to previous messageGo to next message
Joe Gilvary is currently offline Joe GilvaryFriend
Messages: 2
Registered: June 2013
Junior Member
Thank you, Michael.

My bad. I was looking for the wrong views. Once I started looking in the correct database for the correct views, the problem disappeared. Magic! Embarrassed

Thanks,

Joe
Re: Dataset results are incomplete [message #1064784 is a reply to message #1064646] Fri, 21 June 2013 06:15 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1663
Registered: July 2009
Senior Member

Ah. Well, it's better to be something simple like that rather than an issue you couldn't get around. Smile Let us know whenever you have questions!

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:Sorting bar chart based on y-axis values
Next Topic:populate a lsitbox or radio button
Goto Forum:
  


Current Time: Mon Nov 24 12:42:03 GMT 2014

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

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