001: /*
002: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
003: *
004: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
005: *
006: * The contents of this file are subject to the terms of either the GNU
007: * General Public License Version 2 only ("GPL") or the Common
008: * Development and Distribution License("CDDL") (collectively, the
009: * "License"). You may not use this file except in compliance with the
010: * License. You can obtain a copy of the License at
011: * http://www.netbeans.org/cddl-gplv2.html
012: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
013: * specific language governing permissions and limitations under the
014: * License. When distributing the software, include this License Header
015: * Notice in each file and include the License file at
016: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
017: * particular file as subject to the "Classpath" exception as provided
018: * by Sun in the GPL Version 2 section of the License file that
019: * accompanied this code. If applicable, add the following below the
020: * License Header, with the fields enclosed by brackets [] replaced by
021: * your own identifying information:
022: * "Portions Copyrighted [year] [name of copyright owner]"
023: *
024: * Contributor(s):
025: *
026: * The Original Software is NetBeans. The Initial Developer of the Original
027: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2007 Sun
028: * Microsystems, Inc. All Rights Reserved.
029: *
030: * If you wish your version of this file to be governed by only the CDDL
031: * or only the GPL Version 2, indicate your decision by adding
032: * "[Contributor] elects to include this software in this distribution
033: * under the [CDDL or GPL Version 2] license." If you do not indicate a
034: * single choice of license, a recipient has the option to distribute
035: * your version of this file under either the CDDL, the GPL Version 2 or
036: * to extend the choice of license to its licensees as provided above.
037: * However, if you add GPL Version 2 code and therefore, elected the GPL
038: * Version 2 license, then the option applies only if the new code is
039: * made subject to such option by the copyright holder.
040: */
041: package org.netbeans.modules.sql.framework.codegen.sqlserver;
042:
043: import java.sql.Types;
044: import java.util.HashMap;
045: import java.util.Map;
046:
047: import org.netbeans.modules.sql.framework.codegen.AbstractTypeGenerator;
048: import org.netbeans.modules.sql.framework.codegen.DataType;
049:
050: /**
051: * @author Ritesh Adval
052: * @author Ahimanikya Satapathy
053: * @version $Revision$
054: */
055: public class SqlServerTypeGenerator extends AbstractTypeGenerator {
056:
057: private static HashMap supportedDataTypes;
058:
059: public Map createSupportedDataTypesMap() {
060: if (supportedDataTypes == null) {
061:
062: supportedDataTypes = new HashMap();
063:
064: supportedDataTypes
065: .put(new Integer(Types.BIT), DataType.BIT);
066:
067: supportedDataTypes.put(new Integer(Types.INTEGER),
068: DataType.INTEGER);
069: supportedDataTypes.put(new Integer(Types.BIGINT),
070: DataType.BIGINT);
071: supportedDataTypes.put(new Integer(Types.TINYINT),
072: DataType.TINYINT);
073: supportedDataTypes.put(new Integer(Types.SMALLINT),
074: DataType.SMALLINT);
075:
076: supportedDataTypes.put(new Integer(Types.DECIMAL),
077: DataType.DECIMAL);
078: // double is mapped to float
079: supportedDataTypes.put(new Integer(Types.DOUBLE),
080: DataType.DOUBLE_PRECISION);
081: supportedDataTypes.put(new Integer(Types.FLOAT),
082: DataType.FLOAT);
083: supportedDataTypes.put(new Integer(Types.NUMERIC),
084: DataType.NUMERIC);
085: supportedDataTypes.put(new Integer(Types.REAL),
086: DataType.REAL);
087:
088: // timestamp/time/date is mapped to datetime
089: supportedDataTypes.put(new Integer(Types.DATE),
090: DataType.SYBASE_DATETIME);
091: supportedDataTypes.put(new Integer(Types.TIME),
092: DataType.SYBASE_DATETIME);
093: supportedDataTypes.put(new Integer(Types.TIMESTAMP),
094: DataType.SYBASE_DATETIME);
095:
096: supportedDataTypes.put(new Integer(Types.CHAR),
097: DataType.CHAR);
098: supportedDataTypes.put(new Integer(Types.VARCHAR),
099: DataType.VARCHAR);
100: supportedDataTypes.put(new Integer(Types.LONGVARCHAR),
101: DataType.SYBASE_TEXT);
102:
103: supportedDataTypes.put(new Integer(Types.BINARY),
104: DataType.BINARY);
105: supportedDataTypes.put(new Integer(Types.VARBINARY),
106: DataType.VARBINARY);
107: supportedDataTypes.put(new Integer(Types.LONGVARBINARY),
108: DataType.SYBASE_IMAGE);
109:
110: supportedDataTypes.put(new Integer(Types.OTHER),
111: DataType.VARCHAR);
112:
113: supportedDataTypes.put(new Integer(Types.BLOB),
114: DataType.BLOB);
115: supportedDataTypes.put(new Integer(Types.CLOB),
116: DataType.CLOB);
117:
118: }
119: return supportedDataTypes;
120: }
121: }
|