From: | "Ed Yu" <ekyu(at)sc(dot)rr(dot)com> |
---|---|
To: | "pgsql-jdbc" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | JDBC Driver patch (ResultSetMetaData.java) |
Date: | 2002-01-06 02:34:50 |
Message-ID: | 001b01c1965a$b7766fe0$bf00a8c0@sc.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
The following patch defines the method getColumnClassName(), currently
throwing an exception.
450a451,508
> /*
> The following data type mapping came from ../Field.java.
>
> "int2",
> "int4","oid",
> "int8",
> "cash","money",
> "numeric",
> "float4",
> "float8",
> "bpchar","char","char2","char4","char8","char16",
> "varchar","text","name","filename",
> "bool",
> "date",
> "time",
> "abstime","timestamp"
>
> Types.SMALLINT,
> Types.INTEGER,Types.INTEGER,
> Types.BIGINT,
> Types.DOUBLE,Types.DOUBLE,
> Types.NUMERIC,
> Types.REAL,
> Types.DOUBLE,
> Types.CHAR,Types.CHAR,Types.CHAR,Types.CHAR,Types.CHAR,Types.CHAR,
> Types.VARCHAR,Types.VARCHAR,Types.VARCHAR,Types.VARCHAR,
> Types.BIT,
> Types.DATE,
> Types.TIME,
> Types.TIMESTAMP,Types.TIMESTAMP
> */
>
> int sql_type = getField(column).getSQLType();
>
> switch (sql_type)
> {
> case Types.BIT:
> return("java.lang.Boolean");
> case Types.SMALLINT:
> return("java.lang.Integer");
> case Types.INTEGER:
> return("java.lang.Integer");
> case Types.BIGINT:
> return("java.lang.Long");
> case Types.NUMERIC:
> return("java.math.BigDecimal");
> case Types.REAL:
> return("java.lang.Float");
> case Types.DOUBLE:
> return("java.lang.Double");
> case Types.CHAR:
> case Types.VARCHAR:
> return("java.lang.String");
> case Types.DATE:
> case Types.TIME:
> case Types.TIMESTAMP:
> return("java.sql.Timestamp");
> default:
451a510
> }
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Yu | 2002-01-06 02:36:28 | JDBC patch for DatabaseMetaData |
Previous Message | Dave Cramer | 2002-01-06 01:10:15 | Re: Patches for JDBC driver (7.1.3) |