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
>

I apologize for convoluting the subject futher, but clarification on the
data shown
with an update to table used to generate with character varying included.

11 varchar_type_30 Varchar Type 30 java.lang.String varchar 30
*12 charvarying_type Charvarying Type java.lang.String varchar 2147483647
13 char_type Char Type java.lang.String bpchar 30
14 text_type Text Type java.lang.String text 2147483647

--
-- MyJSQLView SQL Dump
-- Version: 3.02
-- WebSite: http://myjsqlview.org
--
-- Host: 127.0.0.1
-- Generated On: 2009.06.07 AD at 10:25:40 MDT
-- SQL version: PostgreSQL 8.3.3
-- Database: postgresql_datatypes
--

-- ------------------------------------------

--
-- Table structure for table "public"."postgresqltypes"
--

DROP TABLE IF EXISTS "public"."postgresqltypes";
CREATE TABLE "public"."postgresqltypes" (
"data_type_id" serial NOT NULL,
"smallint_type" smallint DEFAULT NULL,
"int_type" integer DEFAULT NULL,
"bigint_type" bigint DEFAULT NULL,
"decimal_type" numeric(16,2) DEFAULT NULL,
"numeric_type" numeric(10,2) DEFAULT NULL,
"real_type" real DEFAULT NULL,
"doubleprecision_type" double precision DEFAULT NULL,
"serial_type" serial NOT NULL,
"bigserial_type" bigserial NOT NULL,
"varchar_type_30" varchar(30) DEFAULT NULL,
"charvarying_type" character varying DEFAULT NULL,
"char_type" char(30) DEFAULT NULL,
"text_type" text DEFAULT NULL,
"bytea_type" bytea DEFAULT NULL,
"date_type" date DEFAULT NULL,
"time_type" time without time zone DEFAULT NULL,
"timetz_type" time with time zone DEFAULT NULL,
"timestamp_type" timestamp without time zone DEFAULT '2007-10-14
00:00:00',
"timestamptz_type" timestamp with time zone DEFAULT NULL,
"interval_type" interval DEFAULT NULL,
"boolean_type" boolean DEFAULT NULL,
"point_type" point DEFAULT NULL,
"linesegment_type" lseg DEFAULT NULL,
"box_type" box DEFAULT NULL,
"path_type" path DEFAULT NULL,
"polygon_type" polygon DEFAULT NULL,
"circle_type" circle DEFAULT NULL,
"cidr_type" cidr DEFAULT NULL,
"inet_type" inet DEFAULT NULL,
"macaddr_type" macaddr DEFAULT NULL,
"bit2_type" bit(2) DEFAULT NULL,
"bitvarying5_type" bit varying(5) DEFAULT NULL,
PRIMARY KEY ("data_type_id")
);

danap