All Downloads are FREE. Search and download functionalities are using the official Maven repository.

net.snowflake.client.jdbc.SnowflakeCallableStatementV1 Maven / Gradle / Ivy

There is a newer version: 3.18.0
Show newest version
package net.snowflake.client.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.RowId;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.sql.SQLXML;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Calendar;
import java.util.Map;

final class SnowflakeCallableStatementV1 extends SnowflakePreparedStatementV1
    implements CallableStatement, SnowflakeCallableStatement
{

  /**
   * Construct SnowflakePreparedStatementV1
   *
   * @param connection           connection object
   * @param sql                  sql
   * @param skipParsing          true if the applications want to skip parsing
   *                             to get metadata. false by default.
   * @param resultSetType        result set type: ResultSet.TYPE_FORWARD_ONLY.
   * @param resultSetConcurrency result set conconcurrency: ResultSet.CONCUR_READ_ONLY.
   * @param resultSetHoldability result set holdability: ResultSet.CLOSE_CURSORS_AT_COMMIT
   * @throws SQLException if any SQL error occurs.
   */
  SnowflakeCallableStatementV1(SnowflakeConnectionV1 connection, String sql, boolean skipParsing, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
  {
    super(connection, sql, skipParsing, resultSetType, resultSetConcurrency, resultSetHoldability);
  }

  /*
    The Snowflake database does not accept OUT or INOUT parameters, so the registerOutParameter functions and the get
     functions (which get values of OUT parameters) will remain not implemented)
   */

  @Override
  public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void registerOutParameter(String parameterName, int sqlType) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public boolean wasNull() throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public String getString(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public String getString(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public boolean getBoolean(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public boolean getBoolean(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public byte getByte(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public byte getByte(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public short getShort(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public short getShort(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public int getInt(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public int getInt(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public long getLong(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public long getLong(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public float getFloat(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public float getFloat(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public double getDouble(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public double getDouble(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  @Deprecated
  public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  @Deprecated
  public BigDecimal getBigDecimal(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  @Deprecated
  public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public byte[] getBytes(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public byte[] getBytes(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Date getDate(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Date getDate(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Time getTime(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Time getTime(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Time getTime(String parameterName, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Timestamp getTimestamp(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Timestamp getTimestamp(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Object getObject(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Object getObject(int parameterIndex, Map> map) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Object getObject(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Object getObject(String parameterName, Map> map) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Ref getRef(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Ref getRef(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Blob getBlob(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Blob getBlob(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Clob getClob(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Clob getClob(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Array getArray(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Array getArray(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Date getDate(int parameterIndex, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Date getDate(String parameterName, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Time getTime(int parameterIndex, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public URL getURL(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public URL getURL(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public RowId getRowId(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public RowId getRowId(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public SQLXML getSQLXML(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public SQLXML getSQLXML(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public String getNString(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public String getNString(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Reader getNCharacterStream(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Reader getNCharacterStream(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Reader getCharacterStream(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public Reader getCharacterStream(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  /*
    JDBC is not currently set up to store the parameter names, just the parameter index. Callable Statement can set
    parameters using the functions in PreparedStatement based on parameter index.
   */

  @Override
  public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setRowId(String parameterName, RowId x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNString(String parameterName, String value) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNCharacterStream(String parameterName, Reader value) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNClob(String parameterName, NClob value) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setClob(String parameterName, Reader reader, long length)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setClob(String parameterName, Reader reader)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setClob(String parameterName, Clob x)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBlob(String parameterName, InputStream inputStream, long length)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBlob(String parameterName, InputStream inputStream)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNClob(String parameterName, Reader reader) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public  T getObject(int parameterIndex, Class type) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public  T getObject(String parameterName, Class type) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBlob(String parameterName, Blob x)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNClob(String parameterName, Reader reader, long length) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public NClob getNClob(int parameterIndex) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public NClob getNClob(String parameterName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setURL(String parameterName, URL val) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNull(String parameterName, int sqlType) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBoolean(String parameterName, boolean x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setByte(String parameterName, byte x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setShort(String parameterName, short x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setInt(String parameterName, int x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setLong(String parameterName, long x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setFloat(String parameterName, float x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setDouble(String parameterName, double x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setString(String parameterName, String x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBytes(String parameterName, byte[] x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setDate(String parameterName, Date x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setTime(String parameterName, Time x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setTimestamp(String parameterName, Timestamp x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setAsciiStream(String parameterName, InputStream x)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setAsciiStream(String parameterName, InputStream x, int length)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setAsciiStream(String parameterName, InputStream x, long length)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBinaryStream(String parameterName, InputStream x)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBinaryStream(String parameterName, InputStream x, int length)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setBinaryStream(String parameterName, InputStream x, long length)
  throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setObject(String parameterName, Object x) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setCharacterStream(String parameterName, Reader reader) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setDate(String parameterName, Date x, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setTime(String parameterName, Time x, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

  @Override
  public void setNull(String parameterName, int sqlType, String typeName) throws SQLException
  {
    throw new SQLFeatureNotSupportedException();
  }

}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy