1f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes/* 2adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Licensed to the Apache Software Foundation (ASF) under one or more 3adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * contributor license agreements. See the NOTICE file distributed with 4adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * this work for additional information regarding copyright ownership. 5adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * The ASF licenses this file to You under the Apache License, Version 2.0 6adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * (the "License"); you may not use this file except in compliance with 7adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the License. You may obtain a copy of the License at 8f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 9adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * http://www.apache.org/licenses/LICENSE-2.0 10f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 11adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Unless required by applicable law or agreed to in writing, software 12adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * distributed under the License is distributed on an "AS IS" BASIS, 13adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 14adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * See the License for the specific language governing permissions and 15adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * limitations under the License. 16adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 17adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 18adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectpackage javax.sql; 19adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 207365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.io.InputStream; 217365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.io.Reader; 227365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.math.BigDecimal; 2336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpeimport java.net.URL; 24adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.sql.Array; 25adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.sql.Blob; 26adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.sql.Clob; 27adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.sql.Date; 287365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.sql.NClob; 29adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.sql.Ref; 307365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.sql.ResultSet; 317365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.sql.RowId; 327365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.sql.SQLException; 3336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpeimport java.sql.SQLXML; 34adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.sql.Time; 35adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.sql.Timestamp; 36adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectimport java.util.Calendar; 377365de1056414750d0a7d1fdd26025fd247f0d04Jesse Wilsonimport java.util.Map; 38adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 39adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project/** 40adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * An interface which provides means to access data which 41adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * persists on a database. It extends the functionality of 42adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@link java.sql.ResultSet ResultSet} into a form that it can be used as a 43adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * JavaBean component, suited for a visual programming environment. 44adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 45adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code RowSet} provides getters and setters for properties relating to the 46adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * general database environment together with the getters and setters for 47adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * distinct data values which constitute the row set. The {@code RowSet} class 48adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * supports JavaBean events so that other components in an application can be 49adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * informed when changes happen such as changes in data values. 50adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 51adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code RowSet} is a facility implemented on top of the remainder of the JDBC 52adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * API. It may be <i>connected</i>, maintaining a connection to the database 53adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * throughout its lifecycle. The changes made on a <i>disconnected</i> {@code 54adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * RowSet} on the other hand can be persisted only establishing a new connection 55adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the database each time. 56adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 57adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Disconnected {@code RowSets} make use of {@code RowSetReaders} to populate 58adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code RowSet} with data, possibly from a non-relational database source. 59adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * They may also use {@code RowSetWriters} to send data back to the underlying 60adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * data store. There is considerable freedom in the way that {@code 61adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * RowSetReaders} and {@code RowSetWriters} may be implemented to retrieve and 62adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * store data. 63142d526f8bf90fb9bb63c637beb5299f39791f55Jesse Wilson * 64adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see RowSetReader 65adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see RowSetWriter 66adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 67adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Projectpublic interface RowSet extends ResultSet { 68adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 69adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 70adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Registers the supplied {@link RowSetListener} with this {@code RowSet}. 71adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Once registered, the {@link RowSetListener} is notified of events 72adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * generated by the {@code RowSet}. 73f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 74adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theListener 75adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * an object which implements the {@code rowSetListener} 76adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * interface. 77adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 78adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void addRowSetListener(RowSetListener theListener); 79adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 80adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 81adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Clears the parameters previously set for this {@code RowSet}. 82adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 83adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * The {@code RowSet} object retains its value until either a new value for 84adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * a parameter is set or its value is actively reset. {@code 85adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * clearParameters} provides a facility to clear the values for all 86adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * parameters with one method call. 87142d526f8bf90fb9bb63c637beb5299f39791f55Jesse Wilson * 88adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 89adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if a problem occurs accessing the database. 90adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 91adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void clearParameters() throws SQLException; 92adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 93adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 94adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Fetches data for this {@code RowSet} from the database. If successful, 95adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * any existing data for the {@code RowSet} is discarded and its metadata is 96adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * overwritten. 97adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 98adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Data is retrieved connecting to the database and executing an 99adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * according SQL statement. This requires some or all of the following 100adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * properties to be set: URL, database name, user name, password, 101adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * transaction isolation, type map; plus some or all of the properties: 102adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * command, read only, maximum field size, maximum rows, escape processing, 103adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * and query timeout. 104adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 105adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * The {@code RowSet} may use a {@code RowSetReader} to access the database 106adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * it will then invoke the {@link RowSetReader#readData} method on the 107adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * reader to fetch the data. When the new data is fetched all the listeners 108adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * are notified to take appropriate measures. 109142d526f8bf90fb9bb63c637beb5299f39791f55Jesse Wilson * 110adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 111adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if a problem occurs accessing the database or if the 112adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * properties needed to access the database have not been set. 113adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see RowSetMetaData 114adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see RowSetReader 115adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 116adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void execute() throws SQLException; 117adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 118adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 119adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the {@code RowSet}'s command property. 120f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 121adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return a string containing the {@code RowSet}'s command property. A 122adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * command is a SQL statement which is executed to fetch required 123adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * data into the {@code RowSet}. 124adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 125adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public String getCommand(); 126adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 127adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 128adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the ODBC Data Source Name property associated with this {@code 129adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * RowSet}. The database name can be used to find a {@link DataSource} 130adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * which has been registered with a naming service - the {@link DataSource} 131adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * can then be used to create a connection to the database. 132f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 133adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return the name of the database. 134adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 135adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public String getDataSourceName(); 136adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 137adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 138adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Reports if escape processing is enabled for this {@code RowSet}. If 139adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * escape processing is on, the driver performs a substitution of the escape 140adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * syntax with the applicable code before sending an SQL command to the 141adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * database. The default value for escape processing is {@code true}. 142f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 143adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return {@code true} if escape processing is enabled, {@code 144adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * false} otherwise. 145adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 146adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if a problem occurs accessing the database. 147adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 148adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public boolean getEscapeProcessing() throws SQLException; 149adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 150adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 151adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the maximum number of bytes that can be returned for column values 152adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * which are of type {@code BINARY}, {@code VARBINARY}, {@code 153adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * LONGVARBINARYBINARY}, {@code CHAR}, {@code VARCHAR}, or {@code 154adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * LONGVARCHAR}. Excess data is silently discarded if the number is 155adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * exceeded. 156f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 157adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return the current maximum size in bytes. 0 implies no size limit. 158adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 159adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if a problem occurs accessing the database. 160adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 161adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public int getMaxFieldSize() throws SQLException; 162adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 163adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 164adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the maximum number of rows for this {@code RowSet}. Excess rows are 165adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * discarded silently if the limit is exceeded. 166f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 167adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return the previous maximum number of rows. 0 implies no row limit. 168adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 169adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if a problem occurs accessing the database. 170adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 171adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public int getMaxRows() throws SQLException; 172adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 173adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 174adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the value of the password property for this {@code RowSet}. This 175adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * property is used when a connection to the database is established. 176adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Therefore it should be set prior to invoking the {@link #execute} method. 177f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 178adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return the value of the password property. 179adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 180adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public String getPassword(); 181adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 182adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 183adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the timeout for the driver when a query operation is executed. If a 184adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * query takes longer than the timeout then a {@code SQLException} is 185adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * thrown. 186f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 187adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return the timeout value in seconds. 188adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 189adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 190adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 191adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public int getQueryTimeout() throws SQLException; 192adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 193adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 194f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * Gets the transaction isolation level property set for this 195f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * {@code RowSet}. The transaction isolation level defines the 196f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * policy implemented on the database for maintaining the data 197adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * values consistent. 198f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 199adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return the current transaction isolation level. Must be one of: 200adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <ul> 201adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code Connection.TRANSACTION_READ_UNCOMMITTED}</li> 202adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code Connection.TRANSACTION_READ_COMMITTED}</li> 203adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code Connection.TRANSACTION_REPEATABLE_READ}</li> 204adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code Connection.TRANSACTION_SERIALIZABLE}</li> 205adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * </ul> 206adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.Connection 207adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 208adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public int getTransactionIsolation(); 209adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 210adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 211adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the custom mapping of SQL User-Defined Types (UDTs) and Java classes 212adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * for this {@code RowSet}, if applicable. 213f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 214adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return the custom mappings of SQL types to Java classes. 215adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 216adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 217adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 218adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public Map<String, Class<?>> getTypeMap() throws SQLException; 219adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 220adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 221adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the URL property value for this {@code RowSet}. If there is no 222adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code DataSource} object specified, the {@code RowSet} uses the URL to 223adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * establish a connection to the database. The default value for the URL is 224adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code null}. 225f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 226adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return a String holding the value of the URL property. 227adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 228adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 229adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 230adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public String getUrl() throws SQLException; 231adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 232adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 233adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the value of the {@code username} property for this {@code RowSet}. 234adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * The {@code username} is used when establishing a connection to the 235adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * database and should be set before the {@code execute} method is invoked. 236f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 237adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return a {@code String} holding the value of the {@code username} 238adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * property. 239adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 240adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public String getUsername(); 241adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 242adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 243adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Indicates if this {@code RowSet} is read-only. 244f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 245adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @return {@code true} if this {@code RowSet} is read-only, {@code false} 246adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if it is updatable. 247adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 248adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public boolean isReadOnly(); 249adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 250adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 251adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Removes a specified {@link RowSetListener} object from the set of 252adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * listeners which will be notified of events by this {@code RowSet}. 253f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 254adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theListener 255adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@link RowSetListener} to remove from the set of listeners 256adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * for this {@code RowSet}. 257adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 258adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void removeRowSetListener(RowSetListener theListener); 259adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 260adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 261adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the specified {@code ARRAY} parameter in the {@code RowSet} command 262adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the supplied {@code java.sql.Array} value. 263f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 264adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 265adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 266adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 267adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theArray 268adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Array} data value to which the parameter is set. 269adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 270adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 271adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 272adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setArray(int parameterIndex, Array theArray) 273adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 274adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 275adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 276adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 277adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the ASCII data in the supplied {@code java.io.InputStream} value. 278adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Data is read from the {@code InputStream} until end-of-file is reached. 279f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 280adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 281adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 282adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 283adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theInputStream 284adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the ASCII data value to which the parameter is set. 285adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param length 286adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the length of the data in bytes. 287adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 288adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 289adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 290adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setAsciiStream(int parameterIndex, InputStream theInputStream, 291adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project int length) throws SQLException; 292adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 293adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 29436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 29536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * ASCII data in the supplied java.io.InputStream value. Data is read from 29636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the InputStream until end-of-file is reached. 29736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 29836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 29936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 30036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 30136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 30236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the ASCII data to set into the 30336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 30436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 30536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 30636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 30736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 30836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setAsciiStream(int parameterIndex, InputStream theInputStream) 30936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 31036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 31136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 31236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 31336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * ASCII data in the supplied java.io.InputStream value. Data is read from 31436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the InputStream until end-of-file is reached. 31536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 31636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 31736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 31836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 31936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the ASCII data to set into the 32036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 32136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 32236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 32336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 32436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 32536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setAsciiStream(String parameterName, InputStream theInputStream) 32636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 32736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 32836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 32936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 33036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * ASCII data in the supplied java.io.InputStream value. Data is read from 33136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the InputStream until end-of-file is reached. 33236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 33336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 33436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 33536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 33636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the ASCII data to set into the 33736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 33836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 33936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in bytes 34036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 34136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 34236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 34336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setAsciiStream(String parameterName, 34436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe InputStream theInputStream, int length) throws SQLException; 34536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 34636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 347adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified SQL {@code NUMERIC} parameter in the 348adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code RowSet} command with the data in the supplied {@code 349adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * java.math.BigDecimal} value. 350f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 351adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 352adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 353adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 354adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theBigDecimal 355adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the big decimal value to which the parameter is set. 356adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 357adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 358adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 359adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setBigDecimal(int parameterIndex, BigDecimal theBigDecimal) 360adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 361adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 362adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 36336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified SQL NUMERIC parameter in the RowSet 36436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * command with the data in the supplied java.math.BigDecimal value. 36536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 36636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 36736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 36836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theBigDecimal 36936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the BigDecimal containing the value 37036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 37136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 37236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 37336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBigDecimal(String parameterName, BigDecimal theBigDecimal) 37436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 37536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 37636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 377adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 378adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to the binary data in the supplied input stream. Data is read from the 379adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * input stream until end-of-file is reached. 380f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 381adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 382adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 383adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 384adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theInputStream 385adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the binary data stream to which the parameter is set. 386adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param length 387adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the length of the data in bytes. 388adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 389adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 390adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 391adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setBinaryStream(int parameterIndex, InputStream theInputStream, 392adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project int length) throws SQLException; 393adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 394adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 39536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 39636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * binary data in the supplied java.io.InputStream value. Data is read from 39736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the InputStream until end-of-file is reached. 39836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 39936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 40036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 40136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 40236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 40336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the binary data to set into the 40436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 40536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 40636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 40736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 40836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBinaryStream(int parameterIndex, InputStream theInputStream) 40936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 41036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 41136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 41236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 41336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * binary data in the supplied java.io.InputStream value. Data is read from 41436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the InputStream until end-of-file is reached. 41536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 41636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 41736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 41836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 41936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the binary data to set into the 42036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 42136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 42236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 42336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 42436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBinaryStream(String parameterName, InputStream theInputStream) 42536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 42636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 42736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 42836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 42936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * binary data in the supplied java.io.InputStream value. Data is read from 43036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the InputStream until end-of-file is reached. 43136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 43236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 43336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 43436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 43536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the binary data to set into the 43636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 43736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 43836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in bytes 43936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 44036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 44136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 44236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBinaryStream(String parameterName, 44336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe InputStream theInputStream, int length) throws SQLException; 44436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 44536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 446adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 447adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to the supplied {@code Blob} value. 448f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 449adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 450adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 451adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 452adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theBlob 453adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Blob} value to which the parameter is set. 454adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 455adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 456adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 457adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setBlob(int parameterIndex, Blob theBlob) throws SQLException; 458adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 459adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 46036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 46136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.InputStream. Data is read from the 46236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * InputStream until end-of-file is reached. 46336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 46436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 46536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 46636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 46736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 46836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the binary data to set into the 46936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 47036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 47136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 47236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 47336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBlob(int parameterIndex, InputStream theInputStream) 47436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 47536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 47636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 47736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 47836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.InputStream. Data is read from the 47936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * InputStream until end-of-file is reached. 48036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 48136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 48236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 48336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 48436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 48536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the binary data to set into the 48636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 48736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 48836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in bytes 48936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 49036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 49136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 49236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBlob(int parameterIndex, InputStream theInputStream, 49336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe long length) throws SQLException; 49436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 49536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 49636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 49736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.InputStream. Data is read from the 49836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * InputStream until end-of-file is reached. 49936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 50036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 50136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 50236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 50336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the binary data to set into the 50436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 50536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 50636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 50736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 50836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBlob(String parameterName, InputStream theInputStream) 50936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 51036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 51136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 51236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 51336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.InputStream. Data is read from the 51436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * InputStream until end-of-file is reached. 51536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 51636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 51736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 51836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInputStream 51936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * an InputStream containing the binary data to set into the 52036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter value 52136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 52236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in bytes 52336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 52436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 52536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 52636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBlob(String parameterName, InputStream theInputStream, 52736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe long length) throws SQLException; 52836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 52936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 53036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 53136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.sql.Blob. 53236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 53336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 53436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the name for parameter 53536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theBlob 53636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Blob value to set 53736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 53836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 53936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 54036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBlob(String parameterName, Blob theBlob) throws SQLException; 54136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 54236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 543adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 544adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to the supplied boolean. 545f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 546adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 547adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 548adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 549adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theBoolean 550adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code boolean} value to which the parameter is set. 551adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 552adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 553adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 554adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setBoolean(int parameterIndex, boolean theBoolean) 555adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 556adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 557adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 55836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 55936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied boolean. 56036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 56136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 56236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 56336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theBoolean 56436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the boolean value to set 56536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 56636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 56736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 56836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBoolean(String parameterName, boolean theBoolean) 56936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 57036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 57136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 572adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 573adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to the supplied byte value. 574f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 575adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 576adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 577adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 578adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theByte 579adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code byte} value to which the parameter is set. 580adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 581adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 582adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 583adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setByte(int parameterIndex, byte theByte) throws SQLException; 584adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 585adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 58636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 58736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied byte value. 58836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 58936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 59036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 59136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theByte 59236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the byte value to set 59336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 59436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 59536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 59636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setByte(String parameterName, byte theByte) throws SQLException; 59736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 59836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 599adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 600adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to the supplied byte array value. 601f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 602adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 603adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 604adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 605adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theByteArray 606adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Array} of {@code bytes} to which the parameter is set. 607adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 608adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 609adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 610adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setBytes(int parameterIndex, byte[] theByteArray) 611adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 612adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 613adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 61436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 61536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied byte array value. 61636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 61736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 61836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 61936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theByteArray 62036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the array of bytes to set into the parameter. 62136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 62236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 62336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 62436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setBytes(String parameterName, byte[] theByteArray) 62536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 62636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 62736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 628adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 629adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to the sequence of Unicode characters carried by the supplied {@code 630adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * java.io.Reader}. 631f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 632adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 633adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 634adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 635adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theReader 636adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Reader} which contains the Unicode data to set the 637adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * parameter. 638adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param length 639adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the length of the data in the {@code Reader} in characters. 640adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 641adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 642adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 643adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setCharacterStream(int parameterIndex, Reader theReader, 644adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project int length) throws SQLException; 645adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 646adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 64736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 64836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * sequence of Unicode characters carried by the supplied java.io.Reader. 64936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 65036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 65136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 65236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 65336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 65436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 65536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 65636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 65736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 65836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 65936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setCharacterStream(int parameterIndex, Reader theReader) 66036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 66136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 66236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 66336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 66436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * sequence of Unicode characters carried by the supplied java.io.Reader. 66536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 66636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 66736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 66836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 66936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 67036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 67136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 67236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 67336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 67436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setCharacterStream(String parameterName, Reader theReader) 67536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 67636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 67736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 67836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 67936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * sequence of Unicode characters carried by the supplied java.io.Reader. 68036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 68136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 68236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 68336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 68436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 68536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 68636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 68736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in the Reader in characters 68836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 68936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 69036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 69136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setCharacterStream(String parameterName, Reader theReader, 69236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe int length) throws SQLException; 69336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 69436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 695adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 696adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the value of a supplied {@code java.sql.Clob}. 697f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 698adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 699adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 700adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 701adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theClob 702adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Clob} value to which the parameter is set. 703adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 704adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 705adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 706adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setClob(int parameterIndex, Clob theClob) throws SQLException; 707adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 708adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 70936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 71036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 71136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 71236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 71336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 71436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 71536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 71636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 71736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 71836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 71936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 72036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 72136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setClob(int parameterIndex, Reader theReader) 72236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 72336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 72436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 72536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 72636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 72736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 72836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 72936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 73036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 73136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 73236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 73336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 73436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 73536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in the Reader in characters 73636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 73736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 73836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 73936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setClob(int parameterIndex, Reader theReader, long length) 74036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 74136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 74236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 74336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 74436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.sql.Clob. 74536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 74636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 74736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 74836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theClob 74936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the specific Clob object 75036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 75136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 75236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 75336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setClob(String parameterName, Clob theClob) throws SQLException; 75436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 75536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 75636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 75736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 75836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 75936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 76036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 76136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 76236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 76336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 76436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 76536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 76636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 76736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setClob(String parameterName, Reader theReader) 76836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 76936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 77036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 77136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 77236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 77336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 77436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 77536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 77636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 77736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 77836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 77936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 78036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in the Reader in characters 78136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 78236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 78336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 78436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setClob(String parameterName, Reader theReader, long length) 78536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 78636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 78736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 788adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the Command property for this {@code RowSet} - the command is an SQL 789adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * query which runs when the {@code execute} method is invoked. This 790adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * property is optional for databases that do not support commands. 791f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 792adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param cmd 793adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the SQL query. Can be {@code null}. 794adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 795adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 796adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 797adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setCommand(String cmd) throws SQLException; 798adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 799adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 800adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the concurrency property of this {@code RowSet}. The default value 801adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is {@code ResultSet.CONCUR_READ_ONLY}. 802f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 803adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param concurrency 804adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the concurrency value. One of: 805adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <ul> 806adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code ResultSet.CONCUR_READ_ONLY}</li> 807adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code ResultSet.CONCUR_UPDATABLE}</li> 808adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * </ul> 809adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 810adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 811adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.ResultSet 812adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 813adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setConcurrency(int concurrency) throws SQLException; 814adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 815adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 816adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the database name property for the {@code RowSet}. 817adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 818adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * The database name can be used to find a {@link DataSource} which has been 819adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * registered with a naming service - the {@link DataSource} can then be 820adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * used to create a connection to the database. 821142d526f8bf90fb9bb63c637beb5299f39791f55Jesse Wilson * 822adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param name 823adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the database name. 824adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 825adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 826adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 827adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setDataSourceName(String name) throws SQLException; 828adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 829adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 830adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 831adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the value of a supplied {@code java.sql.Date}. 832f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 833adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 834adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 835adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 836adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theDate 837adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the date value to which the parameter is set. 838adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 839adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 840adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 841adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setDate(int parameterIndex, Date theDate) throws SQLException; 842adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 843adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 844adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 845adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the value of a supplied {@code java.sql.Date}, where the conversion 846adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * of the date to an SQL {@code DATE} value is calculated using a supplied 847adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code Calendar}. 848f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 849adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 850adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 851adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 852adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theDate 853adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the date to which the parameter is set. 854adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theCalendar 855adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Calendar} to use in converting the Date to an SQL 856adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code DATE} value. 857adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 858adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 859adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 860adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setDate(int parameterIndex, Date theDate, Calendar theCalendar) 861adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 862adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 863adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 86436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 86536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.sql.Date, where the conversion of the Date to an 86636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * SQL DATE value is calculated using a supplied Calendar. 86736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 86836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 86936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 87036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theDate 87136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Date to use 87236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 87336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 87436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 87536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setDate(String parameterName, Date theDate) throws SQLException; 87636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 87736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 87836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 87936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.sql.Date, where the conversion of the Date to an 88036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * SQL DATE value is calculated using a supplied Calendar. 88136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 88236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 88336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 88436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theDate 88536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Date to use 88636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theCalendar 88736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Calendar to use in converting the Date to an SQL DATE 88836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value 88936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 89036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 89136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 89236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setDate(String parameterName, Date theDate, Calendar theCalendar) 89336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 89436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 89536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 896adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 897adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the supplied {@code double}. 898f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 899adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 900adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 901adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 902adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theDouble 903adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code double} value to which the parameter is set. 904adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 905adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 906adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 907adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setDouble(int parameterIndex, double theDouble) 908adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 909adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 910adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 91136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 91236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied double. 91336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 91436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 91536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 91636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theDouble 91736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the double value to set 91836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 91936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 92036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 92136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setDouble(String parameterName, double theDouble) 92236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 92336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 92436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 925adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the escape processing status for this {@code RowSet}. If escape 926adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * processing is on, the driver performs a substitution of the escape syntax 927adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the applicable code before sending an SQL command to the database. 928adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * The default value for escape processing is {@code true}. 929f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 930adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param enable 931adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code true} to enable escape processing, {@code false} to 932adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * turn it off. 933adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 934adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 935adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 936adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setEscapeProcessing(boolean enable) throws SQLException; 937adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 938adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 939adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 940adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the supplied {@code float}. 941f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 942adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 943adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 944adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 945adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theFloat 946adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code float} value to which the parameter is set. 947adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 948adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 949adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 950adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setFloat(int parameterIndex, float theFloat) 951adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 952adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 953adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 95436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 95536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied float. 95636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 95736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 95836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 95936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theFloat 96036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the float value to set 96136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 96236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 96336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 96436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setFloat(String parameterName, float theFloat) 96536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 96636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 96736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 968adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 969adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the supplied {@code integer}. 970f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 971adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 972adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 973adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 974adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theInteger 975adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code integer} value to which the parameter is set. 976adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 977adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 978adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 979adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setInt(int parameterIndex, int theInteger) throws SQLException; 980adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 981adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 98236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 98336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied integer. 98436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 98536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 98636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 98736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theInteger 98836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the integer value to set 98936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 99036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 99136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 99236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setInt(String parameterName, int theInteger) 99336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 99436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 99536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 996adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 997adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * with the supplied {@code long}. 998f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 999adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1000adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1001adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1002adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theLong 1003adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code long} value value to which the parameter is set. 1004adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1005adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1006adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1007adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setLong(int parameterIndex, long theLong) throws SQLException; 1008adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1009adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 101036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 101136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied long. 101236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 101336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 101436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 101536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theLong 101636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the long value to set 101736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 101836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 101936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 102036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setLong(String parameterName, long theLong) throws SQLException; 102136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 102236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 1023adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the maximum number of bytes which can be returned for a column value 1024adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * where the column type is one of {@code BINARY}, {@code VARBINARY}, 1025adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code LONGVARBINARYBINARY}, {@code CHAR}, {@code VARCHAR}, or {@code 1026adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * LONGVARCHAR}. Data which exceeds this limit is silently discarded. For 1027adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * portability, a value greater than 256 is recommended. 1028f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1029adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param max 1030adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the maximum size of the returned column value in bytes. 0 1031adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * implies no size limit. 1032adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1033adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1034adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1035adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setMaxFieldSize(int max) throws SQLException; 1036adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1037adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1038adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the maximum number of rows which can be held by the {@code RowSet}. 1039adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Any additional rows are silently discarded. 1040f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1041adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param max 1042adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the maximum number of rows which can be held in the {@code 1043adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * RowSet}. 0 means no limit. 1044adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1045adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1046adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1047adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setMaxRows(int max) throws SQLException; 1048adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1049adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 105036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 105136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 105236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 105336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 105436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 105536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 105636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 105736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 105836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 105936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 106036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 106136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 106236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNCharacterStream(int parameterIndex, Reader theReader) 106336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 106436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 106536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 106636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 106736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 106836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 106936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 107036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 107136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 107236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 107336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 107436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 107536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 107636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in the Reader in characters 107736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 107836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 107936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 108036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNCharacterStream(int parameterIndex, Reader theReader, 108136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe long length) throws SQLException; 108236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 108336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 108436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 108536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 108636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 108736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 108836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 108936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 109036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 109136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 109236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 109336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 109436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 109536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNCharacterStream(String parameterName, Reader theReader) 109636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 109736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 109836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 109936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 110036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 110136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 110236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 110336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 110436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 110536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 110636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 110736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 110836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in the Reader in characters 110936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 111036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 111136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 111236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNCharacterStream(String parameterName, Reader theReader, 111336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe long length) throws SQLException; 111436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 111536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 111636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 111736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.sql.NClob. 111836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 111936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 112036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 112136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 112236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theNClob 112336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the NClob value to set 112436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 112536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 112636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 112736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNClob(int parameterIndex, NClob theNClob) 112836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 112936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 113036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 113136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 113236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 113336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 113436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 113536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 113636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 113736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 113836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 113936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 114036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 114136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 114236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 114336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNClob(int parameterIndex, Reader theReader) 114436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 114536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 114636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 114736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 114836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 114936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 115036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 115136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 115236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 115336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 115436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 115536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 115636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 115736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in the Reader in characters 115836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 115936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 116036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 116136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNClob(int parameterIndex, Reader theReader, long length) 116236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 116336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 116436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 116536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 116636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.sql.NClob. 116736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 116836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 116936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 117036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theNClob 117136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the NClob value to set 117236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 117336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 117436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 117536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNClob(String parameterName, NClob theNClob) 117636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 117736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 117836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 117936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 118036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 118136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 118236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 118336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 118436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 118536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 118636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 118736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 118836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 118936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 119036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNClob(String parameterName, Reader theReader) 119136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 119236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 119336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 119436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command with the 119536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * value of a supplied java.io.Reader. 119636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 119736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 119836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 119936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theReader 120036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Reader which contains the Unicode data to set into the 120136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * parameter 120236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param length 120336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the length of the data in the Reader in characters 120436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 120536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 120636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 120736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNClob(String parameterName, Reader theReader, long length) 120836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 120936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 121036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 121136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 121236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied NString 121336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 121436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 121536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 121636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 121736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theNString 121836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the NString value to set 121936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 122036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 122136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 122236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNString(int parameterIndex, String theNString) 122336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 122436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 122536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 122636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 122736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied NString. 122836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 122936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 123036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 123136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theNString 123236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the NString value to set 123336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 123436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 123536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 123636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNString(String parameterName, String theNString) 123736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 123836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 123936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 1240adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1241adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to SQL {@code NULL}. 1242f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1243adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1244adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1245adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1246adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param sqlType 1247adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the type of the parameter, as defined by {@code 1248adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * java.sql.Types}. 1249adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1250adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1251adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1252adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setNull(int parameterIndex, int sqlType) throws SQLException; 1253adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1254adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1255adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1256adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to SQL {@code NULL}. This form of the {@code setNull} method should be 1257adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * used for User Defined Types and {@code REF} parameters. 1258f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1259adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1260adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1261adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1262adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param sqlType 1263adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the type of the parameter, as defined by {@code 1264adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * java.sql.Types}. 1265adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param typeName 1266adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the fully qualified name of an SQL user defined type or the 1267adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * name of the SQL structured type referenced by a {@code REF} 1268adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * type. Ignored if the sqlType is not a UDT or REF type. 1269adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1270adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1271adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1272adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setNull(int parameterIndex, int sqlType, String typeName) 1273adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 1274adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1275adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 127636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to SQL 127736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * NULL. This form of the <code>setNull</code> method should be used for 127836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * User Defined Types and REF parameters. 127936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 128036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 128136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 128236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param sqlType 128336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the type of the parameter, as defined by java.sql.Types. 128436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 128536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 128636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 128736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNull(String parameterName, int sqlType) throws SQLException; 128836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 128936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 129036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to SQL 129136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * NULL. This form of the <code>setNull</code> method should be used for 129236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * User Defined Types and REF parameters. 129336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 129436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 129536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 129636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param sqlType 129736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the type of the parameter, as defined by java.sql.Types. 129836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param typeName 129936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the fully qualified name of an SQL User Defined Type or the 130036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name of the SQL structured type referenced by a REF type. 130136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Ignored if the sqlType is not a UDT or REF type. 130236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 130336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 130436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 130536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setNull(String parameterName, int sqlType, String typeName) 130636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 130736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 130836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 1309adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1310adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied Java object. 1311adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 1312adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * The JDBC specification provides a standard mapping for Java objects to 1313adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * SQL data types. Database specific types can be mapped by JDBC driver 1314adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * specific Java types. 1315142d526f8bf90fb9bb63c637beb5299f39791f55Jesse Wilson * 1316adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1317adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1318adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1319adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theObject 1320adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the Java object containing the data value to which the 1321adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * parameter is set. 1322adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1323adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1324adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1325adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setObject(int parameterIndex, Object theObject) 1326adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 1327adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1328adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1329adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1330adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied Java object. 1331f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1332adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1333adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1334adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1335adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theObject 1336adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the Java object containing the data value. 1337adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param targetSqlType 1338adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the SQL type to send to the database, as defined in {@code 1339adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * java.sql.Types}. 1340adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1341adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1342adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1343adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setObject(int parameterIndex, Object theObject, 1344adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project int targetSqlType) throws SQLException; 1345adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1346adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1347adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1348adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied Java object. 1349f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1350adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1351adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1352adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1353adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theObject 1354adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the Java object containing the data value. 1355adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param targetSqlType 1356adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the SQL type to send to the database, as defined in {@code 1357adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * java.sql.Types}. 1358adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param scale 1359adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the number of digits after the decimal point, for {@code 1360adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * java.sql.Types.DECIMAL} and {@code java.sql.Types.NUMERIC} 1361adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * types. Ignored for all other types. 1362adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1363adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1364adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1365adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setObject(int parameterIndex, Object theObject, 1366adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project int targetSqlType, int scale) throws SQLException; 1367adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 136836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 136936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 137036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied Java object. 137136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 137236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 137336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 137436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theObject 137536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Java object containing the data value. 137636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 137736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 137836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 137936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setObject(String parameterName, Object theObject) 138036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 138136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 138236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 138336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 138436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied Java object. 138536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 138636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 138736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 138836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theObject 138936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Java object containing the data value. 139036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param targetSqlType 139136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the SQL type to send to the database, as defined in 139236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * java.sql.Types. 139336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 139436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 139536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 139636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setObject(String parameterName, Object theObject, 139736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe int targetSqlType) throws SQLException; 139836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 139936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 140036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 140136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied Java object. 140236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 140336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 140436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 140536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theObject 140636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Java object containing the data value. 140736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param targetSqlType 140836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the SQL type to send to the database, as defined in 140936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * java.sql.Types. 141036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param scale 141136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the number of digits after the decimal point, for 141236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * java.sql.Types.DECIMAL and java.sql.Types.NUMERIC types. 141336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Ignored for all other types. 141436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 141536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 141636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 141736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setObject(String parameterName, Object theObject, 141836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe int targetSqlType, int scale) throws SQLException; 141936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 1420adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1421adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the database Password for this {@code RowSet}. This property is used 1422adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * when a connection to the database is established. Therefore it should be 1423adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * set prior to invoking the {@link #execute} method. 1424f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1425adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param password 1426adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * a {@code String} holding the password. 1427adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1428adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1429adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1430adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setPassword(String password) throws SQLException; 1431adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1432adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1433adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Gets the timeout for the driver when a query operation is executed. If a 1434adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * query takes longer than the timeout, a {@code SQLException} is thrown. 1435f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1436adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param seconds 1437adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the number of seconds for the timeout. 1438adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1439adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1440adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1441adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setQueryTimeout(int seconds) throws SQLException; 1442adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1443adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1444adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets whether the {@code RowSet} is read-only or updatable. 1445f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1446adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param readOnly 1447adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code true} to set the {@code RowSet} to read-only state, 1448adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code false} to allow updates. 1449adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1450adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1451adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1452adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setReadOnly(boolean readOnly) throws SQLException; 1453adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1454adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1455adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1456adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied {@code java.sql.Ref}. This is sent to the database as an 1457adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * SQL {@code REF} value. 1458f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1459adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1460adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1461adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1462adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theRef 1463adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the value to which the parameter is set. 1464adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1465adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1466adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.Ref 1467adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1468adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setRef(int parameterIndex, Ref theRef) throws SQLException; 1469adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1470adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1471adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1472adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied {@code short integer}. 1473f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1474adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1475adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1476adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1477adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theShort 1478adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the value to which the parameter is set. 1479adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1480adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1481adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1482adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setShort(int parameterIndex, short theShort) 1483adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 1484adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1485adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 148636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 148736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied short integer. 148836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 148936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 149036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 149136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theShort 149236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the short value to set 149336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 149436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 149536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 149636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setShort(String parameterName, short theShort) 149736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 149836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 149936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 1500adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1501adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied {@code String}. The string is placed into the database as a 1502adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code VARCHAR} or {@code LONGVARCHAR} SQL value, depending on the 1503adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * database limits for the length of {@code VARCHAR} values. 1504f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1505adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1506adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1507adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1508adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theString 1509adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the value to which the parameter is set. 1510adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1511adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1512adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1513adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setString(int parameterIndex, String theString) 1514adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 1515adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1516adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 151736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 151836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied String. The String is placed into the database as a VARCHAR or 151936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * LONGVARCHAR SQL value, depending on the database limits for the length of 152036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * VARCHAR values. 152136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 152236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 152336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 152436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theString 152536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 152636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 152736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 152836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setString(String parameterName, String theString) 152936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 153036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 153136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 153236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 153336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied RowId 153436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 153536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 153636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 153736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 153836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theRowId 153936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the RowId value to set 154036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 154136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 154236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 154336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setRowId(int parameterIndex, RowId theRowId) 154436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 154536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 154636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 154736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 154836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied RowId. 154936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 155036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 155136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 155236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theRowId 155336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the RowId value to set 155436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 155536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 155636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 155736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setRowId(String parameterName, RowId theRowId) 155836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 155936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 156036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 156136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 156236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied SQLXML 156336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 156436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 156536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 156636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 156736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theSQLXML 156836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the SQLXML value to set 156936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 157036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 157136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 157236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setSQLXML(int parameterIndex, SQLXML theSQLXML) 157336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 157436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 157536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 157636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to the 157736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied SQLXML. 157836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 157936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 158036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 158136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theSQLXML 158236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the SQLXML value to set 158336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 158436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 158536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 158636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setSQLXML(String parameterName, SQLXML theSQLXML) 158736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 158836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 158936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 1590adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1591adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied {@code java.sql.Time}, converting it to an SQL {@code TIME} 1592adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * value using the system default {@code Calendar}. 1593f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1594adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1595adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1596adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1597adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theTime 1598adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the value to which the parameter is set. 1599adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1600adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1601adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.util.Calendar 1602adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.Time 1603adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1604adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setTime(int parameterIndex, Time theTime) throws SQLException; 1605adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1606adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1607adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1608adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied {@code java.sql.Time}, converting it to an SQL {@code TIME} 1609adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * value using a supplied {@code Calendar}. 1610f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1611adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1612adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1613adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1614adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theTime 1615adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the value to which the parameter is set. 1616adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theCalendar 1617adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Calendar} to use in the conversion operation. 1618adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1619adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1620adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.util.Calendar 1621adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.Time 1622adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1623adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setTime(int parameterIndex, Time theTime, Calendar theCalendar) 1624adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 1625adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1626adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 162736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 162836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied java.sql.Time, converting to an SQL TIME value using a supplied 162936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Calendar. 163036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 163136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 163236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 163336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theTime 163436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Time value to set 163536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 163636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 163736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 163836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setTime(String parameterName, Time theTime) throws SQLException; 163936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 164036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 164136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 164236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied java.sql.Time, converting to an SQL TIME value using a supplied 164336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Calendar. 164436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 164536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 164636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 164736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theTime 164836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Time value to set 164936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theCalendar 165036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Calendar to use in the conversion operation 165136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 165236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 165336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 165436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setTime(String parameterName, Time theTime, Calendar theCalendar) 165536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 165636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 165736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 1658adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1659adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied {@code java.sql.Timestamp}, converting it to an SQL {@code 1660adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * TIMESTAMP} value using the system default {@code Calendar}. 1661f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1662adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1663adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1664adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1665adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theTimestamp 1666adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the value to which the parameter is set. 1667adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1668adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1669adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.util.Calendar 1670adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.Timestamp 1671adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1672adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setTimestamp(int parameterIndex, Timestamp theTimestamp) 1673adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 1674adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1675adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1676adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the value of the specified parameter in the {@code RowSet} command 1677adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * to a supplied {@code java.sql.Timestamp}, converting it to an SQL {@code 1678adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * TIMESTAMP} value using a supplied {@code Calendar}. 1679f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1680adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param parameterIndex 1681adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the index of the parameter to set; the first parameter's index 1682adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * is 1. 1683adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theTimestamp 1684adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the value to which the parameter is set. 1685adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theCalendar 1686adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the {@code Calendar} to use in the conversion operation 1687adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1688adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1689adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.util.Calendar 1690adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.Timestamp 1691adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1692adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setTimestamp(int parameterIndex, Timestamp theTimestamp, 1693adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project Calendar theCalendar) throws SQLException; 1694adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 169536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 169636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 169736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied java.sql.Timestamp converting to an SQL TIMESTAMP value 169836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * using the system default {@code Calendar}. 169936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 170036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 170136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 170236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theTimestamp 170336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the value to which the parameter is set 170436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 170536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 170636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 170736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setTimestamp(String parameterName, Timestamp theTimestamp) 170836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe throws SQLException; 170936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 171036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 171136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the value of the specified parameter in the RowSet command to a 171236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a 171336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * supplied Calendar. 171436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 171536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterName 171636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * name for parameter 171736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theTimestamp 171836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the value to which the parameter is set 171936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theCalendar 172036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * the Calendar to use in the conversion operation 172136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 172236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 172336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 172436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setTimestamp(String parameterName, Timestamp theTimestamp, 172536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe Calendar theCalendar) throws SQLException; 172636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 1727adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1728adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the target instance's transaction isolation level to one of a 1729adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * discrete set of possible values. The transaction isolation level defines 1730adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the policy implemented on the database for maintaining the data values 1731adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * consistent. 1732adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <p> 1733adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Keep in mind that setting a transaction isolation level has no effect 1734adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * unless your driver and DBMS support it. 1735142d526f8bf90fb9bb63c637beb5299f39791f55Jesse Wilson * 1736adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param level 1737adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the transaction isolation level. One of: 1738adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <ul> 1739f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * <li>{@code Connection.TRANSACTION_READ_UNCOMMITTED}</li> 1740f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * <li>{@code Connection.TRANSACTION_READ_COMMITTED}</li> 1741f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * <li>{@code Connection.TRANSACTION_REPEATABLE_READ}</li> 1742adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code Connection.TRANSACTION_SERIALIZABLE}</li> 1743adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * </ul> 1744adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1745adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1746adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @see java.sql.Connection 1747adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1748adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setTransactionIsolation(int level) throws SQLException; 1749adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1750adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1751adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the type of this {@code RowSet}. By default, the type is 1752adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * non-scrollable. 1753f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1754adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param type 1755adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the type for the {@code RowSet}. One of: 1756adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <ul> 1757f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * <li>{@code ResultSet.TYPE_FORWARD_ONLY}</li> 1758f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * <li>{@code ResultSet.TYPE_SCROLL_INSENSITIVE}</li> 1759adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * <li>{@code ResultSet.TYPE_SCROLL_SENSITIVE}</li> 1760adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * </ul> 1761adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1762adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1763adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1764adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setType(int type) throws SQLException; 1765adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1766adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1767adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the mapping of SQL User Defined Types (UDTs) to Java classes. The 1768adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Java classes must all implement the {@link java.sql.SQLData SQLData} 1769adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * interface. 1770f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1771adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theTypeMap 1772adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the names of SQL UDTs and the Java classes to which they are 1773adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * mapped. 1774adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1775adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1776adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1777adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setTypeMap(Map<String, Class<?>> theTypeMap) 1778adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project throws SQLException; 1779adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1780adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 1781adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the URL used by this {@code RowSet} to access the database via a 1782adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * {@code DriverManager}. The URL is optional - an alternative is to use a 1783adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * database name to create a connection. 1784f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1785adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theURL 1786adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the URL for the database. Can be {@code null}. 1787adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1788adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1789adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1790adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setUrl(String theURL) throws SQLException; 1791adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project 1792adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project /** 179336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * Sets the URL used by this RowSet to access the database via a 179436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * <code>DriverManager</code>. The URL is optional - an alternative is to 179536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * use a Data Source Name to create a connection. 179636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * 179736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param parameterIndex 179836b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index of the parameter to set, where the first parameter has 179936b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * index = 1. 180036b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @param theURL 180136b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * a java.net.URL containing the URL for the database. 180236b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * @throws SQLException 180336b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe * if an error occurs accessing the database. 180436b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe */ 180536b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe public void setURL(int parameterIndex, URL theURL) throws SQLException; 180636b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe 180736b3cdfbcd219d0308753d919638262c16fd34daJeremy Sharpe /** 1808adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * Sets the {@code Username} property for the {@code RowSet}, used to 1809adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * authenticate a connection to the database. 1810f33eae7e84eb6d3b0f4e86b59605bb3de73009f3Elliott Hughes * 1811adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @param theUsername 1812adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * the new user name for this row set. 1813adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * @throws SQLException 1814adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project * if an error occurs accessing the database. 1815adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project */ 1816adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project public void setUsername(String theUsername) throws SQLException; 1817adc854b798c1cfe3bfd4c27d68d5cee38ca617daThe Android Open Source Project} 1818