Erroneous type when using getColumnType for a BLOB column in JDBC

Поиск
Список
Период
Сортировка
От Rocio "Escaño" Villalba
Тема Erroneous type when using getColumnType for a BLOB column in JDBC
Дата
Msg-id 20000905140340.2839.qmail@web5505.mail.yahoo.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: James Kewin
Дата:
Сообщение: Pasing Cursors
Следующее
От: Zeljko Trogrlic
Дата:
Сообщение: RE: JDBC isNullable is not working