org.firebirdsql.jdbc.AbstractPreparedStatement Maven / Gradle / Ivy
Show all versions of jaybird-jdk15 Show documentation
/*
* $Id: AbstractPreparedStatement.java 58744 2013-11-02 11:59:48Z mrotteveel $
*
* Firebird Open Source J2ee connector - jdbc driver
*
* Distributable under LGPL license.
* You may obtain a copy of the License at http://www.gnu.org/copyleft/lgpl.html
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* LGPL License for more details.
*
* This file was created by members of the firebird development team.
* All individual contributions remain the Copyright (C) of those
* individuals. Contributors to this file are either listed here or
* can be obtained from a CVS history command.
*
* All rights reserved.
*/
package org.firebirdsql.jdbc;
import java.io.*;
import java.math.*;
import java.net.URL;
import java.sql.*;
import java.sql.Date;
import java.util.*;
import org.firebirdsql.gds.*;
import org.firebirdsql.gds.impl.GDSHelper;
import org.firebirdsql.jdbc.field.*;
import org.firebirdsql.jdbc.field.FBFlushableField.CachedObject;
/**
* Implementation of {@link java.sql.PreparedStatement}interface. This class
* contains all methods from the JDBC 2.0 specification.
*
* @author David Jencks
* @author Roman Rokytskyy
* @author Mark Rotteveel
*/
public abstract class AbstractPreparedStatement extends AbstractStatement implements
FirebirdPreparedStatement {
static final String METHOD_NOT_SUPPORTED = "This method is only supported on Statement and not supported on PreparedStatement and CallableStatement";
private boolean metaDataQuery;
/**
* This flag is needed to guarantee the correct behavior in case when it
* was created without controlling Connection object (in some metadata
* queries we have only GDSHelper instance)
*/
private boolean standaloneStatement;
/**
* This flag is needed to prevent throwing an exception for the case when
* result set is returned for INSERT statement and the statement should
* return the generated keys.
*/
private boolean generatedKeys;
// this array contains either true or false indicating if parameter
// was initialized, executeQuery, executeUpdate and execute methods
// will throw an exception if this array contains at least one false value.
protected boolean[] isParamSet;
private FBField[] fields = null;
// we need to handle procedure execution separately,
// because in this case we must send out_xsqlda to the server.
private boolean isExecuteProcedureStatement;
private boolean trimStrings;
private FBObjectListener.BlobListener blobListener;
/**
* Create instance of this class for the specified result set type and
* concurrency. This constructor is used only in {@link AbstractCallableStatement}
* since the statement is prepared right before the execution.
*
* @param c instance of {@link GDSHelper} that will be used to perform all
* database activities.
*
* @param rsType desired result set type.
* @param rsConcurrency desired result set concurrency.
*
* @param statementListener statement listener that will be notified about
* the statement start, close and completion.
*
* @throws SQLException if something went wrong.
*/
protected AbstractPreparedStatement(GDSHelper c, int rsType,
int rsConcurrency, int rsHoldability,
FBObjectListener.StatementListener statementListener,
FBObjectListener.BlobListener blobListener)
throws SQLException {
super(c, rsType, rsConcurrency, rsHoldability, statementListener);
this.blobListener = blobListener;
}
/**
* Create instance of this class and prepare SQL statement.
*
* @param c
* connection to be used.
* @param sql
* SQL statement to prepare.
* @param rsType
* type of result set to create.
* @param rsConcurrency
* result set concurrency.
*
* @throws SQLException
* if something went wrong.
*/
protected AbstractPreparedStatement(GDSHelper c, String sql, int rsType,
int rsConcurrency, int rsHoldability,
FBObjectListener.StatementListener statementListener,
FBObjectListener.BlobListener blobListener,
boolean metaDataQuery, boolean standaloneStatement, boolean generatedKeys)
throws SQLException {
super(c, rsType, rsConcurrency, rsHoldability, statementListener);
this.blobListener = blobListener;
this.metaDataQuery = metaDataQuery;
this.standaloneStatement = standaloneStatement;
this.generatedKeys = generatedKeys;
try {
notifyStatementStarted();
prepareFixedStatement(sql, true);
} catch (GDSException ge) {
notifyStatementCompleted(false);
throw new FBSQLException(ge);
} catch (SQLException sqle) {
notifyStatementCompleted(false);
throw sqle;
} catch (RuntimeException e) {
notifyStatementCompleted(false);
throw e;
}
}
@Override
public void completeStatement(CompletionReason reason) throws SQLException {
if (!metaDataQuery) {
super.completeStatement(reason);
} else if (!completed) {
notifyStatementCompleted();
}
}
protected void notifyStatementCompleted(boolean success)
throws SQLException {
try {
super.notifyStatementCompleted(success);
} finally {
if (metaDataQuery && standaloneStatement)
close();
}
}
/**
* Executes the SQL query in this PreparedStatement object
* and returns the result set generated by the query.
*
* @return a ResultSet object that contains the data produced
* by the query; never null
* @exception SQLException
* if a database access error occurs
*/
public ResultSet executeQuery() throws SQLException {
Object syncObject = getSynchronizationObject();
synchronized (syncObject) {
notifyStatementStarted();
if (!internalExecute(isExecuteProcedureStatement))
throw new FBSQLException(
"No resultset for sql",
FBSQLException.SQL_STATE_NO_RESULT_SET);
return getResultSet();
}
}
/**
* Executes the SQL INSERT, UPDATE or DELETE statement in this
* PreparedStatement object. In addition, SQL statements that
* return nothing, such as SQL DDL statements, can be executed.
*
* @return either the row count for INSERT, UPDATE or DELETE statements; or
* 0 for SQL statements that return nothing
* @exception SQLException
* if a database access error occurs
*/
public int executeUpdate() throws SQLException {
Object syncObject = getSynchronizationObject();
synchronized (syncObject) {
notifyStatementStarted();
try {
if (internalExecute(isExecuteProcedureStatement) && !generatedKeys) {
throw new FBSQLException(
"Update statement returned results.");
}
return getUpdateCount();
} finally {
notifyStatementCompleted();
}
}
}
public FirebirdParameterMetaData getFirebirdParameterMetaData() throws SQLException {
return new FBParameterMetaData(fixedStmt.getInSqlda().sqlvar, gdsHelper);
}
/**
* Sets the designated parameter to SQL NULL.
*
*
* Note: You must specify the parameter's SQL type.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param sqlType
* the SQL type code defined in java.sql.Types
* @exception SQLException
* if a database access error occurs
*/
public void setNull(int parameterIndex, int sqlType) throws SQLException {
getField(parameterIndex).setNull();
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given input stream, which will have
* the specified number of bytes.
*
*
* Note: This stream object can either be a standard Java stream
* object or your own subclass that implements the standard interface.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param inputStream
* the Java input stream
* @param length
* the number of bytes in the stream
* @exception SQLException
* if a database access error occurs
*/
public void setBinaryStream(int parameterIndex, InputStream inputStream,
int length) throws SQLException {
getField(parameterIndex).setBinaryStream(inputStream, length);
isParamSet[parameterIndex - 1] = true;
}
public void setBinaryStream(int parameterIndex, InputStream x, long length)
throws SQLException {
if (length > Integer.MAX_VALUE)
throw new FBDriverNotCapableException("Only length <= Integer.MAX_VALUE supported");
setBinaryStream(parameterIndex, x, (int)length);
}
public void setBinaryStream(int parameterIndex, InputStream x)
throws SQLException {
throw new FBDriverNotCapableException();
}
/**
* Set the designated parameter to the given byte array.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The byte array to be set
* @throws SQLException
* if a database access occurs
*/
public void setBytes(int parameterIndex, byte[] x) throws SQLException {
getField(parameterIndex).setBytes(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given boolean value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The boolean value to be set
* @throws SQLException
* if a database access occurs
*/
public void setBoolean(int parameterIndex, boolean x) throws SQLException {
getField(parameterIndex).setBoolean(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given byte value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The byte value to be set
* @throws SQLException
* if a database access occurs
*/
public void setByte(int parameterIndex, byte x) throws SQLException {
getField(parameterIndex).setByte(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given date value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The date value to be set
* @throws SQLException
* if a database access occurs
*/
public void setDate(int parameterIndex, Date x) throws SQLException {
getField(parameterIndex).setDate(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given double value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The double value to be set
* @throws SQLException
* if a database access occurs
*/
public void setDouble(int parameterIndex, double x) throws SQLException {
getField(parameterIndex).setDouble(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given floate value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The float value to be set
* @throws SQLException
* if a database access occurs
*/
public void setFloat(int parameterIndex, float x) throws SQLException {
getField(parameterIndex).setFloat(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given int value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The int value to be set
* @throws SQLException
* if a database access occurs
*/
public void setInt(int parameterIndex, int x) throws SQLException {
getField(parameterIndex).setInteger(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given long value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The long value to be set
* @throws SQLException
* if a database access occurs
*/
public void setLong(int parameterIndex, long x) throws SQLException {
getField(parameterIndex).setLong(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the value of the designated parameter with the given object.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the object containing the parameter value
* @throws SQLException
* if a database access error occurs
*/
public void setObject(int parameterIndex, Object x) throws SQLException {
getField(parameterIndex).setObject(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given short value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The short value to be set
* @throws SQLException
* if a database access occurs
*/
public void setShort(int parameterIndex, short x) throws SQLException {
getField(parameterIndex).setShort(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given String value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The String value to be set
* @throws SQLException
* if a database access occurs
*/
public void setString(int parameterIndex, String x) throws SQLException {
getField(parameterIndex).setString(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given String value. This is a
* workaround for the ambiguous "operation was cancelled" response from the
* server for when an oversized string is set for a limited-size field. This
* method sets the string parameter without checking size constraints.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The String value to be set
* @throws SQLException
* if a database access occurs
*/
public void setStringForced(int parameterIndex, String x)
throws SQLException {
FBField field = getField(parameterIndex);
if (field instanceof FBWorkaroundStringField)
((FBWorkaroundStringField) field).setStringForced(x);
else
field.setString(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given Time value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The Time value to be set
* @throws SQLException
* if a database access occurs
*/
public void setTime(int parameterIndex, Time x) throws SQLException {
getField(parameterIndex).setTime(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given Timestamp value.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* The Timestamp value to be set
* @throws SQLException
* if a database access occurs
*/
public void setTimestamp(int parameterIndex, Timestamp x)
throws SQLException {
getField(parameterIndex).setTimestamp(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given BigDecimal
*
* @param parameterIndex
* The first parameter is 1, second is 2, ...
* @param x
* The BigDecimal to be set as a parameter
* @throws SQLException
* if a database access error occurs
*/
public void setBigDecimal(int parameterIndex, BigDecimal x)
throws SQLException {
getField(parameterIndex).setBigDecimal(x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Returns the XSQLVAR structure for the specified column.
*/
protected XSQLVAR getXsqlvar(int columnIndex) {
return fixedStmt.getInSqlda().sqlvar[columnIndex - 1];
}
/**
* Factory method for the field access objects
*/
protected FBField getField(int columnIndex) throws SQLException {
if (columnIndex > fields.length)
throw new FBSQLException("Invalid column index.",
FBSQLException.SQL_STATE_INVALID_COLUMN);
return fields[columnIndex - 1];
}
/**
* Sets the designated parameter to the given input stream, which will have
* the specified number of bytes. When a very large ASCII value is input to
* a LONGVARCHAR parameter, it may be more practical to send
* it via a java.io.InputStream. Data will be read from the
* stream as needed until end-of-file is reached. The JDBC driver will do
* any necessary conversion from ASCII to the database char format.
*
*
* Note: This stream object can either be a standard Java stream
* object or your own subclass that implements the standard interface.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the Java input stream that contains the ASCII parameter value
* @param length
* the number of bytes in the stream
* @exception SQLException
* if a database access error occurs
*/
public void setAsciiStream(int parameterIndex, InputStream x, int length)
throws SQLException {
setBinaryStream(parameterIndex, x, length);
}
public void setAsciiStream(int parameterIndex, InputStream x, long length)
throws SQLException {
setBinaryStream(parameterIndex, x, length);
}
public void setAsciiStream(int parameterIndex, InputStream x)
throws SQLException {
setBinaryStream(parameterIndex, x);
}
/**
* Sets the designated parameter to the given input stream, which will have
* the specified number of bytes. When a very large UNICODE value is input
* to a LONGVARCHAR parameter, it may be more practical to
* send it via a java.io.InputStream object. The data will be
* read from the stream as needed until end-of-file is reached. The JDBC
* driver will do any necessary conversion from UNICODE to the database char
* format. The byte format of the Unicode stream must be Java UTF-8, as
* defined in the Java Virtual Machine Specification.
*
*
* Note: This stream object can either be a standard Java stream
* object or your own subclass that implements the standard interface.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the java input stream which contains the UNICODE parameter
* value
* @param length
* the number of bytes in the stream
* @exception SQLException
* if a database access error occurs
* @deprecated
*
* I really have no idea if there is anything else we should be doing here
*/
public void setUnicodeStream(int parameterIndex, InputStream x, int length)
throws SQLException {
setBinaryStream(parameterIndex, x, length);
isParamSet[parameterIndex - 1] = true;
}
public void setURL(int parameterIndex, URL url) throws SQLException {
throw new FBDriverNotCapableException();
}
public void setNCharacterStream(int parameterIndex, Reader value,
long length) throws SQLException {
throw new FBDriverNotCapableException();
}
public void setNCharacterStream(int parameterIndex, Reader value)
throws SQLException {
throw new FBDriverNotCapableException();
}
public void setNClob(int parameterIndex, Reader reader, long length)
throws SQLException {
throw new FBDriverNotCapableException();
}
public void setNClob(int parameterIndex, Reader reader) throws SQLException {
throw new FBDriverNotCapableException();
}
public void setNString(int parameterIndex, String value)
throws SQLException {
throw new FBDriverNotCapableException();
}
/**
* Clears the current parameter values immediately.
*
* In general, parameter values remain in force for repeated use of a
* statement. Setting a parameter value automatically clears its previous
* value. However, in some cases it is useful to immediately release the
* resources used by the current parameter values; this can be done by
* calling the method clearParameters.
*
* @exception SQLException
* if a database access error occurs
*/
public void clearParameters() throws SQLException {
if (isParamSet == null) return;
for (int i = 0; i < isParamSet.length; i++)
isParamSet[i] = false;
XSQLVAR[] xsqlvar = fixedStmt.getInSqlda().sqlvar;
for (int i = 0; i < xsqlvar.length; i++) {
xsqlvar[i].sqldata = null;
}
}
// ----------------------------------------------------------------------
// Advanced features:
/**
*
* Sets the value of the designated parameter with the given object. The
* second argument must be an object type; for integral values, the
* java.lang equivalent objects should be used.
*
*
* The given Java object will be converted to the given targetSqlType before
* being sent to the database.
*
* If the object has a custom mapping (is of a class implementing the
* interface SQLData), the JDBC driver should call the
* method SQLData.writeSQL to write it to the SQL data
* stream. If, on the other hand, the object is of a class implementing Ref,
* Blob, Clob, Struct, or Array, the driver should pass it to the database
* as a value of the corresponding SQL type.
*
*
* Note that this method may be used to pass datatabase- specific abstract
* data types.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the object containing the input parameter value
* @param targetSqlType
* the SQL type (as defined in java.sql.Types) to be sent to the
* database. The scale argument may further qualify this type.
* @param scale
* for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types,
* this is the number of digits after the decimal point. For all
* other types, this value will be ignored.
* @exception SQLException
* if a database access error occurs
* @see Types
*/
public void setObject(int parameterIndex, Object x, int targetSqlType,
int scale) throws SQLException {
// Workaround for JBuilder DataSets
setObject(parameterIndex, x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the value of the designated parameter with the given object. This
* method is like the method setObject above, except that it
* assumes a scale of zero.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the object containing the input parameter value
* @param targetSqlType
* the SQL type (as defined in java.sql.Types) to be sent to the
* database
* @exception SQLException
* if a database access error occurs
*/
public void setObject(int parameterIndex, Object x, int targetSqlType)
throws SQLException {
// well, for now
setObject(parameterIndex, x);
isParamSet[parameterIndex - 1] = true;
}
/**
* Executes any kind of SQL statement. Some prepared statements return
* multiple results; the execute method handles these complex
* statements as well as the simpler form of statements handled by the
* methods executeQuery and executeUpdate.
*
* @exception SQLException
* if a database access error occurs
* @see Statement#execute
*/
public boolean execute() throws SQLException {
Object syncObject = getSynchronizationObject();
synchronized (syncObject) {
notifyStatementStarted();
boolean hasResultSet = internalExecute(isExecuteProcedureStatement);
if (!hasResultSet)
notifyStatementCompleted();
return hasResultSet;
}
}
/**
* Execute meta-data query. This method is similar to
* {@link #executeQuery()}however, it always returns cached result set and
* strings in the result set are always trimmed (server defines system
* tables using CHAR data type, but it should be used as VARCHAR).
*
* @return result set corresponding to the specified query.
*
* @throws SQLException
* if something went wrong or no result set was available.
*/
ResultSet executeMetaDataQuery() throws SQLException {
Object syncObject = getSynchronizationObject();
synchronized (syncObject) {
notifyStatementStarted();
boolean hasResultSet = internalExecute(isExecuteProcedureStatement);
if (!hasResultSet)
throw new FBSQLException("No result set is available.");
return getResultSet(true);
}
}
/**
* Execute this statement. Method checks whether all parameters are set,
* flushes all "flushable" fields that might contain cached data and
* executes the statement.
*
* @param sendOutParams
* @return true if the statement has more result sets.
* @throws SQLException
*/
protected boolean internalExecute(boolean sendOutParams)
throws SQLException {
boolean canExecute = true;
for (int i = 0; i < isParamSet.length; i++) {
canExecute = canExecute && isParamSet[i];
}
if (!canExecute)
throw new FBMissingParameterException(
"Not all parameters were set.", isParamSet);
Object syncObject = getSynchronizationObject();
synchronized (syncObject) {
flushFields();
try {
gdsHelper.executeStatement(fixedStmt, sendOutParams);
isResultSet = (fixedStmt.getOutSqlda().sqld > 0);
return (fixedStmt.getOutSqlda().sqld > 0);
} catch (GDSException ge) {
throw new FBSQLException(ge);
} finally {
hasMoreResults = true;
}
}
}
/**
* Flush fields that might have cached data.
*
* @throws SQLException if something went wrong.
*/
private void flushFields() throws SQLException {
// flush any cached data that can be hanging
for (int i = 0; i < isParamSet.length; i++) {
FBField field = getField(i + 1);
if (!(field instanceof FBFlushableField)) continue;
((FBFlushableField) field).flushCachedData();
}
}
protected final List batchList = new LinkedList();
/**
* Adds a set of parameters to this PreparedStatement
* object's batch of commands.
*
* @exception SQLException
* if a database access error occurs
* @see Statement#addBatch
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void addBatch() throws SQLException {
boolean allParamsSet = true;
for (int i = 0; i < isParamSet.length; i++) {
allParamsSet &= isParamSet[i];
}
if (!allParamsSet) throw new FBSQLException("Not all parameters set.");
XSQLVAR[] oldXsqlvar = fixedStmt.getInSqlda().sqlvar;
XSQLVAR[] newXsqlvar = new XSQLVAR[oldXsqlvar.length];
for (int i = 0; i < newXsqlvar.length; i++) {
newXsqlvar[i] = oldXsqlvar[i].deepCopy();
FBField field = getField(i + 1);
if (field instanceof FBFlushableField)
newXsqlvar[i].cachedobject = ((FBFlushableField)field).getCachedObject();
}
batchList.add(newXsqlvar);
}
/**
* Makes the set of commands in the current batch empty. This method is
* optional.
*
* @exception SQLException
* if a database access error occurs or the driver does not
* support batch statements
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void clearBatch() throws SQLException {
batchList.clear();
}
/**
* Submits a batch of commands to the database for execution and if all
* commands execute successfully, returns an array of update counts. The
* int elements of the array that is returned are ordered to
* correspond to the commands in the batch, which are ordered according to
* the order in which they were added to the batch. The elements in the
* array returned by the method executeBatch may be one of
* the following:
*
* - A number greater than or equal to zero -- indicates that the command
* was processed successfully and is an update count giving the number of
* rows in the database that were affected by the command's execution
*
- A value of
-2-- indicates that the command was
* processed successfully but that the number of rows affected is unknown
*
* If one of the commands in a batch update fails to execute properly, this
* method throws a BatchUpdateException, and a JDBC driver
* may or may not continue to process the remaining commands in the batch.
* However, the driver's behavior must be consistent with a particular DBMS,
* either always continuing to process commands or never continuing to
* process commands. If the driver continues processing after a failure, the
* array returned by the method
* BatchUpdateException.getUpdateCounts will contain as many
* elements as there are commands in the batch, and at least one of the
* elements will be the following:
*
*
- A value of
-3-- indicates that the command failed to
* execute successfully and occurs only if a driver continues to process
* commands after a command fails
*
*
* A driver is not required to implement this method. The possible
* implementations and return values have been modified in the Java 2 SDK,
* Standard Edition, version 1.3 to accommodate the option of continuing to
* proccess commands in a batch update after a
* BatchUpdateException obejct has been thrown.
*
* @return an array of update counts containing one element for each command
* in the batch. The elements of the array are ordered according to
* the order in which commands were added to the batch.
* @exception SQLException
* if a database access error occurs or the driver does not
* support batch statements. Throws
* {@link java.sql.BatchUpdateException}(a subclass of
* SQLException) if one of the commands sent
* to the database fails to execute properly or attempts to
* return a result set.
* @since 1.3
* @see What Is in the JDBC 2.0 API
*
*/
public int[] executeBatch() throws SQLException {
Object syncObject = getSynchronizationObject();
synchronized (syncObject) {
boolean commit = false;
try {
notifyStatementStarted();
ArrayList results = new ArrayList(batchList.size());
Iterator iter = batchList.iterator();
try {
while (iter.hasNext()) {
XSQLVAR[] data = (XSQLVAR[]) iter.next();
XSQLVAR[] vars = fixedStmt.getInSqlda().sqlvar;
for (int i = 0; i < vars.length; i++) {
FBField field = getField(i + 1);
if (field instanceof FBFlushableField) {
vars[i].copyFrom(data[i], false);
((FBFlushableField)field).setCachedObject((CachedObject)data[i].cachedobject);
} else {
vars[i].copyFrom(data[i], true);
}
isParamSet[i] = true;
}
try {
if (internalExecute(isExecuteProcedureStatement))
throw new BatchUpdateException(toArray(results));
int updateCount = getUpdateCount();
results.add(new Integer(updateCount));
} catch (SQLException ex) {
throw new BatchUpdateException(ex.getMessage(), ex
.getSQLState(), ex.getErrorCode(),
toArray(results));
}
}
commit = true;
return toArray(results);
} finally {
clearBatch();
}
} finally {
notifyStatementCompleted(commit);
}
}
}
/**
* Sets the designated parameter to the given Reader object,
* which is the given number of characters long. When a very large UNICODE
* value is input to a LONGVARCHAR parameter, it may be more
* practical to send it via a java.io.Reader object. The data
* will be read from the stream as needed until end-of-file is reached. The
* JDBC driver will do any necessary conversion from UNICODE to the database
* char format.
*
*
* Note: This stream object can either be a standard Java stream
* object or your own subclass that implements the standard interface.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param reader
* the java reader which contains the UNICODE data
* @param length
* the number of characters in the stream
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setCharacterStream(int parameterIndex, Reader reader, int length)
throws SQLException {
getField(parameterIndex).setCharacterStream(reader, length);
isParamSet[parameterIndex - 1] = true;
}
public void setCharacterStream(int parameterIndex, Reader reader,
long length) throws SQLException {
if (length > Integer.MAX_VALUE)
throw new FBDriverNotCapableException("Only length <= Integer.MAX_VALUE supported");
setCharacterStream(parameterIndex, reader, (int)length);
}
public void setCharacterStream(int parameterIndex, Reader reader)
throws SQLException {
throw new FBDriverNotCapableException();
}
/**
* Sets the designated parameter to the given
* REF(<structured-type>) value.
*
* @param i
* the first parameter is 1, the second is 2, ...
* @param x
* an SQL REF value
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setRef(int i, Ref x) throws SQLException {
throw new FBDriverNotCapableException();
}
/**
* Sets the designated parameter to the given Blob object.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param blob
* a Blob object that maps an SQL
* BLOB value
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setBlob(int parameterIndex, Blob blob) throws SQLException {
// if the passed BLOB is not instance of our class, copy its content
// into the our BLOB
if (!(blob instanceof FBBlob)) {
FBBlob fbb = new FBBlob(gdsHelper, blobListener);
fbb.copyStream(blob.getBinaryStream());
blob = fbb;
}
getField(parameterIndex).setBlob((FBBlob) blob);
isParamSet[parameterIndex - 1] = true;
}
public void setBlob(int parameterIndex, InputStream inputStream, long length)
throws SQLException {
throw new FBDriverNotCapableException();
}
public void setBlob(int parameterIndex, InputStream inputStream)
throws SQLException {
FBBlob blob = new FBBlob(gdsHelper, blobListener);
blob.copyStream(inputStream);
setBlob(parameterIndex, blob);
}
/**
* Sets the designated parameter to the given Clob object.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param clob
* a Clob object that maps an SQL
* CLOB value
* @exception SQLException
* if a database access error occurs
* @since 1.2
*/
public void setClob(int parameterIndex, Clob clob) throws SQLException {
// if the passed BLOB is not instance of our class, copy its content
// into the our BLOB
if (!(clob instanceof FBClob)) {
FBClob fbc = new FBClob(new FBBlob(gdsHelper, blobListener));
fbc.copyCharacterStream(clob.getCharacterStream());
clob = fbc;
}
getField(parameterIndex).setClob((FBClob) clob);
isParamSet[parameterIndex - 1] = true;
}
public void setClob(int parameterIndex, Reader reader, long length)
throws SQLException {
throw new FBDriverNotCapableException();
}
public void setClob(int parameterIndex, Reader reader) throws SQLException {
FBClob clob = new FBClob(new FBBlob(gdsHelper, blobListener));
clob.copyCharacterStream(reader);
setClob(parameterIndex, clob);
}
/**
* Sets the designated parameter to the given Array object.
* Sets an Array parameter.
*
* @param i
* the first parameter is 1, the second is 2, ...
* @param x
* an Array object that maps an SQL
* ARRAY value
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setArray(int i, Array x) throws SQLException {
throw new FBDriverNotCapableException();
}
/**
* Gets the number, types and properties of a ResultSet
* object's columns.
*
* @return the description of a ResultSet object's columns
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public ResultSetMetaData getMetaData() throws SQLException {
return new FBResultSetMetaData(fixedStmt.getOutSqlda().sqlvar,
gdsHelper);
}
/**
* Sets the designated parameter to the given java.sql.Date
* value, using the given Calendar object. The driver uses
* the Calendar object to construct an SQL DATE
* value, which the driver then sends to the database. With a a
* Calendar object, the driver can calculate the date taking
* into account a custom timezone. If no Calendar object is
* specified, the driver uses the default timezone, which is that of the
* virtual machine running the application.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the parameter value
* @param cal
* the Calendar object the driver will use to
* construct the date
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setDate(int parameterIndex, Date x, Calendar cal)
throws SQLException {
getField(parameterIndex).setDate(x, cal);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given java.sql.Time
* value, using the given Calendar object. The driver uses
* the Calendar object to construct an SQL TIME
* value, which the driver then sends to the database. With a a
* Calendar object, the driver can calculate the time taking
* into account a custom timezone. If no Calendar object is
* specified, the driver uses the default timezone, which is that of the
* virtual machine running the application.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the parameter value
* @param cal
* the Calendar object the driver will use to
* construct the time
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setTime(int parameterIndex, Time x, Calendar cal)
throws SQLException {
getField(parameterIndex).setTime(x, cal);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to the given
* java.sql.Timestamp value, using the given
* Calendar object. The driver uses the Calendar
* object to construct an SQL TIMESTAMP value, which the
* driver then sends to the database. With a a Calendar
* object, the driver can calculate the timestamp taking into account a
* custom timezone. If no Calendar object is specified, the
* driver uses the default timezone, which is that of the virtual machine
* running the application.
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param x
* the parameter value
* @param cal
* the Calendar object the driver will use to
* construct the timestamp
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
throws SQLException {
getField(parameterIndex).setTimestamp(x, cal);
isParamSet[parameterIndex - 1] = true;
}
/**
* Sets the designated parameter to SQL NULL. This version
* of the method setNull should be used for user-defined
* types and REF type parameters. Examples of user-defined types include:
* STRUCT, DISTINCT, JAVA_OBJECT, and named array types.
*
*
* Note: To be portable, applications must give the SQL type code
* and the fully-qualified SQL type name when specifying a NULL user-defined
* or REF parameter. In the case of a user-defined type the name is the type
* name of the parameter itself. For a REF parameter, the name is the type
* name of the referenced type. If a JDBC driver does not need the type code
* or type name information, it may ignore it.
*
* Although it is intended for user-defined and Ref parameters, this method
* may be used to set a null parameter of any JDBC type. If the parameter
* does not have a user-defined or REF type, the given typeName is ignored.
*
*
* @param parameterIndex
* the first parameter is 1, the second is 2, ...
* @param sqlType
* a value from java.sql.Types
* @param typeName
* the fully-qualified name of an SQL user-defined type; ignored
* if the parameter is not a user-defined type or REF
* @exception SQLException
* if a database access error occurs
* @since 1.2
* @see What Is in the JDBC 2.0 API
*
*/
public void setNull(int parameterIndex, int sqlType, String typeName)
throws SQLException {
// all nulls are represented the same irrespective of type
setNull(parameterIndex, sqlType);
}
/**
* Prepare fixed statement and initialize parameters.
*/
protected void prepareFixedStatement(String sql, boolean describeBind)
throws GDSException, SQLException {
super.prepareFixedStatement(sql, describeBind);
XSQLDA inSqlda = fixedStmt.getInSqlda();
if (!describeBind && inSqlda == null) {
inSqlda = new XSQLDA();
inSqlda.sqln = 0;
inSqlda.sqlvar = new XSQLVAR[0];
}
// initialize isParamSet member
isParamSet = new boolean[inSqlda.sqln];
fields = new FBField[inSqlda.sqln];
for (int i = 0; i < isParamSet.length; i++) {
final int fieldPos = i;
FieldDataProvider dataProvider = new FieldDataProvider() {
public byte[] getFieldData() {
return getXsqlvar(fieldPos + 1).sqldata;
}
public void setFieldData(byte[] data) {
getXsqlvar(fieldPos + 1).sqldata = data;
}
};
// FIXME check if we can safely pass cached here
fields[i] = FBField.createField(getXsqlvar(i + 1), dataProvider,
gdsHelper, false);
if (fields[i] instanceof FBWorkaroundStringField)
((FBWorkaroundStringField) fields[i])
.setTrimString(trimStrings);
}
this.isExecuteProcedureStatement = fixedStmt.getStatementType() == FirebirdPreparedStatement.TYPE_EXEC_PROCEDURE;
}
/**
* Get the execution plan of this PreparedStatement
*
* @return The execution plan of the statement
*/
public String getExecutionPlan() throws FBSQLException {
return super.getExecutionPlan();
}
/**
* Get the statement type of this PreparedStatement.
* The returned value will be one of the TYPE_* constant
* values.
*
* @return The identifier for the given statement's type
*/
public int getStatementType() throws FBSQLException {
return super.getStatementType();
}
public ParameterMetaData getParameterMetaData() throws SQLException {
return new FBParameterMetaData(fixedStmt.getInSqlda().sqlvar, gdsHelper);
}
// Methods not allowed to be used on PreparedStatement and CallableStatement
@Override
public ResultSet executeQuery(String sql) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public int executeUpdate(String sql) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public boolean execute(String sql) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public void addBatch(String sql) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public int executeUpdate(String sql, int[] columnIndex) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public int executeUpdate(String sql, String[] columnNames) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public boolean execute(String sql, int[] columnIndexes) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
@Override
public boolean execute(String sql, String[] columnNames) throws SQLException {
throw new FBSQLException(METHOD_NOT_SUPPORTED);
}
}