Java SQL Type compressType(int type)

Description

Compresses all the different kinds of essentially identical types into an arbitrarily chosen one of them.

License

Open Source License

Parameter

Parameter	Description
type	a parameter

Declaration

private static int compressType(int type) 

Method Source Code

//package com.java2s;
/*/*from  w  ww.  j a  va  2  s .co  m*/
 * Copyright (c) 2008, SQL Power Group Inc.
 *
 * This file is part of Power*Architect.
 *
 * Power*Architect is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * Power*Architect is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>. 
 */

import java.sql.Types;

public class Main {
    /**
     * Compresses all the different kinds of essentially identical types
     * into an arbitrarily chosen one of them.  For instance, NUMERIC
     * and DECIMAL both compress to NUMERIC.
     * 
     * @param type
     * @return
     */
    private static int compressType(int type) {
        if (type == Types.DECIMAL) {
            return Types.NUMERIC;
        } else {
            return type;
        }
    }
}

Related

1. columnClassName(int columnType)
2. columnDisplaySize(int columnType)
3. columnPrecision(int columnType)
4. columnScale(int columnType)
5. columnTypesDiffer(int t1, int t2)
6. convert2MysqlType(String cls)
7. convertBoolean(Object value, int srcType, int destType)
8. convertKnownType(Object one, Class to)
9. convertNumeric(Object value, int srcType, int destType)