Re: WebFocus and Oracle Views
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: Richard Goulet <Richard.Goulet@xxxxxxxxxxx>
- Date: Wed, 5 Jan 2011 22:30:58 +0100
In worst case, you can trace (or guess) what WebFocus is using to get it
information about 'tables' and spoof these: just create your own view
USER_TABLES in the schema the WebFocus uses to gather all the information and
union USER_TABLES and USER_VIEWS there? It's not very polite and I'd call it a
way of bad coding (and therefore should be documented very well) but it should
work fine!
Martin
Am 05.01.2011 um 15:01 schrieb <Dominic.Brooks@xxxxxxxxxxxxxxxxxxx>
<Dominic.Brooks@xxxxxxxxxxxxxxxxxxx>:
> It might be revealing to trace what WebFocus is doing that means it can’t use
> a view (allegedly).
>
> From what little documentation there is publically available, who knows what
> the “SQL Translation” layer does.
> But it’s not impossible that it’s doing some sort of lookup against something
> like USER_TABLES as it “translates SQL to an internal, canonical form” and
> then back to “specific SQL dialects supported by proprietary RDBMSs” –
> “whatever”.
>
> However, it also looks like it can operate with straight “SQL Pass through”
> so maybe this would avoid any source of the problem.
>
> But, my first reaction is that some sort of lookup is involved and that
> causes the problem – find the lookup and you’re at least part of the way to
> thinking about ways to avoid the issue.
>
> Cheers,
> Dominic
>
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Goulet, Richard
> Sent: 05 January 2011 12:29
> To: oracle-l@xxxxxxxxxxxxx
> Subject: WebFocus and Oracle Views
>
> Guys and Gals,
>
> I've a WebFocus developer here who is telling mew that he cannot use
> a view to query data from the database. The app developers have created and
> tuned these views to the n'th degree so that they provide correct data
> quickly ( I have to pat these folks on the back as they really did work hard
> on them). Anyway this duhveloper wants to create MV's out of them so that
> "WebFocus will behave as expected" and he is absolutely adamant about it to
> the point that he has not started his work because "we won't let him create
> his MV's". BTW: he wants to refresh these at 1 minute intervals and they
> will require a full refresh. I've searched the WEB and even talked to a
> couple of others that I know who've used WebFocus and can't find anything
> that in any way substantiates what this person is telling me. In a bit of
> frustration with him I'm turning to the list to see if any of you have ever
> heard or seen anything along these lines. All replies are appreciated. As I
> understand it it's WebFocus 7.0 on Linux RH5 using an Oracle 11.1.0.7 backend
> database also on RH.
>
> Thanks in advance.
>
> Dick Goulet
> Senior Oracle DBA
>
>
> _______________________________________________
>
> This e-mail may contain information that is confidential, privileged or
> otherwise protected from disclosure. If you are not an intended recipient of
> this e-mail, do not duplicate or redistribute it by any means. Please delete
> it and any attachments and notify the sender that you have received it in
> error. Unless specifically indicated, this e-mail is not an offer to buy or
> sell or a solicitation to buy or sell any securities, investment products or
> other financial product or service, an official confirmation of any
> transaction, or an official statement of Barclays. Any views or opinions
> presented are solely those of the author and do not necessarily represent
> those of Barclays. This e-mail is subject to terms available at the following
> link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent
> to the foregoing. Barclays Capital is the investment banking division of
> Barclays Bank PLC, a company registered in England (number 1026167) with its
> registered office at 1 Churchill Place, London, E14 5HP. This email may
> relate to or be sent from other members of the Barclays Group.
> _______________________________________________
Other related posts:
