Class PgCallableStatement

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

    class PgCallableStatement
    extends PgPreparedStatement
    implements java.sql.CallableStatement
    • Field Detail

      • isFunction

        private boolean isFunction
      • functionReturnType

        private int[] functionReturnType
      • testReturn

        private int[] testReturn
      • returnTypeSet

        private boolean returnTypeSet
      • callResult

        protected java.lang.Object[] callResult
      • lastIndex

        private int lastIndex
    • Constructor Detail

      • PgCallableStatement

        PgCallableStatement​(PgConnection connection,
                            java.lang.String sql,
                            int rsType,
                            int rsConcurrency,
                            int rsHoldability)
                     throws java.sql.SQLException
        Throws:
        java.sql.SQLException
    • Method Detail

      • executeUpdate

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

        public java.lang.Object getObject​(int i,
                                          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 s,
                                          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
      • executeWithFlags

        public boolean executeWithFlags​(int flags)
                                 throws java.sql.SQLException
        Description copied from interface: BaseStatement
        Execute a prepared query, passing additional query flags.
        Specified by:
        executeWithFlags in interface BaseStatement
        Overrides:
        executeWithFlags in class PgPreparedStatement
        Parameters:
        flags - additional QueryExecutor flags for execution; these are bitwise-ORed into the default flags.
        Returns:
        true if there is a result set
        Throws:
        java.sql.SQLException - if something goes wrong.
      • registerOutParameter

        public void registerOutParameter​(int parameterIndex,
                                         int sqlType)
                                  throws java.sql.SQLException

        Before executing a stored procedure call you must explicitly call registerOutParameter to register the java.sql.Type of each out parameter.

        Note: When reading the value of an out parameter, you must use the getXXX method whose Java type XXX corresponds to the parameter's registered SQL type.

        ONLY 1 RETURN PARAMETER if {?= call ..} syntax is used

        Specified by:
        registerOutParameter in interface java.sql.CallableStatement
        Parameters:
        parameterIndex - the first parameter is 1, the second is 2,...
        sqlType - SQL type code defined by java.sql.Types; for parameters of type Numeric or Decimal use the version of registerOutParameter that accepts a scale value
        Throws:
        java.sql.SQLException - if a database-access error occurs.
      • wasNull

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

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

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

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

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

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

        protected void checkIndex​(int parameterIndex,
                                  int type1,
                                  int type2,
                                  java.lang.String getName)
                           throws java.sql.SQLException
        helperfunction for the getXXX calls to check isFunction and index == 1 Compare BOTH type fields against the return type.
        Parameters:
        parameterIndex - parameter index (1-based)
        type1 - type 1
        type2 - type 2
        getName - getter name
        Throws:
        java.sql.SQLException - if something goes wrong
      • checkIndex

        protected void checkIndex​(int parameterIndex,
                                  int type,
                                  java.lang.String getName)
                           throws java.sql.SQLException
        Helper function for the getXXX calls to check isFunction and index == 1.
        Parameters:
        parameterIndex - parameter index (1-based)
        type - type
        getName - getter name
        Throws:
        java.sql.SQLException - if given index is not valid
      • checkIndex

        private void checkIndex​(int parameterIndex)
                         throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • checkIndex

        private void checkIndex​(int parameterIndex,
                                boolean fetchingData)
                         throws java.sql.SQLException
        Helper function for the getXXX calls to check isFunction and index == 1.
        Parameters:
        parameterIndex - index of getXXX (index) check to make sure is a function and index == 1
        fetchingData - fetching data
        Throws:
        java.sql.SQLException
      • getArray

        public java.sql.Array getArray​(int i)
                                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
      • getBlob

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

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

        public java.lang.Object getObjectImpl​(int i,
                                              java.util.Map<java.lang.String,​java.lang.Class<?>> map)
                                       throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • getRef

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

        public java.sql.Date getDate​(int i,
                                     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​(int i,
                                     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 i,
                                               java.util.Calendar cal)
                                        throws java.sql.SQLException
        Specified by:
        getTimestamp 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
      • 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
      • 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
      • 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

        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

        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,
                                         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,
                                         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,
                                         java.sql.SQLType sqlType,
                                         java.lang.String typeName)
                                  throws java.sql.SQLException
        Specified by:
        registerOutParameter 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
      • 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
      • 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
      • 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
      • setCharacterStream

        public void setCharacterStream​(java.lang.String parameterName,
                                       java.io.Reader value,
                                       long length)
                                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 value)
                                throws java.sql.SQLException
        Specified by:
        setCharacterStream in interface java.sql.CallableStatement
        Throws:
        java.sql.SQLException
      • setBinaryStream

        public void setBinaryStream​(java.lang.String parameterName,
                                    java.io.InputStream value,
                                    long length)
                             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 value)
                             throws java.sql.SQLException
        Specified by:
        setBinaryStream in interface java.sql.CallableStatement
        Throws:
        java.sql.SQLException
      • setAsciiStream

        public void setAsciiStream​(java.lang.String parameterName,
                                   java.io.InputStream value,
                                   long length)
                            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 value)
                            throws java.sql.SQLException
        Specified by:
        setAsciiStream 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
      • 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
      • 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
      • 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
      • 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.sql.Blob x)
                     throws java.sql.SQLException
        Specified by:
        setBlob 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
      • 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
      • 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
      • 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
      • 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 parameterIndex)
                                  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
      • 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
      • 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,
                                         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,
                                         int sqlType,
                                         java.lang.String typeName)
                                  throws java.sql.SQLException
        Specified by:
        registerOutParameter 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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
      • 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,
                              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)
                       throws java.sql.SQLException
        Specified by:
        setObject 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,
                            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
      • 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
      • 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
      • 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​(java.lang.String parameterName)
                     throws java.sql.SQLException
        Specified by:
        getByte 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
      • 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
      • getFloat

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

        public byte[] getBytes​(java.lang.String parameterName)
                        throws java.sql.SQLException
        Specified by:
        getBytes 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
      • 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
      • 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
      • 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
      • 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
      • getObjectImpl

        public java.lang.Object getObjectImpl​(java.lang.String parameterName,
                                              java.util.Map<java.lang.String,​java.lang.Class<?>> map)
                                       throws java.sql.SQLException
        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
      • 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
      • 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
      • 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
      • 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
      • 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