Obtaining precision and scale of NUMERIC types

From: "Donald J(dot) Armstrong" <donnie(at)cross-works(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Obtaining precision and scale of NUMERIC types
Date: 2003-02-06 17:18:25
Message-ID: 1829D126B76BFD4AB270408C8AC6D6B3032290@axe.lan.cross-works.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Greetings,

My first post.

I am attempting to describe the table "donnie" from JDBC and I'm unable
to determine the precision and scale of numeric types. I've tried the
stable and beta versions of the JDBC driver and receive same behavior.

DB version string
PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)

I'm using the following code...

try {
DatabaseMetaData dbms = basicCon.driverConnection.getMetaData();
ResultSet columnNames;
columnNames = dbms.getColumns(null, null, "donnie", null);

while (columnNames.next()) {
System.out.print(columnNames.getString("COLUMN_NAME") + " ");

switch (columnNames.getInt("DATA_TYPE")) {
case java.sql.Types.INTEGER:
System.out.print("INTEGER");
break;
case java.sql.Types.VARCHAR:
System.out.print("VARCHAR (");
System.out.print(columnNames.getInt("COLUMN_SIZE") + ")");
break;
case java.sql.Types.NUMERIC:
System.out.print("NUMERIC (");
System.out.print(columnNames.getInt("COLUMN_SIZE") + ",");
System.out.print(columnNames.getInt("DECIMAL_DIGITS") +
")");
break;
}

System.out.println("");
}

} catch (SQLException e) {
System.out.print(e);
}
}

The output from the java program
a INTEGER
b VARCHAR (100)
c NUMERIC (65535,65535)
d NUMERIC (0,0)
The description from pgsql
Table "donnie"
Column | Type | Modifiers
--------+------------------------+-----------
a | integer |
b | character varying(100) |
c | numeric(7,3) |
d | numeric(12,4) |

Any help?
Donnie

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-02-06 18:47:49 Re: Obtaining precision and scale of NUMERIC types
Previous Message Barry Lind 2003-02-06 17:02:24 Re: Timestamp problems