Erroneous type when using getColumnType for a BLOB column in JDBC - Mailing list pgsql-interfaces

From Rocio "Escaño" Villalba
Subject Erroneous type when using getColumnType for a BLOB column in JDBC
Date
Msg-id 20000905140340.2839.qmail@web5505.mail.yahoo.com
Whole thread Raw
List pgsql-interfaces
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/


pgsql-interfaces by date:

Previous
From: James Kewin
Date:
Subject: Pasing Cursors
Next
From: Zeljko Trogrlic
Date:
Subject: RE: JDBC isNullable is not working