http://www.h2database.com: H2 Database Engine
  • Thomas Mueller 
/*
 * Copyright 2004-2019 H2 Group. Multiple-Licensed under the MPL 2.0,
 * and the EPL 1.0 (http://h2database.com/html/license.html).
 * Initial Developer: H2 Group
 */
package org.h2.jdbc;

import java.io.InputStream;
import java.io.Reader;
import java.math.BigDecimal;
import java.net.URL;
import java.sql.Array;
import java.sql.Blob;
import java.sql.CallableStatement;
import java.sql.Clob;
import java.sql.Date;
import java.sql.NClob;
import java.sql.Ref;
import java.sql.ResultSetMetaData;
import java.sql.RowId;
import java.sql.SQLException;
import java.sql.SQLXML;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.BitSet;
import java.util.Calendar;
import java.util.HashMap;
import java.util.Map;
import org.h2.api.ErrorCode;
import org.h2.expression.ParameterInterface;
import org.h2.message.DbException;
import org.h2.message.TraceObject;
import org.h2.value.ValueNull;


Represents a callable statement.

Author:Sergi Vladykin, Thomas Mueller
/**
 * Represents a callable statement.
 *
 * @author Sergi Vladykin
 * @author Thomas Mueller
 */
public class JdbcCallableStatement extends JdbcPreparedStatement implements
        CallableStatement, JdbcCallableStatementBackwardsCompat {

    private BitSet outParameters;
    private int maxOutParameters;
    private HashMap<String, Integer> namedParameters;

    JdbcCallableStatement(JdbcConnection conn, String sql, int id,
            int resultSetType, int resultSetConcurrency) {
        super(conn, sql, id, resultSetType, resultSetConcurrency, false, false);
        setTrace(session.getTrace(), TraceObject.CALLABLE_STATEMENT, id);
    }

    
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
If another result set exists for this statement, this will be closed
(even if this statement fails).
If auto commit is on, this statement will be committed.
If the statement is a DDL statement (create, drop, alter) and does not
throw an exception, the current transaction (if any) is committed after
executing the statement.

Throws:
Returns:the update count (number of row affected by an insert, update or
        delete, or 0 if no rows or the statement was a create, drop,
        commit or rollback)
/**
     * Executes a statement (insert, update, delete, create, drop)
     * and returns the update count.
     * If another result set exists for this statement, this will be closed
     * (even if this statement fails).
     *
     * If auto commit is on, this statement will be committed.
     * If the statement is a DDL statement (create, drop, alter) and does not
     * throw an exception, the current transaction (if any) is committed after
     * executing the statement.
     *
     * @return the update count (number of row affected by an insert, update or
     *         delete, or 0 if no rows or the statement was a create, drop,
     *         commit or rollback)
     * @throws SQLException if this object is closed or invalid
     */
    @Override
    public int executeUpdate() throws SQLException {
        try {
            checkClosed();
            if (command.isQuery()) {
                super.executeQuery();
                return 0;
            }
            return super.executeUpdate();
        } catch (Exception e) {
            throw logAndConvert(e);
        }
    }

    
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
If another result set exists for this statement, this will be closed
(even if this statement fails).
If auto commit is on, this statement will be committed.
If the statement is a DDL statement (create, drop, alter) and does not
throw an exception, the current transaction (if any) is committed after
executing the statement.

Throws:
Returns:the update count (number of row affected by an insert, update or
        delete, or 0 if no rows or the statement was a create, drop,
        commit or rollback)
/**
     * Executes a statement (insert, update, delete, create, drop)
     * and returns the update count.
     * If another result set exists for this statement, this will be closed
     * (even if this statement fails).
     *
     * If auto commit is on, this statement will be committed.
     * If the statement is a DDL statement (create, drop, alter) and does not
     * throw an exception, the current transaction (if any) is committed after
     * executing the statement.
     *
     * @return the update count (number of row affected by an insert, update or
     *         delete, or 0 if no rows or the statement was a create, drop,
     *         commit or rollback)
     * @throws SQLException if this object is closed or invalid
     */
    @Override
    public long executeLargeUpdate() throws SQLException {
        try {
            checkClosed();
            if (command.isQuery()) {
                super.executeQuery();
                return 0;
            }
            return super.executeLargeUpdate();
        } catch (Exception e) {
            throw logAndConvert(e);
        }
    }

    
Registers the given OUT parameter.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • sqlType – the data type (Types.x) - ignored
/**
     * Registers the given OUT parameter.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param sqlType the data type (Types.x) - ignored
     */
    @Override
    public void registerOutParameter(int parameterIndex, int sqlType)
            throws SQLException {
        registerOutParameter(parameterIndex);
    }

    
Registers the given OUT parameter.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • sqlType – the data type (Types.x) - ignored
  • typeName – the SQL type name - ignored
/**
     * Registers the given OUT parameter.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param sqlType the data type (Types.x) - ignored
     * @param typeName the SQL type name - ignored
     */
    @Override
    public void registerOutParameter(int parameterIndex, int sqlType,
            String typeName) throws SQLException {
        registerOutParameter(parameterIndex);
    }

    
Registers the given OUT parameter.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • sqlType – the data type (Types.x)
  • scale – is ignored
/**
     * Registers the given OUT parameter.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param sqlType the data type (Types.x)
     * @param scale is ignored
     */
    @Override
    public void registerOutParameter(int parameterIndex, int sqlType, int scale)
            throws SQLException {
        registerOutParameter(parameterIndex);
    }

    
Registers the given OUT parameter.

Params:
  • parameterName – the parameter name
  • sqlType – the data type (Types.x) - ignored
  • typeName – the SQL type name - ignored
/**
     * Registers the given OUT parameter.
     *
     * @param parameterName the parameter name
     * @param sqlType the data type (Types.x) - ignored
     * @param typeName the SQL type name - ignored
     */
    @Override
    public void registerOutParameter(String parameterName, int sqlType,
            String typeName) throws SQLException {
        registerOutParameter(getIndexForName(parameterName), sqlType, typeName);
    }

    
Registers the given OUT parameter.

Params:
  • parameterName – the parameter name
  • sqlType – the data type (Types.x) - ignored
  • scale – is ignored
/**
     * Registers the given OUT parameter.
     *
     * @param parameterName the parameter name
     * @param sqlType the data type (Types.x) - ignored
     * @param scale is ignored
     */
    @Override
    public void registerOutParameter(String parameterName, int sqlType,
            int scale) throws SQLException {
        registerOutParameter(getIndexForName(parameterName), sqlType, scale);
    }

    
Registers the given OUT parameter.

Params:
  • parameterName – the parameter name
  • sqlType – the data type (Types.x) - ignored
/**
     * Registers the given OUT parameter.
     *
     * @param parameterName the parameter name
     * @param sqlType the data type (Types.x) - ignored
     */
    @Override
    public void registerOutParameter(String parameterName, int sqlType)
            throws SQLException {
        registerOutParameter(getIndexForName(parameterName), sqlType);
    }

    
Returns whether the last column accessed was null.

Returns:true if the last column accessed was null
/**
     * Returns whether the last column accessed was null.
     *
     * @return true if the last column accessed was null
     */
    @Override
    public boolean wasNull() throws SQLException {
        return getOpenResultSet().wasNull();
    }

    
[Not supported]

/**
     * [Not supported]
     */
    @Override
    public URL getURL(int parameterIndex) throws SQLException {
        throw unsupported("url");
    }

    
Returns the value of the specified column as a String.

Params:
  • parameterIndex – (1,2,...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a String.
     *
     * @param parameterIndex (1,2,...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public String getString(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getString(parameterIndex);
    }

    
Returns the value of the specified column as a boolean.

Params:
  • parameterIndex – (1,2,...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a boolean.
     *
     * @param parameterIndex (1,2,...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public boolean getBoolean(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getBoolean(parameterIndex);
    }

    
Returns the value of the specified column as a byte.

Params:
  • parameterIndex – (1,2,...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a byte.
     *
     * @param parameterIndex (1,2,...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public byte getByte(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getByte(parameterIndex);
    }

    
Returns the value of the specified column as a short.

Params:
  • parameterIndex – (1,2,...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a short.
     *
     * @param parameterIndex (1,2,...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public short getShort(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getShort(parameterIndex);
    }

    
Returns the value of the specified column as an int.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as an int.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public int getInt(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getInt(parameterIndex);
    }

    
Returns the value of the specified column as a long.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a long.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public long getLong(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getLong(parameterIndex);
    }

    
Returns the value of the specified column as a float.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a float.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public float getFloat(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getFloat(parameterIndex);
    }

    
Returns the value of the specified column as a double.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a double.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public double getDouble(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getDouble(parameterIndex);
    }

    
Returns the value of the specified column as a BigDecimal.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • scale – is ignored
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Deprecated:use getBigDecimal(int)
Returns:the value
/**
     * Returns the value of the specified column as a BigDecimal.
     *
     * @deprecated use {@link #getBigDecimal(int)}
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param scale is ignored
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Deprecated
    @Override
    public BigDecimal getBigDecimal(int parameterIndex, int scale)
            throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getBigDecimal(parameterIndex, scale);
    }

    
Returns the value of the specified column as a byte array.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a byte array.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public byte[] getBytes(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getBytes(parameterIndex);
    }

    
Returns the value of the specified column as a java.sql.Date.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Date.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Date getDate(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getDate(parameterIndex);
    }

    
Returns the value of the specified column as a java.sql.Time.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Time.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Time getTime(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getTime(parameterIndex);
    }

    
Returns the value of the specified column as a java.sql.Timestamp.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Timestamp.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Timestamp getTimestamp(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getTimestamp(parameterIndex);
    }

    
Returns a column value as a Java object. The data is
de-serialized into a Java object (on the client side).

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value or null
/**
     * Returns a column value as a Java object. The data is
     * de-serialized into a Java object (on the client side).
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value or null
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Object getObject(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getObject(parameterIndex);
    }

    
Returns the value of the specified column as a BigDecimal.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a BigDecimal.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public BigDecimal getBigDecimal(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getBigDecimal(parameterIndex);
    }

    
[Not supported] Gets a column as a object using the specified type
mapping.

/**
     * [Not supported] Gets a column as a object using the specified type
     * mapping.
     */
    @Override
    public Object getObject(int parameterIndex, Map<String, Class<?>> map)
            throws SQLException {
        throw unsupported("map");
    }

    
[Not supported] Gets a column as a reference.

/**
     * [Not supported] Gets a column as a reference.
     */
    @Override
    public Ref getRef(int parameterIndex) throws SQLException {
        throw unsupported("ref");
    }

    
Returns the value of the specified column as a Blob.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a Blob.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Blob getBlob(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getBlob(parameterIndex);
    }

    
Returns the value of the specified column as a Clob.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a Clob.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Clob getClob(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getClob(parameterIndex);
    }

    
Returns the value of the specified column as an Array.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as an Array.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Array getArray(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getArray(parameterIndex);
    }

    
Returns the value of the specified column as a java.sql.Date using a
specified time zone.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • cal – the calendar
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Date using a
     * specified time zone.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param cal the calendar
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Date getDate(int parameterIndex, Calendar cal) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getDate(parameterIndex, cal);
    }

    
Returns the value of the specified column as a java.sql.Time using a
specified time zone.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • cal – the calendar
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Time using a
     * specified time zone.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param cal the calendar
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Time getTime(int parameterIndex, Calendar cal) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getTime(parameterIndex, cal);
    }

    
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • cal – the calendar
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Timestamp using a
     * specified time zone.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param cal the calendar
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Timestamp getTimestamp(int parameterIndex, Calendar cal)
            throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getTimestamp(parameterIndex, cal);
    }

    
[Not supported]

/**
     * [Not supported]
     */
    @Override
    public URL getURL(String parameterName) throws SQLException {
        throw unsupported("url");
    }

    
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.

Params:
  • parameterName – the parameter name
  • cal – the calendar
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Timestamp using a
     * specified time zone.
     *
     * @param parameterName the parameter name
     * @param cal the calendar
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Timestamp getTimestamp(String parameterName, Calendar cal)
            throws SQLException {
        return getTimestamp(getIndexForName(parameterName), cal);
    }

    
Returns the value of the specified column as a java.sql.Time using a
specified time zone.

Params:
  • parameterName – the parameter name
  • cal – the calendar
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Time using a
     * specified time zone.
     *
     * @param parameterName the parameter name
     * @param cal the calendar
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Time getTime(String parameterName, Calendar cal) throws SQLException {
        return getTime(getIndexForName(parameterName), cal);
    }

    
Returns the value of the specified column as a java.sql.Date using a
specified time zone.

Params:
  • parameterName – the parameter name
  • cal – the calendar
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Date using a
     * specified time zone.
     *
     * @param parameterName the parameter name
     * @param cal the calendar
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Date getDate(String parameterName, Calendar cal) throws SQLException {
        return getDate(getIndexForName(parameterName), cal);
    }

    
Returns the value of the specified column as an Array.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as an Array.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Array getArray(String parameterName) throws SQLException {
        return getArray(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a Clob.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a Clob.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Clob getClob(String parameterName) throws SQLException {
        return getClob(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a Blob.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a Blob.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Blob getBlob(String parameterName) throws SQLException {
        return getBlob(getIndexForName(parameterName));
    }

    
[Not supported] Gets a column as a reference.

/**
     * [Not supported] Gets a column as a reference.
     */
    @Override
    public Ref getRef(String parameterName) throws SQLException {
        throw unsupported("ref");
    }

    
[Not supported] Gets a column as a object using the specified type
mapping.

/**
     * [Not supported] Gets a column as a object using the specified type
     * mapping.
     */
    @Override
    public Object getObject(String parameterName, Map<String, Class<?>> map)
            throws SQLException {
        throw unsupported("map");
    }

    
Returns the value of the specified column as a BigDecimal.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a BigDecimal.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public BigDecimal getBigDecimal(String parameterName) throws SQLException {
        return getBigDecimal(getIndexForName(parameterName));
    }

    
Returns a column value as a Java object. The data is
de-serialized into a Java object (on the client side).

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value or null
/**
     * Returns a column value as a Java object. The data is
     * de-serialized into a Java object (on the client side).
     *
     * @param parameterName the parameter name
     * @return the value or null
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Object getObject(String parameterName) throws SQLException {
        return getObject(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a java.sql.Timestamp.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Timestamp.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Timestamp getTimestamp(String parameterName) throws SQLException {
        return getTimestamp(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a java.sql.Time.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Time.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Time getTime(String parameterName) throws SQLException {
        return getTime(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a java.sql.Date.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a java.sql.Date.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Date getDate(String parameterName) throws SQLException {
        return getDate(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a byte array.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a byte array.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public byte[] getBytes(String parameterName) throws SQLException {
        return getBytes(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a double.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a double.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public double getDouble(String parameterName) throws SQLException {
        return getDouble(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a float.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a float.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public float getFloat(String parameterName) throws SQLException {
        return getFloat(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a long.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a long.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public long getLong(String parameterName) throws SQLException {
        return getLong(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as an int.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as an int.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public int getInt(String parameterName) throws SQLException {
        return getInt(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a short.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a short.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public short getShort(String parameterName) throws SQLException {
        return getShort(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a byte.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a byte.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public byte getByte(String parameterName) throws SQLException {
        return getByte(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a boolean.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a boolean.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public boolean getBoolean(String parameterName) throws SQLException {
        return getBoolean(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a String.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a String.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public String getString(String parameterName) throws SQLException {
        return getString(getIndexForName(parameterName));
    }

    
[Not supported] Returns the value of the specified column as a row id.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
/**
     * [Not supported] Returns the value of the specified column as a row id.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     */
    @Override
    public RowId getRowId(int parameterIndex) throws SQLException {
        throw unsupported("rowId");
    }

    
[Not supported] Returns the value of the specified column as a row id.

Params:
  • parameterName – the parameter name
/**
     * [Not supported] Returns the value of the specified column as a row id.
     *
     * @param parameterName the parameter name
     */
    @Override
    public RowId getRowId(String parameterName) throws SQLException {
        throw unsupported("rowId");
    }

    
Returns the value of the specified column as a Clob.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a Clob.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public NClob getNClob(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getNClob(parameterIndex);
    }

    
Returns the value of the specified column as a Clob.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a Clob.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public NClob getNClob(String parameterName) throws SQLException {
        return getNClob(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a SQLXML object.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a SQLXML object.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public SQLXML getSQLXML(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getSQLXML(parameterIndex);
    }

    
Returns the value of the specified column as a SQLXML object.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a SQLXML object.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public SQLXML getSQLXML(String parameterName) throws SQLException {
        return getSQLXML(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a String.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a String.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public String getNString(int parameterIndex) throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getNString(parameterIndex);
    }

    
Returns the value of the specified column as a String.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a String.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public String getNString(String parameterName) throws SQLException {
        return getNString(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a reader.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a reader.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Reader getNCharacterStream(int parameterIndex)
            throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getNCharacterStream(parameterIndex);
    }

    
Returns the value of the specified column as a reader.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a reader.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Reader getNCharacterStream(String parameterName)
            throws SQLException {
        return getNCharacterStream(getIndexForName(parameterName));
    }

    
Returns the value of the specified column as a reader.

Params:
  • parameterIndex – the parameter index (1, 2, ...)
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a reader.
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Reader getCharacterStream(int parameterIndex)
            throws SQLException {
        checkRegistered(parameterIndex);
        return getOpenResultSet().getCharacterStream(parameterIndex);
    }

    
Returns the value of the specified column as a reader.

Params:
  • parameterName – the parameter name
Throws:
  • SQLException – if the column is not found or if this object is
            closed
Returns:the value
/**
     * Returns the value of the specified column as a reader.
     *
     * @param parameterName the parameter name
     * @return the value
     * @throws SQLException if the column is not found or if this object is
     *             closed
     */
    @Override
    public Reader getCharacterStream(String parameterName)
            throws SQLException {
        return getCharacterStream(getIndexForName(parameterName));
    }

    // =============================================================

    
Sets a parameter to null.

Params:
  • parameterName – the parameter name
  • sqlType – the data type (Types.x)
  • typeName – this parameter is ignored
Throws:
/**
     * Sets a parameter to null.
     *
     * @param parameterName the parameter name
     * @param sqlType the data type (Types.x)
     * @param typeName this parameter is ignored
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNull(String parameterName, int sqlType, String typeName)
            throws SQLException {
        setNull(getIndexForName(parameterName), sqlType, typeName);
    }

    
Sets a parameter to null.

Params:
  • parameterName – the parameter name
  • sqlType – the data type (Types.x)
Throws:
/**
     * Sets a parameter to null.
     *
     * @param parameterName the parameter name
     * @param sqlType the data type (Types.x)
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNull(String parameterName, int sqlType) throws SQLException {
        setNull(getIndexForName(parameterName), sqlType);
    }

    
Sets the timestamp using a specified time zone. The value will be
converted to the local time zone.

Params:
  • parameterName – the parameter name
  • x – the value
  • cal – the calendar
Throws:
/**
     * Sets the timestamp using a specified time zone. The value will be
     * converted to the local time zone.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param cal the calendar
     * @throws SQLException if this object is closed
     */
    @Override
    public void setTimestamp(String parameterName, Timestamp x, Calendar cal)
            throws SQLException {
        setTimestamp(getIndexForName(parameterName), x, cal);
    }

    
Sets the time using a specified time zone. The value will be converted to
the local time zone.

Params:
  • parameterName – the parameter name
  • x – the value
  • cal – the calendar
Throws:
/**
     * Sets the time using a specified time zone. The value will be converted to
     * the local time zone.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param cal the calendar
     * @throws SQLException if this object is closed
     */
    @Override
    public void setTime(String parameterName, Time x, Calendar cal)
            throws SQLException {
        setTime(getIndexForName(parameterName), x, cal);
    }

    
Sets the date using a specified time zone. The value will be converted to
the local time zone.

Params:
  • parameterName – the parameter name
  • x – the value
  • cal – the calendar
Throws:
/**
     * Sets the date using a specified time zone. The value will be converted to
     * the local time zone.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param cal the calendar
     * @throws SQLException if this object is closed
     */
    @Override
    public void setDate(String parameterName, Date x, Calendar cal)
            throws SQLException {
        setDate(getIndexForName(parameterName), x, cal);
    }

    
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of characters
Throws:
/**
     * Sets the value of a parameter as a character stream.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of characters
     * @throws SQLException if this object is closed
     */
    @Override
    public void setCharacterStream(String parameterName, Reader x, int length)
            throws SQLException {
        setCharacterStream(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter.
Objects of unknown classes are serialized (on the client side).

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     * Objects of unknown classes are serialized (on the client side).
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setObject(String parameterName, Object x) throws SQLException {
        setObject(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Objects of unknown classes are serialized (on the client side).

Params:
  • parameterName – the parameter name
  • x – the value, null is allowed
  • targetSqlType – the type as defined in java.sql.Types
Throws:
/**
     * Sets the value of a parameter. The object is converted, if required, to
     * the specified data type before sending to the database.
     * Objects of unknown classes are serialized (on the client side).
     *
     * @param parameterName the parameter name
     * @param x the value, null is allowed
     * @param targetSqlType the type as defined in java.sql.Types
     * @throws SQLException if this object is closed
     */
    @Override
    public void setObject(String parameterName, Object x, int targetSqlType)
            throws SQLException {
        setObject(getIndexForName(parameterName), x, targetSqlType);
    }

    
Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Objects of unknown classes are serialized (on the client side).

Params:
  • parameterName – the parameter name
  • x – the value, null is allowed
  • targetSqlType – the type as defined in java.sql.Types
  • scale – is ignored
Throws:
/**
     * Sets the value of a parameter. The object is converted, if required, to
     * the specified data type before sending to the database.
     * Objects of unknown classes are serialized (on the client side).
     *
     * @param parameterName the parameter name
     * @param x the value, null is allowed
     * @param targetSqlType the type as defined in java.sql.Types
     * @param scale is ignored
     * @throws SQLException if this object is closed
     */
    @Override
    public void setObject(String parameterName, Object x, int targetSqlType,
            int scale) throws SQLException {
        setObject(getIndexForName(parameterName), x, targetSqlType, scale);
    }

    
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of bytes
Throws:
/**
     * Sets the value of a parameter as an input stream.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of bytes
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBinaryStream(String parameterName, InputStream x, int length)
            throws SQLException {
        setBinaryStream(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of bytes
Throws:
/**
     * Sets the value of a parameter as an ASCII stream.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of bytes
     * @throws SQLException if this object is closed
     */
    @Override
    public void setAsciiStream(String parameterName,
            InputStream x, long length) throws SQLException {
        setAsciiStream(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setTimestamp(String parameterName, Timestamp x)
            throws SQLException {
        setTimestamp(getIndexForName(parameterName), x);
    }

    
Sets the time using a specified time zone.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the time using a specified time zone.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setTime(String parameterName, Time x) throws SQLException {
        setTime(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setDate(String parameterName, Date x) throws SQLException {
        setDate(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a byte array.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a byte array.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBytes(String parameterName, byte[] x) throws SQLException {
        setBytes(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setString(String parameterName, String x) throws SQLException {
        setString(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBigDecimal(String parameterName, BigDecimal x)
            throws SQLException {
        setBigDecimal(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setDouble(String parameterName, double x) throws SQLException {
        setDouble(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setFloat(String parameterName, float x) throws SQLException {
        setFloat(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setLong(String parameterName, long x) throws SQLException {
        setLong(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setInt(String parameterName, int x) throws SQLException {
        setInt(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setShort(String parameterName, short x) throws SQLException {
        setShort(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setByte(String parameterName, byte x) throws SQLException {
        setByte(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBoolean(String parameterName, boolean x) throws SQLException {
        setBoolean(getIndexForName(parameterName), x);
    }

    
[Not supported]

/**
     * [Not supported]
     */
    @Override
    public void setURL(String parameterName, URL val) throws SQLException {
        throw unsupported("url");
    }

    
[Not supported] Sets the value of a parameter as a row id.

/**
     * [Not supported] Sets the value of a parameter as a row id.
     */
    @Override
    public void setRowId(String parameterName, RowId x)
            throws SQLException {
        throw unsupported("rowId");
    }

    
Sets the value of a parameter.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNString(String parameterName, String x)
            throws SQLException {
        setNString(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of characters
Throws:
/**
     * Sets the value of a parameter as a character stream.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of characters
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNCharacterStream(String parameterName,
            Reader x, long length) throws SQLException {
        setNCharacterStream(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as a Clob.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a Clob.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNClob(String parameterName, NClob x)
            throws SQLException {
        setNClob(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of characters
Throws:
/**
     * Sets the value of a parameter as a Clob.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of characters
     * @throws SQLException if this object is closed
     */
    @Override
    public void setClob(String parameterName, Reader x,
            long length) throws SQLException {
        setClob(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as a Blob.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of bytes
Throws:
/**
     * Sets the value of a parameter as a Blob.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of bytes
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBlob(String parameterName, InputStream x,
            long length) throws SQLException {
        setBlob(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of characters
Throws:
/**
     * Sets the value of a parameter as a Clob.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of characters
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNClob(String parameterName, Reader x,
            long length) throws SQLException {
        setNClob(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as a Blob.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a Blob.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBlob(String parameterName, Blob x)
            throws SQLException {
        setBlob(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a Clob.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a Clob.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setClob(String parameterName, Clob x) throws SQLException {
        setClob(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as an ASCII stream.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setAsciiStream(String parameterName, InputStream x)
            throws SQLException {
        setAsciiStream(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of bytes
Throws:
/**
     * Sets the value of a parameter as an ASCII stream.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of bytes
     * @throws SQLException if this object is closed
     */
    @Override
    public void setAsciiStream(String parameterName,
            InputStream x, int length) throws SQLException {
        setAsciiStream(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as an input stream.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBinaryStream(String parameterName,
            InputStream x) throws SQLException {
        setBinaryStream(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of bytes
Throws:
/**
     * Sets the value of a parameter as an input stream.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of bytes
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBinaryStream(String parameterName,
            InputStream x, long length) throws SQLException {
        setBinaryStream(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as a Blob.
This method does not close the stream.
The stream may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a Blob.
     * This method does not close the stream.
     * The stream may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setBlob(String parameterName, InputStream x)
            throws SQLException {
        setBlob(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a character stream.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setCharacterStream(String parameterName, Reader x)
            throws SQLException {
        setCharacterStream(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
  • length – the maximum number of characters
Throws:
/**
     * Sets the value of a parameter as a character stream.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @param length the maximum number of characters
     * @throws SQLException if this object is closed
     */
    @Override
    public void setCharacterStream(String parameterName,
            Reader x, long length) throws SQLException {
        setCharacterStream(getIndexForName(parameterName), x, length);
    }

    
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a character stream.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setClob(String parameterName, Reader x) throws SQLException {
        setClob(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a character stream.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNCharacterStream(String parameterName, Reader x)
            throws SQLException {
        setNCharacterStream(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a Clob.
     * This method does not close the reader.
     * The reader may be closed after executing the statement.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setNClob(String parameterName, Reader x)
            throws SQLException {
        setNClob(getIndexForName(parameterName), x);
    }

    
Sets the value of a parameter as a SQLXML object.

Params:
  • parameterName – the parameter name
  • x – the value
Throws:
/**
     * Sets the value of a parameter as a SQLXML object.
     *
     * @param parameterName the parameter name
     * @param x the value
     * @throws SQLException if this object is closed
     */
    @Override
    public void setSQLXML(String parameterName, SQLXML x)
            throws SQLException {
        setSQLXML(getIndexForName(parameterName), x);
    }

    
[Not supported]

Params:
  • parameterIndex – the parameter index (1, 2, ...)
  • type – the class of the returned value
/**
     * [Not supported]
     *
     * @param parameterIndex the parameter index (1, 2, ...)
     * @param type the class of the returned value
     */
    @Override
    public <T> T getObject(int parameterIndex, Class<T> type) throws SQLException {
        return getOpenResultSet().getObject(parameterIndex, type);
    }

    
[Not supported]

Params:
  • parameterName – the parameter name
  • type – the class of the returned value
/**
     * [Not supported]
     *
     * @param parameterName the parameter name
     * @param type the class of the returned value
     */
    @Override
    public <T> T getObject(String parameterName, Class<T> type) throws SQLException {
        return getObject(getIndexForName(parameterName), type);
    }

    private ResultSetMetaData getCheckedMetaData() throws SQLException {
        ResultSetMetaData meta = getMetaData();
        if (meta == null) {
            throw DbException.getUnsupportedException(
                    "Supported only for calling stored procedures");
        }
        return meta;
    }

    private void checkIndexBounds(int parameterIndex) {
        checkClosed();
        if (parameterIndex < 1 || parameterIndex > maxOutParameters) {
            throw DbException.getInvalidValueException("parameterIndex", parameterIndex);
        }
    }

    private void registerOutParameter(int parameterIndex) throws SQLException {
        try {
            checkClosed();
            if (outParameters == null) {
                maxOutParameters = Math.min(
                        getParameterMetaData().getParameterCount(),
                        getCheckedMetaData().getColumnCount());
                outParameters = new BitSet();
            }
            checkIndexBounds(parameterIndex);
            ParameterInterface param = command.getParameters().get(--parameterIndex);
            if (!param.isValueSet()) {
                param.setValue(ValueNull.INSTANCE, false);
            }
            outParameters.set(parameterIndex);
        } catch (Exception e) {
            throw logAndConvert(e);
        }
    }

    private void checkRegistered(int parameterIndex) throws SQLException {
        try {
            checkIndexBounds(parameterIndex);
            if (!outParameters.get(parameterIndex - 1)) {
                throw DbException.getInvalidValueException("parameterIndex", parameterIndex);
            }
        } catch (Exception e) {
            throw logAndConvert(e);
        }
    }

    private int getIndexForName(String parameterName) throws SQLException {
        try {
            checkClosed();
            if (namedParameters == null) {
                ResultSetMetaData meta = getCheckedMetaData();
                int columnCount = meta.getColumnCount();
                HashMap<String, Integer> map = new HashMap<>();
                for (int i = 1; i <= columnCount; i++) {
                    map.put(meta.getColumnLabel(i), i);
                }
                namedParameters = map;
            }
            Integer index = namedParameters.get(parameterName);
            if (index == null) {
                throw DbException.getInvalidValueException("parameterName", parameterName);
            }
            return index;
        } catch (Exception e) {
            throw logAndConvert(e);
        }
    }

    private JdbcResultSet getOpenResultSet() throws SQLException {
        try {
            checkClosed();
            if (resultSet == null) {
                throw DbException.get(ErrorCode.NO_DATA_AVAILABLE);
            }
            if (resultSet.isBeforeFirst()) {
                resultSet.next();
            }
            return resultSet;
        } catch (Exception e) {
            throw logAndConvert(e);
        }
    }

}