BIRT- Oracle Schema Referenced Not Shown [message #527627] |
Thu, 15 April 2010 19:47 |
Eclipse User |
|
|
|
Originally posted by: tubahrens.gmail.com
I have successfully added and connected to an Oracle database but the tables
and views i have are not available to the report. When i right mouse click
on the dataset builder i can only see my individual schema which has no
tables. My user has access to read other tables and I can access them
through Oracle in eaither TOAD, SQL Plus or Eclipse DB Perspective and query
so long as I preface the table with the schema smae. This is not working in
the query through the data set definition though.
Any suggestions would be most welcome.
|
|
|
Re: BIRT- Oracle Schema Referenced Not Shown [message #527830 is a reply to message #527627] |
Fri, 16 April 2010 15:03 |
|
Byron,
Take a look at this bug:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=91425
I doubt this is your issue, but can you open a bug specifying which
oracle driver you are using and what version of BIRT you are using?
Jason
Byron Ahrens wrote:
> I have successfully added and connected to an Oracle database but the tables
> and views i have are not available to the report. When i right mouse click
> on the dataset builder i can only see my individual schema which has no
> tables. My user has access to read other tables and I can access them
> through Oracle in eaither TOAD, SQL Plus or Eclipse DB Perspective and query
> so long as I preface the table with the schema smae. This is not working in
> the query through the data set definition though.
>
> Any suggestions would be most welcome.
>
>
|
|
|
Re: BIRT- Oracle Schema Referenced Not Shown [message #528712 is a reply to message #527830] |
Wed, 21 April 2010 14:42 |
Eclipse User |
|
|
|
Originally posted by: tubahrens.gmail.com
Thanks. it is similar but I do not see any drop down list. my user has no
schemas directly but has access rights to other schemas. in oracle's
plug-in I can see the data schema's without filters but in BIRT I cannot see
a way to turn the user filter off.
"Jason Weathersby" <jasonweathersby@windstream.net> wrote in message
news:hq9u1m$l14$1@build.eclipse.org...
> Byron,
>
> Take a look at this bug:
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=91425
>
> I doubt this is your issue, but can you open a bug specifying which oracle
> driver you are using and what version of BIRT you are using?
>
> Jason
>
> Byron Ahrens wrote:
>> I have successfully added and connected to an Oracle database but the
>> tables and views i have are not available to the report. When i right
>> mouse click on the dataset builder i can only see my individual schema
>> which has no tables. My user has access to read other tables and I can
>> access them through Oracle in eaither TOAD, SQL Plus or Eclipse DB
>> Perspective and query so long as I preface the table with the schema
>> smae. This is not working in the query through the data set definition
>> though.
>>
>> Any suggestions would be most welcome.
|
|
|
Re: BIRT- Oracle Schema Referenced Not Shown [message #528785 is a reply to message #528712] |
Wed, 21 April 2010 18:03 |
|
Byron,
Did you open a bug specifying the driver?
Also can you try the JDBC Database connection for Query
Builder[Prototype] datasource?
Jason
Byron Ahrens wrote:
> Thanks. it is similar but I do not see any drop down list. my user has no
> schemas directly but has access rights to other schemas. in oracle's
> plug-in I can see the data schema's without filters but in BIRT I cannot see
> a way to turn the user filter off.
>
>
> "Jason Weathersby" <jasonweathersby@windstream.net> wrote in message
> news:hq9u1m$l14$1@build.eclipse.org...
>> Byron,
>>
>> Take a look at this bug:
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=91425
>>
>> I doubt this is your issue, but can you open a bug specifying which oracle
>> driver you are using and what version of BIRT you are using?
>>
>> Jason
>>
>> Byron Ahrens wrote:
>>> I have successfully added and connected to an Oracle database but the
>>> tables and views i have are not available to the report. When i right
>>> mouse click on the dataset builder i can only see my individual schema
>>> which has no tables. My user has access to read other tables and I can
>>> access them through Oracle in eaither TOAD, SQL Plus or Eclipse DB
>>> Perspective and query so long as I preface the table with the schema
>>> smae. This is not working in the query through the data set definition
>>> though.
>>>
>>> Any suggestions would be most welcome.
>
>
|
|
|
Re: BIRT- Oracle Schema Referenced Not Shown [message #528786 is a reply to message #528785] |
Wed, 21 April 2010 18:20 |
Eclipse User |
|
|
|
Originally posted by: tubahrens.gmail.com
I wanted to make sure I could reproduce the issue prior to writing a bug. I
have been using both JDBC drivers with the same effect but I will try again
with steps to reproduce.
"Jason Weathersby" <jasonweathersby@windstream.net> wrote in message
news:hqnef1$b9e$3@build.eclipse.org...
> Byron,
>
> Did you open a bug specifying the driver?
> Also can you try the JDBC Database connection for Query Builder[Prototype]
> datasource?
>
>
> Jason
>
> Byron Ahrens wrote:
>> Thanks. it is similar but I do not see any drop down list. my user has
>> no schemas directly but has access rights to other schemas. in oracle's
>> plug-in I can see the data schema's without filters but in BIRT I cannot
>> see a way to turn the user filter off.
>>
>>
>> "Jason Weathersby" <jasonweathersby@windstream.net> wrote in message
>> news:hq9u1m$l14$1@build.eclipse.org...
>>> Byron,
>>>
>>> Take a look at this bug:
>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=91425
>>>
>>> I doubt this is your issue, but can you open a bug specifying which
>>> oracle driver you are using and what version of BIRT you are using?
>>>
>>> Jason
>>>
>>> Byron Ahrens wrote:
>>>> I have successfully added and connected to an Oracle database but the
>>>> tables and views i have are not available to the report. When i right
>>>> mouse click on the dataset builder i can only see my individual schema
>>>> which has no tables. My user has access to read other tables and I can
>>>> access them through Oracle in eaither TOAD, SQL Plus or Eclipse DB
>>>> Perspective and query so long as I preface the table with the schema
>>>> smae. This is not working in the query through the data set definition
>>>> though.
>>>>
>>>> Any suggestions would be most welcome.
>>
|
|
|
Re: BIRT- Oracle Schema Referenced Not Shown [message #528943 is a reply to message #528786] |
Thu, 22 April 2010 13:13 |
Eclipse User |
|
|
|
Originally posted by: tubahrens.gmail.com
It turns out it is the oracle jdbc driver that causes the issue. The
default 10G driver seems to not default to filtering by user schema.
"Byron Ahrens" <tubahrens@gmail.com> wrote in message
news:hqnfl4$k9s$1@build.eclipse.org...
>I wanted to make sure I could reproduce the issue prior to writing a bug.
>I have been using both JDBC drivers with the same effect but I will try
>again with steps to reproduce.
>
>
> "Jason Weathersby" <jasonweathersby@windstream.net> wrote in message
> news:hqnef1$b9e$3@build.eclipse.org...
>> Byron,
>>
>> Did you open a bug specifying the driver?
>> Also can you try the JDBC Database connection for Query
>> Builder[Prototype] datasource?
>>
>>
>> Jason
>>
>> Byron Ahrens wrote:
>>> Thanks. it is similar but I do not see any drop down list. my user has
>>> no schemas directly but has access rights to other schemas. in oracle's
>>> plug-in I can see the data schema's without filters but in BIRT I cannot
>>> see a way to turn the user filter off.
>>>
>>>
>>> "Jason Weathersby" <jasonweathersby@windstream.net> wrote in message
>>> news:hq9u1m$l14$1@build.eclipse.org...
>>>> Byron,
>>>>
>>>> Take a look at this bug:
>>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=91425
>>>>
>>>> I doubt this is your issue, but can you open a bug specifying which
>>>> oracle driver you are using and what version of BIRT you are using?
>>>>
>>>> Jason
>>>>
>>>> Byron Ahrens wrote:
>>>>> I have successfully added and connected to an Oracle database but the
>>>>> tables and views i have are not available to the report. When i right
>>>>> mouse click on the dataset builder i can only see my individual schema
>>>>> which has no tables. My user has access to read other tables and I
>>>>> can access them through Oracle in eaither TOAD, SQL Plus or Eclipse DB
>>>>> Perspective and query so long as I preface the table with the schema
>>>>> smae. This is not working in the query through the data set
>>>>> definition though.
>>>>>
>>>>> Any suggestions would be most welcome.
>>>
>
|
|
|
Powered by
FUDForum. Page generated in 0.02550 seconds