converting a java.sql.Types integer value into a printable name : SQL Data Type Java Data Type « Database « Java Tutorial

import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.HashMap;
import java.util.Map;

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "com.jnetdirect.jsql.JSQLDriver";

    String serverName = "";
    String portNumber = "1433";
    String mydatabase = serverName + ":" + portNumber;
    String url = "jdbc:JSQLConnect://" + mydatabase;
    String username = "username";
    String password = "password";

    Connection connection = DriverManager.getConnection(url, username, password);
    DatabaseMetaData dbmd = connection.getMetaData();
    ResultSet resultSet = dbmd.getTypeInfo();

    while ( {
      String typeName = resultSet.getString("TYPE_NAME");

      short dataType = resultSet.getShort("DATA_TYPE");

  public static void getJdbcTypeName(int jdbcType) {
    Map map = new HashMap();

    // Get all field in java.sql.Types
    Field[] fields = java.sql.Types.class.getFields();
    for (int i = 0; i < fields.length; i++) {
      try {
        String name = fields[i].getName();
        Integer value = (Integer) fields[i].get(null);
        map.put(value, name);
      } catch (IllegalAccessException e) {


20.19.SQL Data Type Java Data Type
20.19.1.Mapping Between Java to JDBC SQL Types
20.19.2.Java Types Mapped to JDBC Types
20.19.3.JDBC Types Mapped to Java Object Types
20.19.4.Java Object Types Mapped to JDBC Types
20.19.5.Getting the Name of a JDBC Type
20.19.6.Get the database-specific type name
20.19.7.Get the java.sql.Types type to which this database-specific type is mapped
20.19.8.Retrieve type info from the result set
20.19.9.converting a java.sql.Types integer value into a printable name
20.19.10.uses reflection to get all the field names from java.sql.Types.