Eclipse Community Forums: BIRT » Unable to get All Table Name in DataSet after successfull connection to Oracle DB

Home » Archived » BIRT » Unable to get All Table Name in DataSet after successfull connection to Oracle DB(I am unable to find few tables in DataSet)

Show: Today's Messages :: Show Polls :: Message Navigator

Unable to get All Table Name in DataSet after successfull connection to Oracle DB [message #1708383]

Wed, 16 September 2015 07:24

aashish kumar

Messages: 7
Registered: September 2015

Junior Member

Hello,

I created a Data Source to connect to an Oracle DB. The Connection was successfull.
Now when i try to create DataSet, In Query Tab, in Available Items, I cannot find all tables.

I connected to DB on platform, but there I can see the required table:

SQL> select tname from tab where tname like '%ABC%';

TNAME
------------------------------
ABC

Report message to a moderator

Re: Unable to get All Table Name in DataSet after successfull connection to Oracle DB [message #1708528 is a reply to message #1708383]

Thu, 17 September 2015 10:10

donino donino

Messages: 183
Registered: July 2011

Senior Member

By default i believe it is limited to 50 items. In your Eclipse designer change this limit here

Windows -> preferences -> Report design -> Dataset Editor -> JDBC Dataset -> Property "Maximum number of tables"

Report message to a moderator