How to detect views w/ JDBC?

From: Bob Bunch (OCP) <bunchb_at_hotmail.com>
Date: Sun, 17 Apr 2005 22:40:47 -0400
Message-Id: <pan.2005.04.18.02.40.46.266000@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! Received on Sun Apr 17 2005 - 21:40:47 CDT