| From: | "j(dot)random(dot)programmer" <javadesigner(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Column size BUG with text/bytea with 7.4 JDBC Driver (build 213) |
| Date: | 2004-04-07 22:22:18 |
| Message-ID: | 20040407222218.51391.qmail@web14201.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi:
The latest JDBC driver (build 213) has a serious
bug for the "COLUMN_SIZE" value, obtained via
DBMetaData, getColumns() and then "COLUMN_SIZE.
The column size returned for both bytea and text
types is -1. (The mysql jdbc driver correctly returns
65535 for these binary/text column types)
postgres _should_ return the max col size which
for bytea is about 1 GB (or is it 4 GB theoretically)
?
Either way, it certainly isn't -1
Please fix this ASAP, I am writing an advanced
db abstraction layer which automatically generated
validators based on min/max column sizes.
Best regards,
--j
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zhang-x | 2004-04-08 02:13:23 | Re: Have some problem about the SSL connection by JDBC |
| Previous Message | j.random.programmer | 2004-04-07 22:08:04 | Boolean/Bit BUG with 7.4 JDBC Driver (build 213) |