Class JtdsCallableStatement

  • All Implemented Interfaces:
    java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

    public class JtdsCallableStatement
    extends JtdsPreparedStatement
    implements java.sql.CallableStatement
    jTDS implementation of the java.sql.CallableStatement interface.

    Implementation note:

    1. This class is a simple subclass of PreparedStatement and mainly adds support for setting parameters.
    2. The class supports named parameters in a similar way to the patch supplied by Tommy Sandstrom to the original jTDS code.
    Version:
    $Id: JtdsCallableStatement.java,v 1.23.2.4 2009-12-30 11:37:21 ickzon Exp $
    Author:
    Mike Hutchinson
    • Field Detail

      • paramWasNull

        protected boolean paramWasNull
        Last parameter retrieved was null.
    • Constructor Detail

      • JtdsCallableStatement

        JtdsCallableStatement​(JtdsConnection connection,
                              java.lang.String sql,
                              int resultSetType,
                              int concurrency)
                       throws java.sql.SQLException
        Construct a CallableStatement object.
        Parameters:
        connection - The connection owning this statement.
        sql - The SQL statement specifying the procedure to call.
        resultSetType - The result set type eg FORWARD_ONLY.
        concurrency - The result set concurrency eg READ_ONLY.
        Throws:
        java.sql.SQLException
    • Method Detail

      • findParameter

        final int findParameter​(java.lang.String name,
                                boolean set)
                         throws java.sql.SQLException
        Find a parameter by name.
        Parameters:
        name - The name of the parameter to locate.
        set - True if function is called from a set / register method.
        Returns:
        The parameter index as an int.
        Throws:
        java.sql.SQLException
      • getOutputValue

        protected java.lang.Object getOutputValue​(int parameterIndex)
                                           throws java.sql.SQLException
        Retrieve the value of an output parameter.
        Parameters:
        parameterIndex - the ordinal position of the parameter
        Returns:
        the parameter value as an Object
        Throws:
        java.sql.SQLException - if the parameter has not been set
      • checkOpen

        protected void checkOpen()
                          throws java.sql.SQLException
        Check that this statement is still open.
        Overrides:
        checkOpen in class JtdsPreparedStatement
        Throws:
        java.sql.SQLException - if statement closed.
      • executeMSBatch

        protected java.sql.SQLException executeMSBatch​(int size,
                                                       int executeSize,
                                                       java.util.ArrayList counts)
                                                throws java.sql.SQLException
        Execute the SQL batch on a MS server.
        Overrides:
        executeMSBatch in class JtdsPreparedStatement
        Parameters:
        size - the total size of the batch.
        executeSize - the maximum number of statements to send in one request.
        counts - the returned update counts.
        Returns:
        Chained exceptions linked to a SQLException.
        Throws:
        java.sql.SQLException
      • executeSybaseBatch

        protected java.sql.SQLException executeSybaseBatch​(int size,
                                                           int executeSize,
                                                           java.util.ArrayList counts)
                                                    throws java.sql.SQLException
        Execute the SQL batch on a Sybase server.

        For the rare case of CallableStatement batches each statement is executed individually. This ensures that problems with the server reading into the middle of a statement are avoided. See bug report [1374518] for more details.

        Overrides:
        executeSybaseBatch in class JtdsPreparedStatement
        Parameters:
        size - the total size of the batch
        executeSize - the maximum number of statements to send in one request (ignored for this version of the method as only one statement will be sent at a time)
        counts - the returned update counts
        Returns:
        chained exceptions linked to a SQLException
        Throws:
        java.sql.SQLException - if a serious error occurs during execution
      • wasNull

        public boolean wasNull()
                        throws java.sql.SQLException
        Specified by:
        wasNull 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
      • getDouble

        public double getDouble​(int parameterIndex)
                         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
      • getInt

        public int getInt​(int parameterIndex)
                   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
      • getShort

        public short getShort​(int parameterIndex)
                       throws java.sql.SQLException
        Specified by:
        getShort 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
      • getBytes

        public byte[] getBytes​(int parameterIndex)
                        throws java.sql.SQLException
        Specified by:
        getBytes in interface java.sql.CallableStatement
        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,
                                         int sqlType,
                                         int scale)
                                  throws java.sql.SQLException
        Specified by:
        registerOutParameter in interface java.sql.CallableStatement
        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
      • getString

        public java.lang.String getString​(int parameterIndex)
                                   throws java.sql.SQLException
        Specified by:
        getString in interface java.sql.CallableStatement
        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
      • getByte

        public byte getByte​(java.lang.String parameterName)
                     throws java.sql.SQLException
        Specified by:
        getByte 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​(java.lang.String parameterName)
                       throws java.sql.SQLException
        Specified by:
        getFloat 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​(java.lang.String parameterName)
                     throws java.sql.SQLException
        Specified by:
        getLong 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
      • getBoolean

        public boolean getBoolean​(java.lang.String parameterName)
                           throws java.sql.SQLException
        Specified by:
        getBoolean 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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

        public java.math.BigDecimal getBigDecimal​(int parameterIndex,
                                                  int scale)
                                           throws java.sql.SQLException
        Specified by:
        getBigDecimal 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
      • getArray

        public java.sql.Array getArray​(int parameterIndex)
                                throws java.sql.SQLException
        Specified by:
        getArray 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
      • getClob

        public java.sql.Clob getClob​(int parameterIndex)
                              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
      • getRef

        public java.sql.Ref getRef​(int parameterIndex)
                            throws java.sql.SQLException
        Specified by:
        getRef 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
      • getTimestamp

        public java.sql.Timestamp getTimestamp​(int parameterIndex)
                                        throws java.sql.SQLException
        Specified by:
        getTimestamp 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
      • 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
      • 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
      • 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
      • 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,
                              int targetSqlType,
                              int scale)
                       throws java.sql.SQLException
        Specified by:
        setObject in interface java.sql.CallableStatement
        Throws:
        java.sql.SQLException
      • getObject

        public java.lang.Object getObject​(int parameterIndex,
                                          java.util.Map map)
                                   throws java.sql.SQLException
        Specified by:
        getObject 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • setURL

        public void setURL​(java.lang.String parameterName,
                           java.net.URL x)
                    throws java.sql.SQLException
        Specified by:
        setURL 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
      • 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
      • 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​(java.lang.String parameterName)
                              throws java.sql.SQLException
        Specified by:
        getDate 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • getObject

        public java.lang.Object getObject​(java.lang.String parameterName,
                                          java.util.Map map)
                                   throws java.sql.SQLException
        Specified by:
        getObject 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
      • 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​(java.lang.String parameterName,
                                               java.util.Calendar cal)
                                        throws java.sql.SQLException
        Specified by:
        getTimestamp 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
      • 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,
                                 java.util.Calendar cal)
                          throws java.sql.SQLException
        Specified by:
        setTimestamp 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • closeOnCompletion

        public void closeOnCompletion()
                               throws java.sql.SQLException
        Specified by:
        closeOnCompletion in interface java.sql.Statement
        Overrides:
        closeOnCompletion in class JtdsStatement
        Throws:
        java.sql.SQLException
      • isCloseOnCompletion

        public boolean isCloseOnCompletion()
                                    throws java.sql.SQLException
        Specified by:
        isCloseOnCompletion in interface java.sql.Statement
        Overrides:
        isCloseOnCompletion in class JtdsStatement
        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