Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » JDBC Mysql connection
icon4.gif  JDBC Mysql connection [message #546241] Mon, 12 July 2010 05:29 Go to next message
Max is currently offline Max
Messages: 3
Registered: July 2010
Junior Member
Hello.
I need to connect to the database and i use mysql-connector-java-5.1.8 driver to do it as well. I made JDBC connection, than entered valid information in all text fields. I tested the connection and its was successful. But when i created new data set, there were not all the tables from a my DB, there was only a half of all. Why is it so? And how can i solve this problem?
Thank you.
Re: JDBC Mysql connection [message #546996 is a reply to message #546241] Wed, 14 July 2010 17:48 Go to previous message
Scott Rosenbaum is currently offline Scott Rosenbaum
Messages: 425
Registered: July 2009
Senior Member
Max,

BIRT is trying to save you from a long process spent interrogating the DB
for all its objects, so it has limits to how many items it will display.
To override the default behavior, follow this trail from the menu.

Window => Preferences => Report Design => DataSet Editor => JDBC Data Set
=> adjust max number of tables/schema as appropriate.

Scott Rosenbaum
Innovent Solutions, BIRT PMC

> Hello.
>
> I need to connect to the database and i use mysql-connector-java-5.1.8
> driver to do it as well. I made JDBC connection, than entered valid
> information in all text fields. I tested the connection and its was
> successful. But when i created new data set, there were not all the
> tables from a my DB, there was only a half of all. Why is it so? And
> how can i solve this problem?
>
> Thank you.
>
Previous Topic:Emitter file extension
Next Topic:Grouping problem
Goto Forum:
  


Current Time: Thu Jul 24 13:43:16 EDT 2014

Powered by FUDForum. Page generated in 0.02438 seconds