Eclipse Community Forums: BIRT » How do I limit the data set to a particular schema for Oracle JDBC connection?

Home » Archived » BIRT » How do I limit the data set to a particular schema for Oracle JDBC connection?

How do I limit the data set to a particular schema for Oracle JDBC connection? [message #44804]

Thu, 09 June 2005 21:42

Eclipse User

When I define a data set on Oracle JDBC data source, I get an error popup
that "only 500 items can be viewed in the available list. There are more
than 500 items in the data source. Please specify a filter to search for
specific items." The data set Available Items list shows multiple schemas
and their associated tables. How do I limit the data set to a particular
schema?

Also, what is the format of the Filter field on the Query tab?

Re: How do I limit the data set to a particular schema for Oracle JDBC connection? [message #45825 is a reply to message #44804]

Tue, 14 June 2005 14:41

Eclipse User

There is currently no way to limit the table list to within one or more
schemas. This does sounds like a good thing to have though. I suggest that
you file an enhancement request in Bugzilla if you'd like BIRT engineers to
look into adding this.

The Filter field in the Query Editor's table list accepts a SQL pattern
matching string. Only tables (in all schema) with names matching this
pattern will be listed. The pattern format is DB specific. For example, in
MS Server Server, % matches any substring while _ matches any single
character. Check the Oracle documentation to see what works there.

-

Gary Xue

BIRT Committer

"Bill Brooks" <billbr@genesyslab.com> wrote in message
news:1d375bb9d7eb5fef86fded17f514215c$1@www.eclipse.org...
> When I define a data set on Oracle JDBC data source, I get an error popup
> that "only 500 items can be viewed in the available list. There are more
> than 500 items in the data source. Please specify a filter to search for
> specific items." The data set Available Items list shows multiple schemas
> and their associated tables. How do I limit the data set to a particular
> schema?
>
> Also, what is the format of the Filter field on the Query tab?
>
>

Previous Topic:	Changing Property Edit Window
Next Topic:	Getting database information from a datasource

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 16 12:38:30 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter