Skip to main content



      Home
Home » Archived » BIRT » JDBC Mysql connection
icon4.gif  JDBC Mysql connection [message #546241] Mon, 12 July 2010 05:29 Go to next message
Eclipse UserFriend
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
Eclipse UserFriend
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: Wed Jul 23 15:07:50 EDT 2025

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

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

Back to the top