KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > hsqldb > util > SqlServerTransferHelper


1 /* Copyright (c) 2001-2005, The HSQL Development Group
2  * All rights reserved.
3  *
4  * Redistribution and use in source and binary forms, with or without
5  * modification, are permitted provided that the following conditions are met:
6  *
7  * Redistributions of source code must retain the above copyright notice, this
8  * list of conditions and the following disclaimer.
9  *
10  * Redistributions in binary form must reproduce the above copyright notice,
11  * this list of conditions and the following disclaimer in the documentation
12  * and/or other materials provided with the distribution.
13  *
14  * Neither the name of the HSQL Development Group nor the names of its
15  * contributors may be used to endorse or promote products derived from this
16  * software without specific prior written permission.
17  *
18  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
19  * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
20  * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
21  * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
22  * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
23  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
24  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
25  * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
26  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
27  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
28  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29  */
30
31
32 package org.hsqldb.util;
33
34 import java.sql.Types JavaDoc;
35
36 // sqlbob@users 20020325 - patch 1.7.0 - reengineering
37
38 /**
39  * Conversions from SQLServer7 databases
40  *
41  * @version 1.7.0
42  */
43 class SqlServerTransferHelper extends TransferHelper {
44
45     private boolean firstTinyintRow;
46     private boolean firstSmallintRow;
47
48     SqlServerTransferHelper() {
49         super();
50     }
51
52     SqlServerTransferHelper(TransferDb database, Traceable t, String JavaDoc q) {
53         super(database, t, q);
54     }
55
56     String JavaDoc formatTableName(String JavaDoc t) {
57
58         if (t == null) {
59             return t;
60         }
61
62         if (t.equals("")) {
63             return t;
64         }
65
66         if (t.indexOf(' ') != -1) {
67             return ("[" + t + "]");
68         } else {
69             return (formatIdentifier(t));
70         }
71     }
72
73     int convertFromType(int type) {
74
75         // MS SQL 7 specific problems (Northwind database)
76 if (type == 11) {
77             tracer.trace("Converted DATETIME (type 11) to TIMESTAMP");
78
79             type = Types.TIMESTAMP;
80         } else if (type == -9) {
81             tracer.trace("Converted NVARCHAR (type -9) to VARCHAR");
82
83             type = Types.VARCHAR;
84         } else if (type == -8) {
85             tracer.trace("Converted NCHAR (type -8) to VARCHAR");
86
87             type = Types.VARCHAR;
88         } else if (type == -10) {
89             tracer.trace("Converted NTEXT (type -10) to VARCHAR");
90
91             type = Types.VARCHAR;
92         } else if (type == -1) {
93             tracer.trace("Converted LONGTEXT (type -1) to LONGVARCHAR");
94
95             type = Types.LONGVARCHAR;
96         }
97
98         return (type);
99     }
100
101     void beginTransfer() {
102         firstSmallintRow = true;
103         firstTinyintRow = true;
104     }
105
106     Object JavaDoc convertColumnValue(Object JavaDoc value, int column, int type) {
107
108         // solves a problem for MS SQL 7
109 if ((type == Types.SMALLINT) && (value instanceof Integer JavaDoc)) {
110             if (firstSmallintRow) {
111                 firstSmallintRow = false;
112
113                 tracer.trace("SMALLINT: Converted column " + column
114                              + " Integer to Short");
115             }
116
117             value = new Short JavaDoc((short) ((Integer JavaDoc) value).intValue());
118         } else if ((type == Types.TINYINT) && (value instanceof Integer JavaDoc)) {
119             if (firstTinyintRow) {
120                 firstTinyintRow = false;
121
122                 tracer.trace("TINYINT: Converted column " + column
123                              + " Integer to Byte");
124             }
125
126             value = new Byte JavaDoc((byte) ((Integer JavaDoc) value).intValue());
127         }
128
129         return (value);
130     }
131 }
132
Popular Tags