Class CallableStatement

java.lang.Object
All Implemented Interfaces:
JdbcPreparedStatement, JdbcStatement, Query, java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

public class CallableStatement
extends ClientPreparedStatement
implements java.sql.CallableStatement
Representation of stored procedures for JDBC
  • Field Details

  • Constructor Details

    • CallableStatement

      public CallableStatement​(JdbcConnection conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLException
      Creates a new CallableStatement
      Parameters:
      conn - the connection creating this statement
      paramInfo - the SQL to prepare
      Throws:
      java.sql.SQLException - if an error occurs
    • CallableStatement

      public CallableStatement​(JdbcConnection conn, java.lang.String sql, java.lang.String db, boolean isFunctionCall) throws java.sql.SQLException
      Creates a new CallableStatement
      Parameters:
      conn - the connection creating this statement
      sql - the SQL to prepare
      db - the current database
      isFunctionCall - is it a function call or a procedure call?
      Throws:
      java.sql.SQLException - if an error occurs
  • Method Details

    • getInstance

      protected static CallableStatement getInstance​(JdbcConnection conn, java.lang.String sql, java.lang.String db, boolean isFunctionCall) throws java.sql.SQLException
      Creates a callable statement instance
      Parameters:
      conn - the connection creating this statement
      sql - the SQL to prepare
      db - the current database
      isFunctionCall - is it a function call or a procedure call?
      Returns:
      CallableStatement
      Throws:
      java.sql.SQLException - if an error occurs
    • getInstance

      protected static CallableStatement getInstance​(JdbcConnection conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLException
      Creates a callable statement instance
      Parameters:
      conn - the connection creating this statement
      paramInfo - the SQL to prepare
      Returns:
      CallableStatement
      Throws:
      java.sql.SQLException - if an error occurs
    • addBatch

      public void addBatch() throws java.sql.SQLException
      Specified by:
      addBatch in interface java.sql.PreparedStatement
      Overrides:
      addBatch in class ClientPreparedStatement
      Throws:
      java.sql.SQLException
    • clearParameters

      public void clearParameters() throws java.sql.SQLException
      Specified by:
      clearParameters in interface java.sql.PreparedStatement
      Overrides:
      clearParameters in class ClientPreparedStatement
      Throws:
      java.sql.SQLException
    • execute

      public boolean execute() throws java.sql.SQLException
      Specified by:
      execute in interface java.sql.PreparedStatement
      Overrides:
      execute in class ClientPreparedStatement
      Throws:
      java.sql.SQLException
    • executeQuery

      public java.sql.ResultSet executeQuery() throws java.sql.SQLException
      Specified by:
      executeQuery in interface java.sql.PreparedStatement
      Overrides:
      executeQuery in class ClientPreparedStatement
      Throws:
      java.sql.SQLException
    • executeUpdate

      public int executeUpdate() throws java.sql.SQLException
      Specified by:
      executeUpdate in interface java.sql.PreparedStatement
      Overrides:
      executeUpdate in class ClientPreparedStatement
      Throws:
      java.sql.SQLException
    • fixParameterName

      protected java.lang.String fixParameterName​(java.lang.String paramNameIn) throws java.sql.SQLException
      Adds 'at' symbol to beginning of parameter names if needed.
      Parameters:
      paramNameIn - the parameter name to 'fix'
      Returns:
      the parameter name with an 'a' prepended, if needed
      Throws:
      java.sql.SQLException - if the parameter name is null or empty.
    • getArray

      public java.sql.Array getArray​(int i) throws java.sql.SQLException
      Specified by:
      getArray in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getArray

      public java.sql.Array getArray​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getArray in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBigDecimal

      public java.math.BigDecimal getBigDecimal​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getBigDecimal in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBigDecimal

      @Deprecated public java.math.BigDecimal getBigDecimal​(int parameterIndex, int scale) throws java.sql.SQLException
      Deprecated.
      Specified by:
      getBigDecimal in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBigDecimal

      public java.math.BigDecimal getBigDecimal​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getBigDecimal in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBlob

      public java.sql.Blob getBlob​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getBlob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBlob

      public java.sql.Blob getBlob​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getBlob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBoolean

      public boolean getBoolean​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getBoolean in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBoolean

      public boolean getBoolean​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getBoolean in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getByte

      public byte getByte​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getByte in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getByte

      public byte getByte​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getByte in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBytes

      public byte[] getBytes​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getBytes in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getBytes

      public byte[] getBytes​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getBytes in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getClob

      public java.sql.Clob getClob​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getClob

      public java.sql.Clob getClob​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getDate

      public java.sql.Date getDate​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getDate in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getDate

      public java.sql.Date getDate​(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      getDate in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getDate

      public java.sql.Date getDate​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getDate in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getDate

      public java.sql.Date getDate​(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      getDate in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getDouble

      public double getDouble​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getDouble in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getDouble

      public double getDouble​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getDouble in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getFloat

      public float getFloat​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getFloat in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getFloat

      public float getFloat​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getFloat in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getInt

      public int getInt​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getInt in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getInt

      public int getInt​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getInt in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getLong

      public long getLong​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getLong in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getLong

      public long getLong​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getLong in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getNamedParamIndex

      protected int getNamedParamIndex​(java.lang.String paramName, boolean forOut) throws java.sql.SQLException
      Throws:
      java.sql.SQLException
    • getObject

      public java.lang.Object getObject​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getObject

      public java.lang.Object getObject​(int parameterIndex, java.util.Map<java.lang.String,​java.lang.Class<?>> map) throws java.sql.SQLException
      Specified by:
      getObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getObject

      public java.lang.Object getObject​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getObject

      public java.lang.Object getObject​(java.lang.String parameterName, java.util.Map<java.lang.String,​java.lang.Class<?>> map) throws java.sql.SQLException
      Specified by:
      getObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getObject

      public <T> T getObject​(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
      Specified by:
      getObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getObject

      public <T> T getObject​(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
      Specified by:
      getObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getOutputParameters

      protected ResultSetInternalMethods getOutputParameters​(int paramIndex) throws java.sql.SQLException
      Returns the ResultSet that holds the output parameters, or throws an appropriate exception if none exist, or they weren't returned.
      Parameters:
      paramIndex - parameter index
      Returns:
      the ResultSet that holds the output parameters
      Throws:
      java.sql.SQLException - if no output parameters were defined, or if no output parameters were returned.
    • getParameterMetaData

      public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
      Specified by:
      getParameterMetaData in interface java.sql.PreparedStatement
      Overrides:
      getParameterMetaData in class ClientPreparedStatement
      Throws:
      java.sql.SQLException
    • getRef

      public java.sql.Ref getRef​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getRef in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getRef

      public java.sql.Ref getRef​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getRef in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getShort

      public short getShort​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getShort in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getShort

      public short getShort​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getShort in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getString

      public java.lang.String getString​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getString in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getString

      public java.lang.String getString​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getString in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTime

      public java.sql.Time getTime​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getTime in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTime

      public java.sql.Time getTime​(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      getTime in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTime

      public java.sql.Time getTime​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getTime in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTime

      public java.sql.Time getTime​(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      getTime in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTimestamp

      public java.sql.Timestamp getTimestamp​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getTimestamp in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTimestamp

      public java.sql.Timestamp getTimestamp​(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      getTimestamp in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTimestamp

      public java.sql.Timestamp getTimestamp​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getTimestamp in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getTimestamp

      public java.sql.Timestamp getTimestamp​(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      getTimestamp in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getURL

      public java.net.URL getURL​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getURL in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getURL

      public java.net.URL getURL​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getURL in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • mapOutputParameterIndexToRsIndex

      protected int mapOutputParameterIndexToRsIndex​(int paramIndex) throws java.sql.SQLException
      Throws:
      java.sql.SQLException
    • registerOutParameter

      protected void registerOutParameter​(int parameterIndex, MysqlType mysqlType) throws java.sql.SQLException
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(int parameterIndex, int sqlType) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(int parameterIndex, java.sql.SQLType sqlType) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      protected void registerOutParameter​(int parameterIndex, MysqlType mysqlType, int scale) throws java.sql.SQLException
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(int parameterIndex, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      protected void registerOutParameter​(int parameterIndex, MysqlType mysqlType, java.lang.String typeName) throws java.sql.SQLException
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(java.lang.String parameterName, java.sql.SQLType sqlType) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(java.lang.String parameterName, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • registerOutParameter

      public void registerOutParameter​(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
      Specified by:
      registerOutParameter in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setAsciiStream

      public void setAsciiStream​(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
      Specified by:
      setAsciiStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBigDecimal

      public void setBigDecimal​(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
      Specified by:
      setBigDecimal in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBinaryStream

      public void setBinaryStream​(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
      Specified by:
      setBinaryStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBoolean

      public void setBoolean​(java.lang.String parameterName, boolean x) throws java.sql.SQLException
      Specified by:
      setBoolean in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setByte

      public void setByte​(java.lang.String parameterName, byte x) throws java.sql.SQLException
      Specified by:
      setByte in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBytes

      public void setBytes​(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
      Specified by:
      setBytes in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setCharacterStream

      public void setCharacterStream​(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
      Specified by:
      setCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setDate

      public void setDate​(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
      Specified by:
      setDate in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setDate

      public void setDate​(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      setDate in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setDouble

      public void setDouble​(java.lang.String parameterName, double x) throws java.sql.SQLException
      Specified by:
      setDouble in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setFloat

      public void setFloat​(java.lang.String parameterName, float x) throws java.sql.SQLException
      Specified by:
      setFloat in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setInt

      public void setInt​(java.lang.String parameterName, int x) throws java.sql.SQLException
      Specified by:
      setInt in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setLong

      public void setLong​(java.lang.String parameterName, long x) throws java.sql.SQLException
      Specified by:
      setLong in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNull

      public void setNull​(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
      Specified by:
      setNull in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNull

      public void setNull​(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
      Specified by:
      setNull in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setObject

      public void setObject​(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
      Specified by:
      setObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setObject

      public void setObject​(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
      Specified by:
      setObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setObject

      public void setObject​(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
      Specified by:
      setObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setObject

      public void setObject​(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
      Specified by:
      setObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setObject

      public void setObject​(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
      Specified by:
      setObject in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setShort

      public void setShort​(java.lang.String parameterName, short x) throws java.sql.SQLException
      Specified by:
      setShort in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setString

      public void setString​(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
      Specified by:
      setString in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setTime

      public void setTime​(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
      Specified by:
      setTime in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setTime

      public void setTime​(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      setTime in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setTimestamp

      public void setTimestamp​(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
      Specified by:
      setTimestamp in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setTimestamp

      public void setTimestamp​(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
      Specified by:
      setTimestamp in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setURL

      public void setURL​(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
      Specified by:
      setURL in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • wasNull

      public boolean wasNull() throws java.sql.SQLException
      Specified by:
      wasNull in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • executeBatch

      public int[] executeBatch() throws java.sql.SQLException
      Specified by:
      executeBatch in interface java.sql.Statement
      Overrides:
      executeBatch in class StatementImpl
      Throws:
      java.sql.SQLException
    • getParameterIndexOffset

      protected int getParameterIndexOffset()
      Description copied from class: ClientPreparedStatement
      For calling stored functions, this will be -1 as Connector/J does not count the first '?' parameter marker, but JDBC counts it * as 1, otherwise it will return 0
      Overrides:
      getParameterIndexOffset in class ClientPreparedStatement
      Returns:
      offset
    • setAsciiStream

      public void setAsciiStream​(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
      Specified by:
      setAsciiStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setAsciiStream

      public void setAsciiStream​(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
      Specified by:
      setAsciiStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBinaryStream

      public void setBinaryStream​(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
      Specified by:
      setBinaryStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBinaryStream

      public void setBinaryStream​(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
      Specified by:
      setBinaryStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBlob

      public void setBlob​(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
      Specified by:
      setBlob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBlob

      public void setBlob​(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
      Specified by:
      setBlob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setBlob

      public void setBlob​(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
      Specified by:
      setBlob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setCharacterStream

      public void setCharacterStream​(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
      Specified by:
      setCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setCharacterStream

      public void setCharacterStream​(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
      Specified by:
      setCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setClob

      public void setClob​(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
      Specified by:
      setClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setClob

      public void setClob​(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
      Specified by:
      setClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setClob

      public void setClob​(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
      Specified by:
      setClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNCharacterStream

      public void setNCharacterStream​(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
      Specified by:
      setNCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNCharacterStream

      public void setNCharacterStream​(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
      Specified by:
      setNCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • checkReadOnlySafeStatement

      protected boolean checkReadOnlySafeStatement() throws java.sql.SQLException
      Description copied from class: ClientPreparedStatement
      Check to see if the statement is safe for read-only replicas after failover.
      Overrides:
      checkReadOnlySafeStatement in class ClientPreparedStatement
      Returns:
      true if safe for read-only.
      Throws:
      java.sql.SQLException - if a database access error occurs or this method is called on a closed PreparedStatement
    • getRowId

      public java.sql.RowId getRowId​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getRowId in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getRowId

      public java.sql.RowId getRowId​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getRowId in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setRowId

      public void setRowId​(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
      Specified by:
      setRowId in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNString

      public void setNString​(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
      Specified by:
      setNString in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNClob

      public void setNClob​(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
      Specified by:
      setNClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNClob

      public void setNClob​(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
      Specified by:
      setNClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setNClob

      public void setNClob​(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
      Specified by:
      setNClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • setSQLXML

      public void setSQLXML​(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
      Specified by:
      setSQLXML in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getSQLXML

      public java.sql.SQLXML getSQLXML​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getSQLXML in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getSQLXML

      public java.sql.SQLXML getSQLXML​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getSQLXML in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getNString

      public java.lang.String getNString​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getNString in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getNString

      public java.lang.String getNString​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getNString in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getNCharacterStream

      public java.io.Reader getNCharacterStream​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getNCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getNCharacterStream

      public java.io.Reader getNCharacterStream​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getNCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getCharacterStream

      public java.io.Reader getCharacterStream​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getCharacterStream

      public java.io.Reader getCharacterStream​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getCharacterStream in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getNClob

      public java.sql.NClob getNClob​(int parameterIndex) throws java.sql.SQLException
      Specified by:
      getNClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • getNClob

      public java.sql.NClob getNClob​(java.lang.String parameterName) throws java.sql.SQLException
      Specified by:
      getNClob in interface java.sql.CallableStatement
      Throws:
      java.sql.SQLException
    • s2b

      protected byte[] s2b​(java.lang.String s)
      Converts the given string to bytes, using the connection's character encoding.
      Parameters:
      s - string
      Returns:
      bytes
    • executeLargeUpdate

      public long executeLargeUpdate() throws java.sql.SQLException
      Specified by:
      executeLargeUpdate in interface java.sql.PreparedStatement
      Overrides:
      executeLargeUpdate in class ClientPreparedStatement
      Throws:
      java.sql.SQLException
    • executeLargeBatch

      public long[] executeLargeBatch() throws java.sql.SQLException
      Specified by:
      executeLargeBatch in interface java.sql.Statement
      Overrides:
      executeLargeBatch in class StatementImpl
      Throws:
      java.sql.SQLException