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).
Also - this is for a code generator, NOT a to-be-live application. I'm
generating classes based on a given schema's tables/views, and need to
determine WHAT a given entity is, so I can NOT generate
insert/update/delete methods if the entity is a view.
Any ideas?
Thanks!
Arnaud Berger - 18 Apr 2005 13:37 GMT
Hi,
getTables(...) from DatabaseMetaData seems to do the job :
http://www.jguru.com/faq/view.jsp?EID=1181
Regards,
Arnaud
> 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
[quoted text clipped - 16 lines]
>
> Thanks!
Bob Bunch (OCP) - 18 Apr 2005 15:06 GMT
> Hi,
>
[quoted text clipped - 26 lines]
>>
>> Thanks!
Yup! Thanks for the tip! ;)