01: /* Copyright (c) 2001-2005, The HSQL Development Group
02: * All rights reserved.
03: *
04: * Redistribution and use in source and binary forms, with or without
05: * modification, are permitted provided that the following conditions are met:
06: *
07: * Redistributions of source code must retain the above copyright notice, this
08: * list of conditions and the following disclaimer.
09: *
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: package org.hsqldb.util;
32:
33: import java.sql.Types;
34:
35: // fredt@users 20020215 - patch 516309 by Nicolas Bazin - transfer Informix
36: // sqlbob@users 20020325 - patch 1.7.0 - reengineering
37:
38: /**
39: * Conversions from Informix databases
40: *
41: * @author Nichola Bazin
42: * @version 1.7.0
43: */
44: class InformixTransferHelper extends TransferHelper {
45:
46: public InformixTransferHelper() {
47: super ();
48: }
49:
50: public InformixTransferHelper(TransferDb database, Traceable t,
51: String q) {
52: super (database, t, q);
53: }
54:
55: void setSchema(String _Schema) {
56: sSchema = "\"" + _Schema + "\"";
57: }
58:
59: int convertFromType(int type) {
60:
61: //Correct a bug in Informix JDBC driver that maps:
62: // DATETIME YEAR TO FRACTION to TIME and
63: // DATETIME HOUR TO SECOND to TIMESTAMP
64: if (type == Types.TIMESTAMP) {
65: type = Types.TIME;
66:
67: tracer.trace("Converted INFORMIX TIMESTAMP to TIME");
68: } else if (type == Types.TIME) {
69: type = Types.TIMESTAMP;
70:
71: tracer.trace("Converted INFORMIX TIME to TIMESTAMP");
72: }
73:
74: return (type);
75: }
76:
77: int convertToType(int type) {
78:
79: //Correct a bug in Informix JDBC driver that maps:
80: // DATETIME YEAR TO FRACTION to TIME and
81: // DATETIME HOUR TO SECOND to TIMESTAMP
82: if (type == Types.TIMESTAMP) {
83: type = Types.TIME;
84:
85: tracer.trace("Converted TIMESTAMP to INFORMIX TIME");
86: } else if (type == Types.TIME) {
87: type = Types.TIMESTAMP;
88:
89: tracer.trace("Converted TIME to INFORMIX TIMESTAMP");
90: }
91:
92: return (type);
93: }
94: }
|