Re: How to detect views w/ JDBC?

From: Bob Bunch (OCP) <bunchb_at_hotmail.com>
Date: Mon, 18 Apr 2005 15:17:45 -0400
Message-Id: <pan.2005.04.18.19.17.42.31000@hotmail.com>

On Mon, 18 Apr 2005 14:39:05 +0000, HansF wrote:

> On Mon, 18 Apr 2005 08:15:46 -0400, Bob Bunch (OCP) interested us by
> writing:
>

>> 
>> Bottom line - please _fully_ read my situation befoe telling me to do
>> bunch of Oracle-specific stuff.  I would just LOVE it if I could ONLY EVER
>> support Oracle - I have 99.9% of my experience w/ this great platform;
>> however, this is not my current reality for this particular project.  If
>> you don't know how to do this, I appreciate your help, but please don't
>> just tell me how to do it w/ Oracle-specifics.  I already know that. ;)

>
> You're right - I didn't read (just skimmed) the original.
>
> However, I was responding to your dismisal of Jim's comment. The validity
> of his comment has been proven to me several times as I have seen costs
> soar by trying to maintain projects that attempt platform independence
> from bottom up.
>
> Therefore, I still encourage you to use techniques similar to those
> organizations (such as Oracle) that have experience in being platform
> agnostic. Rather than compromise to the common denominator, they tend to define
> define an API and write platform-optimal stuff under that API, either
> compiled into th distribution or selectable at run time. More work, but
> also more reliable and flexible, and less expensive, in the long run. And
> that might be worth while.
>
> But you already know that ...
> /Hans

Ya, I just needed a way of finding views w/o resorting to "select view_name from user_views" ;) Pulling from DatabaseMetaData.getTables() does just that.

And believe it or not, I have to stay platform agnostic NOT because of "religious java zealots" (hehe), but because we actually DO have to run the same stuff on different DB vendors. We don't have time to piddle around w/ vendor-specifics (unfortunately!) Believe me, if we did, I'd be making FULL use of all the goodies in the Oracle locker!

Thanks, though! :) Received on Mon Apr 18 2005 - 14:17:45 CDT