On Mon, 18 Apr 2005 15:11:20 +0200, Thomas Kellerer wrote:
> On 18.04.2005 04:40 Bob Bunch (OCP) wrote:
>
>> 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!
>>
>
> DatabaseMetaData.getTables(null, null, null, new String[] {"VIEW"});
>
> Thomas
Thanks for the tip! Exactly what I needed!
Received on Mon Apr 18 2005 - 09:04:28 CDT