001 /* Array.java -- Interface for accessing SQL array object
002 Copyright (C) 1999, 2000, 2002, 2006 Free Software Foundation, Inc.
003
004 This file is part of GNU Classpath.
005
006 GNU Classpath is free software; you can redistribute it and/or modify
007 it under the terms of the GNU General Public License as published by
008 the Free Software Foundation; either version 2, or (at your option)
009 any later version.
010
011 GNU Classpath is distributed in the hope that it will be useful, but
012 WITHOUT ANY WARRANTY; without even the implied warranty of
013 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
014 General Public License for more details.
015
016 You should have received a copy of the GNU General Public License
017 along with GNU Classpath; see the file COPYING. If not, write to the
018 Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
019 02110-1301 USA.
020
021 Linking this library statically or dynamically with other modules is
022 making a combined work based on this library. Thus, the terms and
023 conditions of the GNU General Public License cover the whole
024 combination.
025
026 As a special exception, the copyright holders of this library give you
027 permission to link this library with independent modules to produce an
028 executable, regardless of the license terms of these independent
029 modules, and to copy and distribute the resulting executable under
030 terms of your choice, provided that you also meet, for each linked
031 independent module, the terms and conditions of the license of that
032 module. An independent module is a module which is not derived from
033 or based on this library. If you modify this library, you may extend
034 this exception to your version of the library, but you are not
035 obligated to do so. If you do not wish to do so, delete this
036 exception statement from your version. */
037
038 package java.sql;
039
040 import java.util.Map;
041
042 /**
043 * This interface provides methods for accessing SQL array types.
044 *
045 * @author Aaron M. Renn (arenn@urbanophile.com)
046 */
047 public interface Array
048 {
049 /**
050 * Returns the name of the SQL type of the elements in this
051 * array. This name is database specific.
052 *
053 * @return The name of the SQL type of the elements in this array.
054 * @exception SQLException If an error occurs.
055 */
056 String getBaseTypeName() throws SQLException;
057
058 /**
059 * Returns the JDBC type identifier of the elements in this
060 * array. This will be one of the values defined in the
061 * <code>Types</code> class.
062 *
063 * @return The JDBC type of the elements in this array.
064 * @exception SQLException If an error occurs.
065 * @see Types
066 */
067 int getBaseType() throws SQLException;
068
069 /**
070 * Returns the contents of this array. This object returned
071 * will be an array of Java objects of the appropriate types.
072 *
073 * @return The contents of the array as an array of Java objects.
074 * @exception SQLException If an error occurs.
075 */
076 Object getArray() throws SQLException;
077
078 /**
079 * Returns the contents of this array. The specified
080 * <code>Map</code> will be used to override selected mappings
081 * between SQL types and Java classes.
082 *
083 * @param map A mapping of SQL types to Java classes.
084 * @return The contents of the array as an array of Java objects.
085 * @exception SQLException If an error occurs.
086 */
087 Object getArray(Map<String, Class<?>> map) throws SQLException;
088
089 /**
090 * Returns a portion of this array starting at <code>start</code>
091 * into the array and continuing for <code>count</code>
092 * elements. Fewer than the requested number of elements will be
093 * returned if the array does not contain the requested number of elements.
094 * The object returned will be an array of Java objects of
095 * the appropriate types.
096 *
097 * @param start The offset into this array to start returning elements from.
098 * @param count The requested number of elements to return.
099 * @return The requested portion of the array.
100 * @exception SQLException If an error occurs.
101 */
102 Object getArray(long start, int count) throws SQLException;
103
104 /**
105 * This method returns a portion of this array starting at <code>start</code>
106 * into the array and continuing for <code>count</code>
107 * elements. Fewer than the requested number of elements will be
108 * returned if the array does not contain the requested number of elements.
109 * The object returned will be an array of Java objects. The specified
110 * <code>Map</code> will be used for overriding selected SQL type to
111 * Java class mappings.
112 *
113 * @param start The offset into this array to start returning elements from.
114 * @param count The requested number of elements to return.
115 * @param map A mapping of SQL types to Java classes.
116 * @return The requested portion of the array.
117 * @exception SQLException If an error occurs.
118 */
119 Object getArray(long start, int count, Map<String, Class<?>> map)
120 throws SQLException;
121
122 /**
123 * Returns the elements in the array as a <code>ResultSet</code>.
124 * Each row of the result set will have two columns. The first will be
125 * the index into the array of that row's contents. The second will be
126 * the actual value of that array element.
127 *
128 * @return The elements of this array as a <code>ResultSet</code>.
129 * @exception SQLException If an error occurs.
130 * @see ResultSet
131 */
132 ResultSet getResultSet() throws SQLException;
133
134 /**
135 * This method returns the elements in the array as a <code>ResultSet</code>.
136 * Each row of the result set will have two columns. The first will be
137 * the index into the array of that row's contents. The second will be
138 * the actual value of that array element. The specified <code>Map</code>
139 * will be used to override selected default mappings of SQL types to
140 * Java classes.
141 *
142 * @param map A mapping of SQL types to Java classes.
143 * @return The elements of this array as a <code>ResultSet</code>.
144 * @exception SQLException If an error occurs.
145 * @see ResultSet
146 */
147 ResultSet getResultSet(Map<String, Class<?>> map) throws SQLException;
148
149 /**
150 * This method returns a portion of the array as a <code>ResultSet</code>.
151 * The returned portion will start at <code>start</code> into the
152 * array and up to <code>count</code> elements will be returned.
153 * <p>
154 * Each row of the result set will have two columns. The first will be
155 * the index into the array of that row's contents. The second will be
156 * the actual value of that array element.
157 *
158 * @param start The index into the array to start returning elements from.
159 * @param count The requested number of elements to return.
160 * @return The requested elements of this array as a <code>ResultSet</code>.
161 * @exception SQLException If an error occurs.
162 * @see ResultSet
163 */
164 ResultSet getResultSet(long start, int count) throws SQLException;
165
166 /**
167 * This method returns a portion of the array as a <code>ResultSet</code>.
168 * The returned portion will start at <code>start</code> into the
169 * array and up to <code>count</code> elements will be returned.
170 *
171 * <p> Each row of the result set will have two columns. The first will be
172 * the index into the array of that row's contents. The second will be
173 * the actual value of that array element. The specified <code>Map</code>
174 * will be used to override selected default mappings of SQL types to
175 * Java classes.</p>
176 *
177 * @param start The index into the array to start returning elements from.
178 * @param count The requested number of elements to return.
179 * @param map A mapping of SQL types to Java classes.
180 * @return The requested elements of this array as a <code>ResultSet</code>.
181 * @exception SQLException If an error occurs.
182 * @see ResultSet
183 */
184 ResultSet getResultSet(long start, int count, Map<String, Class<?>> map)
185 throws SQLException;
186 }