Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.opencms.dbpool
Class CmsCallableStatement

java.lang.Object
  |
  +--com.opencms.dbpool.CmsStatement
        |
        +--com.opencms.dbpool.CmsPreparedStatement
              |
              +--com.opencms.dbpool.CmsCallableStatement
All Implemented Interfaces:
CallableStatement, PreparedStatement, Statement
public class CmsCallableStatement
extends CmsPreparedStatement
implements CallableStatement

The interface used to execute SQL stored procedures.

Author:
Andreas Schouten
See Also:
CallableStatement

Field Summary
 
Fields inherited from class com.opencms.dbpool.CmsStatement
m_con, m_originalStatement
 
Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
 
Method Summary
 Array getArray(int i)
           
 Array getArray(String str)
           
 BigDecimal getBigDecimal(int parameterIndex)
           
 BigDecimal getBigDecimal(int parameterIndex, int scale)
          Deprecated. This is deprecated in JDBC 3.0 but still must be implemented
 BigDecimal getBigDecimal(String str)
           
 Blob getBlob(int i)
           
 Blob getBlob(String str)
           
 boolean getBoolean(int parameterIndex)
           
 boolean getBoolean(String str)
           
 byte getByte(int parameterIndex)
           
 byte getByte(String str)
           
 byte[] getBytes(int parameterIndex)
           
 byte[] getBytes(String str)
           
 Clob getClob(int i)
           
 Clob getClob(String str)
           
 Date getDate(int parameterIndex)
           
 Date getDate(int parameterIndex, Calendar cal)
           
 Date getDate(String str)
           
 Date getDate(String str, Calendar calendar)
           
 double getDouble(int parameterIndex)
           
 double getDouble(String str)
           
 float getFloat(int parameterIndex)
           
 float getFloat(String str)
           
 int getInt(int parameterIndex)
           
 int getInt(String str)
           
 long getLong(int parameterIndex)
           
 long getLong(String str)
           
 Object getObject(int parameterIndex)
           
 Object getObject(int i, Map map)
           
 Object getObject(String str)
           
 Object getObject(String str, Map map)
           
 Ref getRef(int i)
           
 Ref getRef(String str)
           
 short getShort(int parameterIndex)
           
 short getShort(String str)
           
 String getString(int parameterIndex)
           
 String getString(String str)
           
 Time getTime(int parameterIndex)
           
 Time getTime(int parameterIndex, Calendar cal)
           
 Time getTime(String str)
           
 Time getTime(String str, Calendar calendar)
           
 Timestamp getTimestamp(int parameterIndex)
           
 Timestamp getTimestamp(int parameterIndex, Calendar cal)
           
 Timestamp getTimestamp(String str)
           
 Timestamp getTimestamp(String str, Calendar calendar)
           
 URL getURL(int param)
           
 URL getURL(String str)
           
 void registerOutParameter(int parameterIndex, int sqlType)
           
 void registerOutParameter(int parameterIndex, int sqlType, int scale)
           
 void registerOutParameter(int paramIndex, int sqlType, String typeName)
           
 void registerOutParameter(String str, int param)
           
 void registerOutParameter(String str, int param, int param2)
           
 void registerOutParameter(String str, int param, String str2)
           
 void setAsciiStream(String str, InputStream inputStream, int param)
           
 void setBigDecimal(String str, BigDecimal bigDecimal)
           
 void setBinaryStream(String str, InputStream inputStream, int param)
           
 void setBoolean(String str, boolean param)
           
 void setByte(String str, byte param)
           
 void setBytes(String str, byte[] values)
           
 void setCharacterStream(String str, Reader reader, int param)
           
 void setDate(String str, Date date)
           
 void setDate(String str, Date date, Calendar calendar)
           
 void setDouble(String str, double param)
           
 void setFloat(String str, float param)
           
 void setInt(String str, int param)
           
 void setLong(String str, long param)
           
 void setNull(String str, int param)
           
 void setNull(String str, int param, String str2)
           
 void setObject(String str, Object obj)
           
 void setObject(String str, Object obj, int param)
           
 void setObject(String str, Object obj, int param, int param3)
           
 void setShort(String str, short param)
           
 void setString(String str, String str1)
           
 void setTime(String str, Time time)
           
 void setTime(String str, Time time, Calendar calendar)
           
 void setTimestamp(String str, Timestamp timestamp)
           
 void setTimestamp(String str, Timestamp timestamp, Calendar calendar)
           
 void setURL(String str, URL uRL)
           
 boolean wasNull()
           
 
Methods inherited from class com.opencms.dbpool.CmsPreparedStatement
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
 
Methods inherited from class com.opencms.dbpool.CmsStatement
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, toString
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
 
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 

Method Detail

getString

public String getString(int parameterIndex)
                 throws SQLException
Specified by:
getString in interface CallableStatement
SQLException

getBoolean

public boolean getBoolean(int parameterIndex)
                   throws SQLException
Specified by:
getBoolean in interface CallableStatement
SQLException

getByte

public byte getByte(int parameterIndex)
             throws SQLException
Specified by:
getByte in interface CallableStatement
SQLException

getShort

public short getShort(int parameterIndex)
               throws SQLException
Specified by:
getShort in interface CallableStatement
SQLException

getInt

public int getInt(int parameterIndex)
           throws SQLException
Specified by:
getInt in interface CallableStatement
SQLException

getLong

public long getLong(int parameterIndex)
             throws SQLException
Specified by:
getLong in interface CallableStatement
SQLException

getFloat

public float getFloat(int parameterIndex)
               throws SQLException
Specified by:
getFloat in interface CallableStatement
SQLException

getDouble

public double getDouble(int parameterIndex)
                 throws SQLException
Specified by:
getDouble in interface CallableStatement
SQLException

getBigDecimal

public BigDecimal getBigDecimal(int parameterIndex,
                                int scale)
                         throws SQLException
Deprecated. This is deprecated in JDBC 3.0 but still must be implemented

Specified by:
getBigDecimal in interface CallableStatement
SQLException

getBytes

public byte[] getBytes(int parameterIndex)
                throws SQLException
Specified by:
getBytes in interface CallableStatement
SQLException

getDate

public Date getDate(int parameterIndex)
             throws SQLException
Specified by:
getDate in interface CallableStatement
SQLException

getTime

public Time getTime(int parameterIndex)
             throws SQLException
Specified by:
getTime in interface CallableStatement
SQLException

getTimestamp

public Timestamp getTimestamp(int parameterIndex)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
SQLException

getObject

public Object getObject(int parameterIndex)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
SQLException

getBigDecimal

public BigDecimal getBigDecimal(int parameterIndex)
                         throws SQLException
Specified by:
getBigDecimal in interface CallableStatement
SQLException

getObject

public Object getObject(int i,
                        Map map)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
SQLException

getRef

public Ref getRef(int i)
           throws SQLException
Specified by:
getRef in interface CallableStatement
SQLException

getBlob

public Blob getBlob(int i)
             throws SQLException
Specified by:
getBlob in interface CallableStatement
SQLException

getClob

public Clob getClob(int i)
             throws SQLException
Specified by:
getClob in interface CallableStatement
SQLException

getArray

public Array getArray(int i)
               throws SQLException
Specified by:
getArray in interface CallableStatement
SQLException

getDate

public Date getDate(int parameterIndex,
                    Calendar cal)
             throws SQLException
Specified by:
getDate in interface CallableStatement
SQLException

getTime

public Time getTime(int parameterIndex,
                    Calendar cal)
             throws SQLException
Specified by:
getTime in interface CallableStatement
SQLException

getTimestamp

public Timestamp getTimestamp(int parameterIndex,
                              Calendar cal)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
SQLException

wasNull

public boolean wasNull()
                throws SQLException
Specified by:
wasNull in interface CallableStatement
SQLException

registerOutParameter

public void registerOutParameter(int paramIndex,
                                 int sqlType,
                                 String typeName)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType,
                                 int scale)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
SQLException

getArray

public Array getArray(String str)
               throws SQLException
Specified by:
getArray in interface CallableStatement
SQLException

getBigDecimal

public BigDecimal getBigDecimal(String str)
                         throws SQLException
Specified by:
getBigDecimal in interface CallableStatement
SQLException

getBlob

public Blob getBlob(String str)
             throws SQLException
Specified by:
getBlob in interface CallableStatement
SQLException

getBoolean

public boolean getBoolean(String str)
                   throws SQLException
Specified by:
getBoolean in interface CallableStatement
SQLException

getByte

public byte getByte(String str)
             throws SQLException
Specified by:
getByte in interface CallableStatement
SQLException

getBytes

public byte[] getBytes(String str)
                throws SQLException
Specified by:
getBytes in interface CallableStatement
SQLException

getClob

public Clob getClob(String str)
             throws SQLException
Specified by:
getClob in interface CallableStatement
SQLException

getDate

public Date getDate(String str)
             throws SQLException
Specified by:
getDate in interface CallableStatement
SQLException

getDate

public Date getDate(String str,
                    Calendar calendar)
             throws SQLException
Specified by:
getDate in interface CallableStatement
SQLException

getDouble

public double getDouble(String str)
                 throws SQLException
Specified by:
getDouble in interface CallableStatement
SQLException

getFloat

public float getFloat(String str)
               throws SQLException
Specified by:
getFloat in interface CallableStatement
SQLException

getInt

public int getInt(String str)
           throws SQLException
Specified by:
getInt in interface CallableStatement
SQLException

getLong

public long getLong(String str)
             throws SQLException
Specified by:
getLong in interface CallableStatement
SQLException

getObject

public Object getObject(String str)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
SQLException

getObject

public Object getObject(String str,
                        Map map)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
SQLException

getRef

public Ref getRef(String str)
           throws SQLException
Specified by:
getRef in interface CallableStatement
SQLException

getShort

public short getShort(String str)
               throws SQLException
Specified by:
getShort in interface CallableStatement
SQLException

getString

public String getString(String str)
                 throws SQLException
Specified by:
getString in interface CallableStatement
SQLException

getTime

public Time getTime(String str)
             throws SQLException
Specified by:
getTime in interface CallableStatement
SQLException

getTime

public Time getTime(String str,
                    Calendar calendar)
             throws SQLException
Specified by:
getTime in interface CallableStatement
SQLException

getTimestamp

public Timestamp getTimestamp(String str)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
SQLException

getTimestamp

public Timestamp getTimestamp(String str,
                              Calendar calendar)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
SQLException

getURL

public URL getURL(int param)
           throws SQLException
Specified by:
getURL in interface CallableStatement
SQLException

getURL

public URL getURL(String str)
           throws SQLException
Specified by:
getURL in interface CallableStatement
SQLException

registerOutParameter

public void registerOutParameter(String str,
                                 int param)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
SQLException

registerOutParameter

public void registerOutParameter(String str,
                                 int param,
                                 int param2)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
SQLException

registerOutParameter

public void registerOutParameter(String str,
                                 int param,
                                 String str2)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
SQLException

setAsciiStream

public void setAsciiStream(String str,
                           InputStream inputStream,
                           int param)
                    throws SQLException
Specified by:
setAsciiStream in interface CallableStatement
SQLException

setBigDecimal

public void setBigDecimal(String str,
                          BigDecimal bigDecimal)
                   throws SQLException
Specified by:
setBigDecimal in interface CallableStatement
SQLException

setBinaryStream

public void setBinaryStream(String str,
                            InputStream inputStream,
                            int param)
                     throws SQLException
Specified by:
setBinaryStream in interface CallableStatement
SQLException

setBoolean

public void setBoolean(String str,
                       boolean param)
                throws SQLException
Specified by:
setBoolean in interface CallableStatement
SQLException

setByte

public void setByte(String str,
                    byte param)
             throws SQLException
Specified by:
setByte in interface CallableStatement
SQLException

setBytes

public void setBytes(String str,
                     byte[] values)
              throws SQLException
Specified by:
setBytes in interface CallableStatement
SQLException

setCharacterStream

public void setCharacterStream(String str,
                               Reader reader,
                               int param)
                        throws SQLException
Specified by:
setCharacterStream in interface CallableStatement
SQLException

setDate

public void setDate(String str,
                    Date date)
             throws SQLException
Specified by:
setDate in interface CallableStatement
SQLException

setDate

public void setDate(String str,
                    Date date,
                    Calendar calendar)
             throws SQLException
Specified by:
setDate in interface CallableStatement
SQLException

setDouble

public void setDouble(String str,
                      double param)
               throws SQLException
Specified by:
setDouble in interface CallableStatement
SQLException

setFloat

public void setFloat(String str,
                     float param)
              throws SQLException
Specified by:
setFloat in interface CallableStatement
SQLException

setInt

public void setInt(String str,
                   int param)
            throws SQLException
Specified by:
setInt in interface CallableStatement
SQLException

setLong

public void setLong(String str,
                    long param)
             throws SQLException
Specified by:
setLong in interface CallableStatement
SQLException

setNull

public void setNull(String str,
                    int param)
             throws SQLException
Specified by:
setNull in interface CallableStatement
SQLException

setNull

public void setNull(String str,
                    int param,
                    String str2)
             throws SQLException
Specified by:
setNull in interface CallableStatement
SQLException

setObject

public void setObject(String str,
                      Object obj)
               throws SQLException
Specified by:
setObject in interface CallableStatement
SQLException

setObject

public void setObject(String str,
                      Object obj,
                      int param)
               throws SQLException
Specified by:
setObject in interface CallableStatement
SQLException

setObject

public void setObject(String str,
                      Object obj,
                      int param,
                      int param3)
               throws SQLException
Specified by:
setObject in interface CallableStatement
SQLException

setShort

public void setShort(String str,
                     short param)
              throws SQLException
Specified by:
setShort in interface CallableStatement
SQLException

setString

public void setString(String str,
                      String str1)
               throws SQLException
Specified by:
setString in interface CallableStatement
SQLException

setTime

public void setTime(String str,
                    Time time)
             throws SQLException
Specified by:
setTime in interface CallableStatement
SQLException

setTime

public void setTime(String str,
                    Time time,
                    Calendar calendar)
             throws SQLException
Specified by:
setTime in interface CallableStatement
SQLException

setTimestamp

public void setTimestamp(String str,
                         Timestamp timestamp)
                  throws SQLException
Specified by:
setTimestamp in interface CallableStatement
SQLException

setTimestamp

public void setTimestamp(String str,
                         Timestamp timestamp,
                         Calendar calendar)
                  throws SQLException
Specified by:
setTimestamp in interface CallableStatement
SQLException

setURL

public void setURL(String str,
                   URL uRL)
            throws SQLException
Specified by:
setURL in interface CallableStatement
SQLException
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD