protected int getMaxInputLength(Column col)

    {

        // cast to DBTableColumn

        if (type==DataType.CHAR ||

            type==DataType.TEXT)

            return (int)Math.round(col.getSize());

        if (type==DataType.AUTOINC ||

            type==DataType.INTEGER)

     */

    public DBColumnExpr decode(Map<?,?> valueMap, Object otherwise)

    {

        // Detect data type

        if (otherwise!=null)

        {

            dataType = detectDataType(otherwise);

        }

        if (dataType==DataType.UNKNOWN)

   */

  private DBTableColumn addColumn(DBTable t, ResultSet rs)

      throws SQLException {

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

   

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

    if (empireType==DataType.DECIMAL || empireType==DataType.FLOAT)

    {  // decimal digits

      int decimalDig = rs.getInt("DECIMAL_DIGITS");

      if (decimalDig>0)

      {  // parse

        try {

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

          colSize = Double.parseDouble(String.valueOf(intSize)+'.'+decimalDig);

        } catch(Exception e) {

          log.error("Failed to parse decimal digits for column "+name);

        }

      }

      // make integer?

      if (colSize<1.0d)

      {  // Turn into an integer

        empireType=DataType.INTEGER;

      }

    }

   

    // mandatory field?

    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:

    @SuppressWarnings("unchecked")

    public DBColumnExpr decode(Map valueMap, Object otherwise)

    {

        // Detect data type

        if (otherwise!=null)

        {

            dataType = detectDataType(otherwise);

        }

        if (dataType==DataType.UNKNOWN)

        }

        try

        { // Get Value from Resultset

            clearError();

            return db.driver.getResultValue(rset, index + 1, dataType);

        } catch (Exception e)

        { // Operation failed

            error(e);

     */

    public Object getColumnAutoValue(DBDatabase db, DBTableColumn column, Connection conn)

    {

        // Supports sequences?

        if (type == DataType.AUTOINC)

        {   // Use a numeric sequence

            if (isSupported(DBDriverFeature.SEQUENCES)==false)

                return null; // Create Later

            // Detect the Sequence Name

    }

   

    protected boolean useCmdParam(DBColumn col)

    {

        return ( dt==DataType.BLOB || dt==DataType.CLOB );

    }

    {

        // Get Template

        if (params != null)

        {   // Replace Params

            for (int i = 0; i < params.length; i++)

            {   // String test  =(params[i] != null) ? params[i].toString() : "";

                String value = getObjectValue(dataType, params[i], CTX_DEFAULT, ",");

                // template = template.replaceAll("\\{" + String.valueOf(i) + "\\}", value);

                template = StringUtils.replaceAll(template, "{"+ String.valueOf(i) + "}", value);