mySQL INTEGER == LONG in Java and ....???

[Brian Snyder]

I have a program that creates a table as follows:

stmt.executeUpdate( "CREATE TABLE COFFEES (" +
             "Entry      INTEGER     NOT NULL, "   +
             "Customer   VARCHAR (20) NOT NULL, "   +
             "DOW        VARCHAR (3)  NOT NULL, "   +
             "Cups       INTEGER      NOT NULL, "   +
             "Type       VARCHAR (10) NOT NULL,"    +
             "PRIMARY KEY( Entry )"                 +
                                          ")" );

Notice that this is using MySQL and that Cups and Entry are INTEGERS and Customer is a VARCHAR. But when I run the following snippet from another program:

System.out.println(
           "Column Java Class Equivalent: " + 
            rsmd.getColumnClassName( ndx ) + ".\n" );

It doesn't print that Entry is of type int. I get an error
stating that my driver
org.gjt.mm.mysql.jdbc2.NotImplemented
What are the equivalent conversions from MySQL to Java? I am able to retreive the data and work with it, but when it tries to find its class equivalent, I get an error.
Thanks for your attention to my problem.
Brian

[Phil Hanna]

The DatabaseMetaData interface provides a getTypeInfo() method. This returns a result set that includes every type name recognized by the connection and the equivalent java.sql.Types constant that it maps to. With a switch statement, you can equate this to the appropriate java.sql.Types name.

import java.io.*;
import java.sql.*;
import java.util.*;
public class TypeLister
{
   public TypeLister(Connection con)
      throws SQLException
   {
      DatabaseMetaData md = con.getMetaData();
      ResultSet rs = md.getTypeInfo();
      while (rs.next()) {
         String typeName = rs.getString("TYPE_NAME");
         int dataType = rs.getInt("DATA_TYPE");
         String jdbcType = null;
         switch (dataType) {
            case Types.BIT: jdbcType="BIT"; break;
            case Types.TINYINT: jdbcType="TINYINT"; break;
            case Types.SMALLINT: jdbcType="SMALLINT"; break;
            case Types.INTEGER: jdbcType="INTEGER"; break;
            case Types.BIGINT: jdbcType="BIGINT"; break;
            case Types.FLOAT: jdbcType="FLOAT"; break;
            case Types.REAL: jdbcType="REAL"; break;
            case Types.DOUBLE: jdbcType="DOUBLE"; break;
            case Types.NUMERIC: jdbcType="NUMERIC"; break;
            case Types.DECIMAL: jdbcType="DECIMAL"; break;
            case Types.CHAR: jdbcType="CHAR"; break;
            case Types.VARCHAR: jdbcType="VARCHAR"; break;
            case Types.LONGVARCHAR: jdbcType="LONGVARCHAR"; break;
            case Types.DATE: jdbcType="DATE"; break;
            case Types.TIME: jdbcType="TIME"; break;
            case Types.TIMESTAMP: jdbcType="TIMESTAMP"; break;
            case Types.BINARY: jdbcType="BINARY"; break;
            case Types.VARBINARY: jdbcType="VARBINARY"; break;
            case Types.LONGVARBINARY: jdbcType="LONGVARBINARY"; break;
            case Types.NULL: jdbcType="NULL"; break;
            case Types.OTHER: jdbcType="OTHER"; break;
            case Types.JAVA_OBJECT: jdbcType="JAVA_OBJECT"; break;
            case Types.DISTINCT: jdbcType="DISTINCT"; break;
            case Types.STRUCT: jdbcType="STRUCT"; break;
            case Types.ARRAY: jdbcType="ARRAY"; break;
            case Types.BLOB: jdbcType="BLOB"; break;
            case Types.CLOB: jdbcType="CLOB"; break;
            case Types.REF: jdbcType="REF"; break;
            default: jdbcType="Unknown[" + dataType + "]"; break;
         }
         System.out.println(typeName + "\t" + jdbcType);
      }
      rs.close();
   }
}

------------------
Phil Hanna
Author of :
JSP: The Complete Reference
Instant Java Servlets

[Brian Snyder]

Thanks Phil for your response. My question was, however, why doesn't getColumnClassName work correctly??