Re: getColumnDisplayWidth() returns 0x7fffffff for char varying

> This may not be a JDBC issue, but I encountered it using JDBC and a
> remote host
>
> My installation is:
> DBMS: PostgreSQL 8.3.4 (Windows XP)
> JDBC Driver: PostgreSQL Native Driver PostgreSQL 8.4devel JDBC4 (build
> 700)
>
> I have a current build and have run the test suite:
>
> runtest:
> [junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
> [junit] Tests run: 270, Failures: 0, Errors: 0, Time elapsed:
> 99.485 sec
>
> [junit] Testsuite:
> org.postgresql.test.jdbc2.optional.OptionalTestSuite
> [junit] Tests run: 40, Failures: 0, Errors: 0, Time elapsed: 8.125 sec
>
> [junit] Testsuite: org.postgresql.test.jdbc3.Jdbc3TestSuite
> [junit] Tests run: 65, Failures: 0, Errors: 0, Time elapsed: 7.859 sec
>
> [junit] Testsuite: org.postgresql.test.xa.XATestSuite
> [junit] Tests run: 8, Failures: 0, Errors: 0, Time elapsed: 1.407 sec
>
> [junit] Testsuite: org.postgresql.test.jdbc4.Jdbc4TestSuite
> [junit] Tests run: 24, Failures: 0, Errors: 0, Time elapsed: 2.296 sec
>
>
> test:
>
> BUILD SUCCESSFUL
>
> My problem is that getColumnDisplayWidth() returns the widths
>
> column(1) uname(2147483647)
> column(2) pass(2147483647)
> column(3) timestamp(11)
> column(4) icon1(11)
> column(5) icon2(11)
> column(6) icon3(11)
> column(7) type(11)
> column(8) creation(11)
> column(9) until(11)
> column(10) canxfer(1)
>
> for the following table:
>
> CREATE TABLE vcnmaster
> (
> uname character varying NOT NULL,
> pass character varying,
> "timestamp" integer,
> icon1 integer,
> icon2 integer,
> icon3 integer,
> "type" integer,
> creation integer,
> "until" integer,
> canxfer boolean,
> CONSTRAINT vcnmasterkey PRIMARY KEY (uname)
> )
> WITH (OIDS=FALSE);
>
> Is this expected behavior?
>
> Thanks.
>
> Dan
>
> PS. I can provide an Ethereal capture of the interaction if needed.

Hello I can not answer to the expected behavior, but I maintain an eye on
various output for data types from the PostgreSQL JDBC for the MyJSQLView
application. Though I have not run the current driver here is data from
the last JDBC driver tested. The last number is getColumnDisplaySize() since
it looks like the Java API only specifies this method for ResultSetMetaData,
not getColumnDisplayWidth().

PostgreSQL 8.3-603

1 data_type_id Data Type Id java.lang.Integer int4 11
2 smallint_type Smallint Type java.lang.Integer int2 6
3 int_type Int Type java.lang.Integer int4 11
4 bigint_type Bigint Type java.lang.Long int8 20
5 decimal_type Decimal Type java.math.BigDecimal numeric 18
6 numeric_type Numeric Type java.math.BigDecimal numeric 12
7 real_type Real Type java.lang.Float float4 14
8 doubleprecision_type Doubleprecision Type java.lang.Double float8 24
9 serial_type Serial Type java.lang.Integer int4 11
10 bigserial_type Bigserial Type java.lang.Long int8 20
11 varchar_type Varchar Type java.lang.String varchar 30
12 char_type Char Type java.lang.String bpchar 30
13 text_type Text Type java.lang.String text 2147483647
14 bytea_type Bytea Type [B bytea 2147483647
15 date_type Date Type java.sql.Date date 13
16 time_type Time Type java.sql.Time time 15
17 timetz_type Timetz Type java.sql.Time timetz 21
18 timestamp_type Timestamp Type java.sql.Timestamp timestamp 29
19 timestamptz_type Timestamptz Type java.sql.Timestamp timestamptz 35
20 interval_type Interval Type org.postgresql.util.PGInterval interval 49
21 boolean_type Boolean Type java.lang.Boolean bool 1
22 point_type Point Type org.postgresql.geometric.PGpoint point 2147483647
23 linesegment_type Linesegment Type org.postgresql.geometric.PGlseg
lseg 2147483647
24 box_type Box Type org.postgresql.geometric.PGbox box 2147483647
25 path_type Path Type org.postgresql.geometric.PGpath path 2147483647
26 polygon_type Polygon Type org.postgresql.geometric.PGpolygon polygon
2147483647
27 circle_type Circle Type org.postgresql.geometric.PGcircle circle
2147483647
28 cidr_type Cidr Type java.lang.Object cidr 2147483647
29 inet_type Inet Type java.lang.Object inet 2147483647
30 macaddr_type Macaddr Type java.lang.Object macaddr 2147483647
31 bit2_type Bit2 Type java.lang.Boolean bit 2
32 bitvarying5_type Bitvarying5 Type java.lang.Object varbit 5

danap