Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to detect views w/ JDBC?
"Bob Bunch (OCP)" <bunchb_at_hotmail.com> wrote in message
news:pan.2005.04.18.02.40.46.266000_at_hotmail.com...
> I'm trying to figure out how to tell if a given table (given "select *
> from someTableName") using JDBC/Thin is a view. I've tried using
>
> ResultSetMetaData.isReadOnly(int column)
> ResultSetMetaData.isWritable(int column)
> ResultSetMetaData.isDefinitelyWritable(int column)
>
> ...all of which return the same result for a view as a table. Doesn't
> matter if it's a simple or complex view.
>
> I can't employ an Oracle-specific solution for this problem (that'd be WAY
> to simple ;) - this needs to be DB agnostic (aka pure JDBC).
>
> Any ideas?
>
> Thanks!
>
Run from this point of view. You are going for the lowest common
denominator and it is going to bite you in the tender regions. You are only
going to enrich the hardware vendor's pockets because you are going to
implement a very unscalable solution.
Jim
Received on Sun Apr 17 2005 - 21:49:10 CDT