*/

  private DBTableColumn addColumn(DBTable t, ResultSet rs)

      throws SQLException {

    String name = rs.getString("COLUMN_NAME");

    int colSize = rs.getInt("COLUMN_SIZE");

    boolean required = false;

    String defaultValue = rs.getString("COLUMN_DEF");

    if (rs.getString("IS_NULLABLE").equalsIgnoreCase("NO"))

      required = true;

   

    // The following is a hack for MySQL which currently gets sent a string "CURRENT_TIMESTAMP" from the Empire-db driver for MySQL.

    // This will avoid the driver problem because CURRENT_TIMESTAMP in the db will just do the current datetime.

    // Essentially, Empire-db needs the concept of default values of one type that get mapped to another.

    // In this case, MySQL "CURRENT_TIMESTAMP" for Types.TIMESTAMP needs to emit from the Empire-db driver the null value and not "CURRENT_TIMESTAMP".

    if(rs.getInt("DATA_TYPE") == Types.TIMESTAMP && defaultValue != null && defaultValue.equals("CURRENT_TIMESTAMP")){

      required = false; // It is in fact not required even though MySQL schema is required because it has a default value. Generally, should Empire-db emit (required && defaultValue != null) to truly determine if a column is required?

      defaultValue = null; // If null (and required per schema?) MySQL will apply internal default value.

    }

   

    // AUTOINC indicator is not in java.sql.Types but rather meta data from DatabaseMetaData.getColumns()

    // getEmpireDataType() above is not enough to support AUTOINC as it will only return DataType.INTEGER

    ResultSetMetaData metaData = rs.getMetaData();

    int colCount = metaData.getColumnCount();

    String colName;

    for (int i = 1; i <= colCount; i++) {

      colName = metaData.getColumnName(i);

   */

  private DBViewColumn addColumn(InMemoryView v, ResultSet rs)

      throws SQLException {

    String name = rs.getString("COLUMN_NAME");

   

    log.info("\tCOLUMN:\t" + name + " ("+empireType+")");

    return v.addCol(name, empireType);

  }

  /**

   * converts a SQL DataType to a EmpireDataType

   */

  private DataType getEmpireDataType(int sqlType) {

    switch (sqlType) {

    case Types.INTEGER:

    case Types.SMALLINT:

    case Types.TINYINT:

    case Types.BIGINT:

   * @param column the column to get the type for

   */

  public Class<?> getJavaType(DBColumn column)

  {

    // We added the attribute of original datatype to AUTOINC columns

    // in CodeGenParser.addColumn(). Now we need to use it so that

    // the g/setters deal with the right Java type.

   

    // If the original data type was not set as an attribute for some

    // reason this will just fall through to the bottom and

    // return "Byte[]", so no problem.

    if (DataType.AUTOINC.equals(type) && null != column.getAttribute("AutoIncDataType"))

    {

      type = (DataType)column.getAttribute("AutoIncDataType");

    }

   

    // TODO might be better to add this to the enum

    // TODO use primitives for non-nullable columns?

    switch(type){

    case INTEGER:

      return Long.class;

    case TEXT:

      return String.class;

    case DATE:

      return Date.class;

    case DATETIME:

      return Date.class;

    case CHAR:

      return String.class;

    case DOUBLE:

      return Double.class;

    case DECIMAL:

      return BigDecimal.class;

    case BOOL:

      return Boolean.class;

    case CLOB:

      return String.class;

    case BLOB:

      return Byte[].class;

    case UNKNOWN:

      return Byte[].class;

    default:

      return Byte[].class;

    }

  }

        String key = MESSAGE_KEY_PREFIX + tbl + "." + name;

        prop.setTitle(key);

        // Set Default Control Type

        if(type==DataType.BOOL)

          prop.setControlType("checkbox");

        else if("".equals(type))

        {

          // FIXME this case never happens, using equals between String and enum

    @Override

    protected Object parseValue(String value, Locale locale, Column column)

    {

        // Check Data Type

        if (type==DataType.TEXT)

            return value;

        // Check other types

        if (type==DataType.INTEGER)

        {   return parseInteger(value);

            return "";

        }

        // Format Value

        Column column = vi.getColumn();

        if (dataType == DataType.TEXT || dataType == DataType.UNKNOWN)

        { // String

            String s = String.valueOf(value);

            if (hasFormatOption(vi, "noencode"))

                return s;

    protected int getMaxInputLength(Column col)

    {

        // cast to DBTableColumn

        if (type==DataType.AUTOINC ||

            type==DataType.INTEGER)

            return 10;

        if (type==DataType.DOUBLE)

            return 18;

        String key = MESSAGE_KEY_PREFIX + tbl + "." + col;

        column.setTitle(key);

        // Set Default Control Type

        column.setControlType((type==DataType.BOOL) ? "checkbox" : "text");

        // Add Column

        return super.addColumn(column);

    }

            if (getValueOptions()!=null)

                controlType = SelectInputControl.NAME;

            else

            {   // get from data type

                controlType = FacesUtils.getFacesApplication().getDefaultControlType(dataType);

            }

            // get default control

            control = InputControlManager.getControl(controlType);

            // Still not? Use Text Control