Thread: Erroneous type when using getColumnType for a BLOB column in JDBC

Erroneous type when using getColumnType for a BLOB column in JDBC

From
Rocio "Escaño" Villalba
Date:
Hi!

I'm using a column of blob type (oid type) in a table
of postgresql.

I have a program, in JDBC, that executes any SQL query
sentence with parameters (PreparedStatement), and I
use the ResultMetaData type and its method, 
getColumnType, to know which is the type of the column
that the query returns.

But, for the blob column, getColumnType returns an
java.sql.Types.INTEGER instead of a
java.sql.Types.BLOB type.

Do you know which is the reason of this? Why
PostgreSQL driver does not detect a column
of blob type when using getColumnType?

I don't know if I've explained well myself, let me
know if you don't understand me.

Thanks in advance!

Rocio Esca�o

__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/