KickJava   Java API By Example, From Geeks To Geeks.

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


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.ResultSet JavaDoc;
35 import java.sql.ResultSetMetaData JavaDoc;
36 import java.sql.SQLException JavaDoc;
37 import java.sql.Types JavaDoc;
38
39 // sqlbob@users 20020325 - patch 1.7.0 - reengineering
40
41 /**
42  * Conversions to / from Hsqldb
43  *
44  * @author sqlbob@users
45  * @version 1.7.0
46  */
47 class HsqldbTransferHelper extends TransferHelper {
48
49     public HsqldbTransferHelper() {
50         super();
51     }
52
53     public HsqldbTransferHelper(TransferDb database, Traceable t, String JavaDoc q) {
54         super(database, t, q);
55     }
56
57     int convertFromType(int type) {
58
59         if (type == 100) {
60             type = Types.VARCHAR;
61
62             tracer.trace("Converted HSQLDB VARCHAR_IGNORECASE to VARCHAR");
63         }
64
65         return (type);
66     }
67
68     String JavaDoc fixupColumnDefRead(TransferTable t, ResultSetMetaData JavaDoc meta,
69                               String JavaDoc columnType, ResultSet JavaDoc columnDesc,
70                               int columnIndex) throws SQLException JavaDoc {
71
72         String JavaDoc CompareString = "INTEGER IDENTITY";
73
74         if (columnType.indexOf(CompareString) >= 0) {
75
76             // We just found a increment
77 columnType = "SERIAL";
78         }
79
80         return (columnType);
81     }
82
83     String JavaDoc fixupColumnDefWrite(TransferTable t, ResultSetMetaData JavaDoc meta,
84                                String JavaDoc columnType, ResultSet JavaDoc columnDesc,
85                                int columnIndex) throws SQLException JavaDoc {
86
87         if (columnType.indexOf("SERIAL") >= 0) {
88             columnType = " INTEGER IDENTITY ";
89         }
90
91         return (columnType);
92     }
93
94     String JavaDoc fixupColumnDefRead(String JavaDoc aTableName, ResultSetMetaData JavaDoc meta,
95                               String JavaDoc columnType, ResultSet JavaDoc columnDesc,
96                               int columnIndex) throws SQLException JavaDoc {
97         return fixupColumnDefRead((TransferTable) null, meta, columnType,
98                                   columnDesc, columnIndex);
99     }
100
101     String JavaDoc fixupColumnDefWrite(String JavaDoc aTableName, ResultSetMetaData JavaDoc meta,
102                                String JavaDoc columnType, ResultSet JavaDoc columnDesc,
103                                int columnIndex) throws SQLException JavaDoc {
104         return fixupColumnDefWrite((TransferTable) null, meta, columnType,
105                                    columnDesc, columnIndex);
106     }
107
108     String JavaDoc formatName(String JavaDoc t) {
109         return formatIdentifier(t);
110     }
111 }
112
Popular Tags