KickJava   Java API By Example, From Geeks To Geeks.

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


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 // fredt@users 20020215 - patch 516309 by Nicolas Bazin - transfer Informix
37 // sqlbob@users 20020325 - patch 1.7.0 - reengineering
38
39 /**
40  * Conversions from Informix databases
41  *
42  * @author Nichola Bazin
43  * @version 1.7.0
44  */
45 class InformixTransferHelper extends TransferHelper {
46
47     public InformixTransferHelper() {
48         super();
49     }
50
51     public InformixTransferHelper(TransferDb database, Traceable t,
52                                   String JavaDoc q) {
53         super(database, t, q);
54     }
55
56     void setSchema(String JavaDoc _Schema) {
57         sSchema = "\"" + _Schema + "\"";
58     }
59
60     int convertFromType(int type) {
61
62         //Correct a bug in Informix JDBC driver that maps:
63 // DATETIME YEAR TO FRACTION to TIME and
64 // DATETIME HOUR TO SECOND to TIMESTAMP
65 if (type == Types.TIMESTAMP) {
66             type = Types.TIME;
67
68             tracer.trace("Converted INFORMIX TIMESTAMP to TIME");
69         } else if (type == Types.TIME) {
70             type = Types.TIMESTAMP;
71
72             tracer.trace("Converted INFORMIX TIME to TIMESTAMP");
73         }
74
75         return (type);
76     }
77
78     int convertToType(int type) {
79
80         //Correct a bug in Informix JDBC driver that maps:
81 // DATETIME YEAR TO FRACTION to TIME and
82 // DATETIME HOUR TO SECOND to TIMESTAMP
83 if (type == Types.TIMESTAMP) {
84             type = Types.TIME;
85
86             tracer.trace("Converted TIMESTAMP to INFORMIX TIME");
87         } else if (type == Types.TIME) {
88             type = Types.TIMESTAMP;
89
90             tracer.trace("Converted TIME to INFORMIX TIMESTAMP");
91         }
92
93         return (type);
94     }
95 }
96
Popular Tags