KickJava   Java API By Example, From Geeks To Geeks.

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


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
38 /**
39  * Helper class for conversion from a different databases
40  *
41  * @author sqlbob@users
42  * @version 1.7.0
43  */
44 class McKoiTransferHelper extends TransferHelper {
45
46     McKoiTransferHelper() {
47         super();
48     }
49
50     String JavaDoc fixupColumnDefRead(TransferTable t, ResultSetMetaData JavaDoc meta,
51                               String JavaDoc columnType, ResultSet JavaDoc columnDesc,
52                               int columnIndex) throws SQLException JavaDoc {
53
54         String JavaDoc CompareString = "UNIQUEKEY(\'" + t.Stmts.sDestTable + "\'";
55
56         if (columnType.indexOf(CompareString) > 0) {
57
58             // We just found a increment
59 columnType = "SERIAL";
60         }
61
62         return (columnType);
63     }
64
65     public McKoiTransferHelper(TransferDb database, Traceable t, String JavaDoc q) {
66         super(database, t, q);
67     }
68
69     String JavaDoc fixupColumnDefWrite(TransferTable t, ResultSetMetaData JavaDoc meta,
70                                String JavaDoc columnType, ResultSet JavaDoc columnDesc,
71                                int columnIndex) throws SQLException JavaDoc {
72
73         if (columnType.equals("SERIAL")) {
74             columnType = "INTEGER DEFAULT UNIQUEKEY (\'"
75                          + t.Stmts.sSourceTable + "\')";
76         }
77
78         return (columnType);
79     }
80
81     boolean needTransferTransaction() {
82         return (true);
83     }
84 }
85
Popular Tags