Re: ResultSetMetaData.getColumnClassName raisesnotImplemented exception

sql types decimal and text

Regards,

Floyd Shackelford
4 Peaks Technology Group, Inc. <http://www.4peakstech.com/>
VOICE: 334.735.9428
FAX:   916.404.7125
EMAIL: FloydS@xxxxxxxxxxxxxx <mailto:FloydS@xxxxxxxxxxxxxx>
ICQ #: 161371538

acta non verba



-----Original Message-----
From: Dave Cramer [mailto:Dave@xxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, June 20, 2002 9:09 PM
To: floyds@xxxxxxxxxxxxxx
Cc: pgsql-jdbc@xxxxxxxxxxxxxx
Subject: Re: [JDBC] ResultSetMetaData.getColumnClassName
raisesnotImplemented exception


Floyd,

Here is the code

        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:
                        throw org.postgresql.Driver.notImplemented();
       }
   }


What kind of column is it you are trying to get?

Dave
On Thu, 2002-06-20 at 16:04, Floyd Shackelford wrote:
>
> i take it that "ResultSetMetaData.getColumnClassName" hasn't been
> implemented yet? i got the following exception when i tried to use it:
>
> This method is not yet implemented.
>  at org.postgresql.Driver.notImplemented(Driver.java:440)
>  at
>
org.postgresql.jdbc2.ResultSetMetaData.getColumnClassName(ResultSetMetaData.
> java:476)
>
> Regards,
>
> Floyd Shackelford
> 4 Peaks Technology Group, Inc.
> VOICE: 334.735.9428
> FAX:   916.404.7125
> EMAIL: FloydS@xxxxxxxxxxxxxx
> ICQ #: 161371538
> acta non verba
>
>



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly