1 /*
2 * Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4 *
5 * This code is free software; you can redistribute it and/or modify it
6 * under the terms of the GNU General Public License version 2 only, as
7 * published by the Free Software Foundation. Oracle designates this
8 * particular file as subject to the "Classpath" exception as provided
9 * by Oracle in the LICENSE file that accompanied this code.
10 *
11 * This code is distributed in the hope that it will be useful, but WITHOUT
12 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
13 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
14 * version 2 for more details (a copy is included in the LICENSE file that
15 * accompanied this code).
16 *
17 * You should have received a copy of the GNU General Public License version
18 * 2 along with this work; if not, write to the Free Software Foundation,
19 * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
20 *
21 * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA
22 * or visit www.oracle.com if you need additional information or have any
23 * questions.
24 */
25
26 package java.sql;
27
28 /**
29 * <P>The class that defines the constants that are used to identify generic
30 * SQL types, called JDBC types.
31 * <p>
32 * This class is never instantiated.
33 */
34 public class Types {
35
36 /**
37 * <P>The constant in the Java programming language, sometimes referred
38 * to as a type code, that identifies the generic SQL type
39 * <code>BIT</code>.
40 */
41 public final static int BIT = -7;
42
43 /**
44 * <P>The constant in the Java programming language, sometimes referred
45 * to as a type code, that identifies the generic SQL type
46 * <code>TINYINT</code>.
47 */
48 public final static int TINYINT = -6;
49
50 /**
51 * <P>The constant in the Java programming language, sometimes referred
52 * to as a type code, that identifies the generic SQL type
53 * <code>SMALLINT</code>.
54 */
55 public final static int SMALLINT = 5;
56
57 /**
58 * <P>The constant in the Java programming language, sometimes referred
59 * to as a type code, that identifies the generic SQL type
60 * <code>INTEGER</code>.
61 */
62 public final static int INTEGER = 4;
63
64 /**
65 * <P>The constant in the Java programming language, sometimes referred
66 * to as a type code, that identifies the generic SQL type
67 * <code>BIGINT</code>.
68 */
69 public final static int BIGINT = -5;
70
71 /**
72 * <P>The constant in the Java programming language, sometimes referred
73 * to as a type code, that identifies the generic SQL type
74 * <code>FLOAT</code>.
75 */
76 public final static int FLOAT = 6;
77
78 /**
79 * <P>The constant in the Java programming language, sometimes referred
80 * to as a type code, that identifies the generic SQL type
81 * <code>REAL</code>.
82 */
83 public final static int REAL = 7;
84
85
86 /**
87 * <P>The constant in the Java programming language, sometimes referred
88 * to as a type code, that identifies the generic SQL type
89 * <code>DOUBLE</code>.
90 */
91 public final static int DOUBLE = 8;
92
93 /**
94 * <P>The constant in the Java programming language, sometimes referred
95 * to as a type code, that identifies the generic SQL type
96 * <code>NUMERIC</code>.
97 */
98 public final static int NUMERIC = 2;
99
100 /**
101 * <P>The constant in the Java programming language, sometimes referred
102 * to as a type code, that identifies the generic SQL type
103 * <code>DECIMAL</code>.
104 */
105 public final static int DECIMAL = 3;
106
107 /**
108 * <P>The constant in the Java programming language, sometimes referred
109 * to as a type code, that identifies the generic SQL type
110 * <code>CHAR</code>.
111 */
112 public final static int CHAR = 1;
113
114 /**
115 * <P>The constant in the Java programming language, sometimes referred
116 * to as a type code, that identifies the generic SQL type
117 * <code>VARCHAR</code>.
118 */
119 public final static int VARCHAR = 12;
120
121 /**
122 * <P>The constant in the Java programming language, sometimes referred
123 * to as a type code, that identifies the generic SQL type
124 * <code>LONGVARCHAR</code>.
125 */
126 public final static int LONGVARCHAR = -1;
127
128
129 /**
130 * <P>The constant in the Java programming language, sometimes referred
131 * to as a type code, that identifies the generic SQL type
132 * <code>DATE</code>.
133 */
134 public final static int DATE = 91;
135
136 /**
137 * <P>The constant in the Java programming language, sometimes referred
138 * to as a type code, that identifies the generic SQL type
139 * <code>TIME</code>.
140 */
141 public final static int TIME = 92;
142
143 /**
144 * <P>The constant in the Java programming language, sometimes referred
145 * to as a type code, that identifies the generic SQL type
146 * <code>TIMESTAMP</code>.
147 */
148 public final static int TIMESTAMP = 93;
149
150
151 /**
152 * <P>The constant in the Java programming language, sometimes referred
153 * to as a type code, that identifies the generic SQL type
154 * <code>BINARY</code>.
155 */
156 public final static int BINARY = -2;
157
158 /**
159 * <P>The constant in the Java programming language, sometimes referred
160 * to as a type code, that identifies the generic SQL type
161 * <code>VARBINARY</code>.
162 */
163 public final static int VARBINARY = -3;
164
165 /**
166 * <P>The constant in the Java programming language, sometimes referred
167 * to as a type code, that identifies the generic SQL type
168 * <code>LONGVARBINARY</code>.
169 */
170 public final static int LONGVARBINARY = -4;
171
172 /**
173 * <P>The constant in the Java programming language
174 * that identifies the generic SQL value
175 * <code>NULL</code>.
176 */
177 public final static int NULL = 0;
178
179 /**
180 * The constant in the Java programming language that indicates
181 * that the SQL type is database-specific and
182 * gets mapped to a Java object that can be accessed via
183 * the methods <code>getObject</code> and <code>setObject</code>.
184 */
185 public final static int OTHER = 1111;
186
187
188
189 /**
190 * The constant in the Java programming language, sometimes referred to
191 * as a type code, that identifies the generic SQL type
192 * <code>JAVA_OBJECT</code>.
193 * @since 1.2
194 */
195 public final static int JAVA_OBJECT = 2000;
196
197 /**
198 * The constant in the Java programming language, sometimes referred to
199 * as a type code, that identifies the generic SQL type
200 * <code>DISTINCT</code>.
201 * @since 1.2
202 */
203 public final static int DISTINCT = 2001;
204
205 /**
206 * The constant in the Java programming language, sometimes referred to
207 * as a type code, that identifies the generic SQL type
208 * <code>STRUCT</code>.
209 * @since 1.2
210 */
211 public final static int STRUCT = 2002;
212
213 /**
214 * The constant in the Java programming language, sometimes referred to
215 * as a type code, that identifies the generic SQL type
216 * <code>ARRAY</code>.
217 * @since 1.2
218 */
219 public final static int ARRAY = 2003;
220
221 /**
222 * The constant in the Java programming language, sometimes referred to
223 * as a type code, that identifies the generic SQL type
224 * <code>BLOB</code>.
225 * @since 1.2
226 */
227 public final static int BLOB = 2004;
228
229 /**
230 * The constant in the Java programming language, sometimes referred to
231 * as a type code, that identifies the generic SQL type
232 * <code>CLOB</code>.
233 * @since 1.2
234 */
235 public final static int CLOB = 2005;
236
237 /**
238 * The constant in the Java programming language, sometimes referred to
239 * as a type code, that identifies the generic SQL type
240 * <code>REF</code>.
241 * @since 1.2
242 */
243 public final static int REF = 2006;
244
245 /**
246 * The constant in the Java programming language, somtimes referred to
247 * as a type code, that identifies the generic SQL type <code>DATALINK</code>.
248 *
249 * @since 1.4
250 */
251 public final static int DATALINK = 70;
252
253 /**
254 * The constant in the Java programming language, somtimes referred to
255 * as a type code, that identifies the generic SQL type <code>BOOLEAN</code>.
256 *
257 * @since 1.4
258 */
259 public final static int BOOLEAN = 16;
260
261 //------------------------- JDBC 4.0 -----------------------------------
262
263 /**
264 * The constant in the Java programming language, sometimes referred to
265 * as a type code, that identifies the generic SQL type <code>ROWID</code>
266 *
267 * @since 1.6
268 *
269 */
270 public final static int ROWID = -8;
271
272 /**
273 * The constant in the Java programming language, sometimes referred to
274 * as a type code, that identifies the generic SQL type <code>NCHAR</code>
275 *
276 * @since 1.6
277 */
278 public static final int NCHAR = -15;
279
280 /**
281 * The constant in the Java programming language, sometimes referred to
282 * as a type code, that identifies the generic SQL type <code>NVARCHAR</code>.
283 *
284 * @since 1.6
285 */
286 public static final int NVARCHAR = -9;
287
288 /**
289 * The constant in the Java programming language, sometimes referred to
290 * as a type code, that identifies the generic SQL type <code>LONGNVARCHAR</code>.
291 *
292 * @since 1.6
293 */
294 public static final int LONGNVARCHAR = -16;
295
296 /**
297 * The constant in the Java programming language, sometimes referred to
298 * as a type code, that identifies the generic SQL type <code>NCLOB</code>.
299 *
300 * @since 1.6
301 */
302 public static final int NCLOB = 2011;
303
304 /**
305 * The constant in the Java programming language, sometimes referred to
306 * as a type code, that identifies the generic SQL type <code>XML</code>.
307 *
308 * @since 1.6
309 */
310 public static final int SQLXML = 2009;
311
312 //--------------------------JDBC 4.2 -----------------------------
313
314 /**
315 * The constant in the Java programming language, sometimes referred to
316 * as a type code, that identifies the generic SQL type {@code REF CURSOR}.
317 *
318 * @since 1.8
319 */
320 public static final int REF_CURSOR = 2012;
321
322 /**
323 * The constant in the Java programming language, sometimes referred to
324 * as a type code, that identifies the generic SQL type
325 * {@code TIME WITH TIMEZONE}.
326 *
327 * @since 1.8
328 */
329 public static final int TIME_WITH_TIMEZONE = 2013;
330
331 /**
332 * The constant in the Java programming language, sometimes referred to
333 * as a type code, that identifies the generic SQL type
334 * {@code TIMESTAMP WITH TIMEZONE}.
335 *
336 * @since 1.8
337 */
338 public static final int TIMESTAMP_WITH_TIMEZONE = 2014;
339
340 // Prevent instantiation
341 private Types() {}
342 }