For example, the JDBC standard has the setObject (int index, Object o, int targetSqlType) method. Is the chart supposed to reflect the kind of column that can be reasonably expected to hold a value sent in via this method? That is, if I do setObject(1, obj, Types.LONGVARCHAR) on Oracle, I can expect that the database will try to insert an Oracle LONG datatype?
Is the chart two ways? That is, if I select from an Oracle LONG column, should I expect to get back a value with a java.sql.Type of LONGVARCHAR?

###@###.### 2004-02-02