Erroneous type when using getColumnType for a BLOB column in JDBC

From: Rocio "Escao" Villalba <doloresev(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Erroneous type when using getColumnType for a BLOB column in JDBC
Date: 2000-09-05 14:03:40
Message-ID: 20000905140340.2839.qmail@web5505.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Escao

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Manika dey 2000-09-05 16:23:02 RE: using large objects with jdbc
Previous Message Finn Kettner 2000-09-05 13:56:36 Visual Studio 6 project/workspace files