1 package org.apache.torque.adapter;
2
3 /* ====================================================================
4 * The Apache Software License, Version 1.1
5 *
6 * Copyright (c) 2001 The Apache Software Foundation. All rights
7 * reserved.
8 *
9 * Redistribution and use in source and binary forms, with or without
10 * modification, are permitted provided that the following conditions
11 * are met:
12 *
13 * 1. Redistributions of source code must retain the above copyright
14 * notice, this list of conditions and the following disclaimer.
15 *
16 * 2. Redistributions in binary form must reproduce the above copyright
17 * notice, this list of conditions and the following disclaimer in
18 * the documentation and/or other materials provided with the
19 * distribution.
20 *
21 * 3. The end-user documentation included with the redistribution,
22 * if any, must include the following acknowledgment:
23 * "This product includes software developed by the
24 * Apache Software Foundation (http://www.apache.org/)."
25 * Alternately, this acknowledgment may appear in the software itself,
26 * if and wherever such third-party acknowledgments normally appear.
27 *
28 * 4. The names "Apache" and "Apache Software Foundation" and
29 * "Apache Turbine" must not be used to endorse or promote products
30 * derived from this software without prior written permission. For
31 * written permission, please contact apache@apache.org.
32 *
33 * 5. Products derived from this software may not be called "Apache",
34 * "Apache Turbine", nor may "Apache" appear in their name, without
35 * prior written permission of the Apache Software Foundation.
36 *
37 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
38 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
39 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
40 * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
41 * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
42 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
43 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
44 * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
45 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
46 * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
47 * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
48 * SUCH DAMAGE.
49 * ====================================================================
50 *
51 * This software consists of voluntary contributions made by many
52 * individuals on behalf of the Apache Software Foundation. For more
53 * information on the Apache Software Foundation, please see
54 * <http://www.apache.org/>.
55 */
56
57 import java.sql.Connection;
58 import java.sql.SQLException;
59 import java.util.StringTokenizer;
60
61 /***
62 * This is used to connect to Cloudscape SQL databases.
63 *
64 * @author <a href="mailto:taylor@apache.org">David Sean Taylor</a>
65 * @version $Id: DBCloudscape.java,v 1.5 2002/09/20 14:17:50 mpoeschl Exp $
66 */
67 public class DBCloudscape extends DB
68 {
69 /*** qualifier */
70 private static final String QUALIFIER = ".";
71
72 /***
73 * Constructor.
74 */
75 protected DBCloudscape()
76 {
77 }
78 /***
79 * This method is used to ignore case.
80 *
81 * @param in The string to transform to upper case.
82 * @return The upper case string.
83 */
84 public String toUpperCase(String in)
85 {
86 return in;
87 }
88
89 /***
90 * This method is used to ignore case.
91 *
92 * @param in The string whose case to ignore.
93 * @return The string in a case that can be ignored.
94 */
95 public String ignoreCase(String in)
96 {
97 return in;
98 }
99
100 /***
101 * @see org.apache.torque.adapter.DB#getIDMethodType()
102 */
103 public String getIDMethodType()
104 {
105 return AUTO_INCREMENT;
106 }
107
108 /***
109 * @see org.apache.torque.adapter.DB#getIDMethodSQL(Object obj)
110 */
111 public String getIDMethodSQL(Object obj)
112 {
113 StringBuffer sql = new StringBuffer(132);
114 sql.append("select distinct ConnectionInfo.lastAutoincrementValue(");
115
116 String qualifiedIdentifier = (String) obj;
117
118 StringTokenizer tokenizer = new StringTokenizer(qualifiedIdentifier,
119 QUALIFIER);
120 int count = tokenizer.countTokens();
121
122 String schema, table, column;
123
124 System.out.println("qi = " + qualifiedIdentifier);
125 // no qualifiers, its simply a column name
126 switch (count)
127 {
128 case 0:
129 return ""; // not valid -- we need the column name and table name
130 case 1:
131 return ""; // not valid -- we need the table name to select from
132
133 case 2:
134 table = tokenizer.nextToken();
135 column = tokenizer.nextToken();
136 sql.append("'APP', '");
137 sql.append(table);
138 break;
139
140 case 3:
141 schema = tokenizer.nextToken();
142 table = tokenizer.nextToken();
143 column = tokenizer.nextToken();
144 sql.append("'");
145 sql.append(schema);
146 sql.append("', '");
147 sql.append(table);
148 break;
149
150 default:
151 return ""; // not valid
152 }
153
154 sql.append("', '");
155 sql.append(column);
156 sql.append("') FROM ");
157 sql.append(table);
158
159 System.out.println(sql.toString());
160 return sql.toString();
161 }
162
163 /***
164 * Locks the specified table.
165 *
166 * @param con The JDBC connection to use.
167 * @param table The name of the table to lock.
168 * @exception SQLException No Statement could be created or executed.
169 */
170 public void lockTable(Connection con, String table) throws SQLException
171 {
172 }
173
174 /***
175 * Unlocks the specified table.
176 *
177 * @param con The JDBC connection to use.
178 * @param table The name of the table to unlock.
179 * @exception SQLException No Statement could be created or executed.
180 */
181 public void unlockTable(Connection con, String table) throws SQLException
182 {
183 }
184 }