Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to get column data types from meta data.

837693Feb 7 2011 — edited Feb 8 2011

Hi,
Has anybody seen an issue retrieving column information on tables/views in a database using Oracle thin driver? I am using ojdbc6.zip accessing an Oracle 11g database. The returned column data type on some of the views are invalid. The problem is not specific to the Java applicaiton I am using. I am also able to see the problem using other Java applications such as SQL Squirrel. When viewing objects in Squirrel, the column type for some of the views show up as Undefined. To be more specific, the data_type returned is set to 1111 and the type_name is UNDEFINED. The data type I am expecting is VARCHAR.

When I query the dba_tab_columns for the underlying tables which the view based on, it reports correct data types.

Any suggestions?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2011

Added on Feb 7 2011

#java-database-connectivity-jdbc

3 comments

711 views