oracle.jsp.dbutil
Class CursorBean

java.lang.Object
  |
  +--oracle.jsp.dbutil.CursorBean

public class CursorBean
extends java.lang.Object
implements JspScopeListener

A general purpose cursor bean. Can represent Statement, Prepared Statement and Callable Statement depending upon the type specified. Can also represent Scrollable cursors.

  • ExecuteBatch Execute Batch Size for DMLs
  • PreFetch Row prefetch size for the rows returned for querie
  • queryTimeout Query Timeout for SQL Execution
  • ResultSetType ResultSetType for Scrollable Cursors
  • ResultSetConcurrency Concurrency for Scrollable Cursors


    Field Summary
    static int CALL_STMT
               
    static int CONCUR_READ_ONLY
               
    static int CONCUR_UPDATABLE
               
    static int PLAIN_STMT
               
    static int PREP_STMT
               
    static int TYPE_FORWARD_ONLY
               
    static int TYPE_SCROLL_INSENSITIVE
               
    static int TYPE_SCROLL_SENSITIVE
               
     
    Constructor Summary
    CursorBean()
               
     
    Method Summary
     void close()
              Close the cursor.
     void create()
              Create a cursor for Queries
     void create(ConnBean cb)
              Create a cursor for Queries
     void create(ConnBean cb, int type, java.lang.String sql)
              Create a cursor with the given type and sql string on a given connection.
     void create(int type, java.lang.String sql)
              Create a cursor with the given type and sql string on a connection set before.
     boolean execute()
              Execute the Statement and return the status.
     boolean execute(java.lang.String sql)
              Execute the Statement with the given sql.
     java.sql.ResultSet executeQuery()
              Execute the Statement and return the ResultSet.
     java.sql.ResultSet executeQuery(java.lang.String sql)
              Execute the Statement with the given Sql.
     int executeUpdate()
              Execute the Statement and return the no of rows affected.
     int executeUpdate(java.lang.String sql)
              Execute the Statement with the given Sql.
     oracle.jsp.dbutil.ARRAY getARRAY(int parameterIndex)
               
     java.io.InputStream getAsciiStream(int parameterIndex)
               
     oracle.jsp.dbutil.BFILE getBFILE(int parameterIndex)
               
     java.math.BigDecimal getBigDecimal(int parameterIndex, int scale)
               
     java.io.InputStream getBinaryStream(int parameterIndex)
               
     oracle.jsp.dbutil.BLOB getBLOB(int parameterIndex)
               
     boolean getBoolean(int parameterIndex)
               
     byte getByte(int parameterIndex)
               
     byte[] getBytes(int parameterIndex)
               
     oracle.jsp.dbutil.CHAR getCHAR(int parameterIndex)
               
     oracle.jsp.dbutil.CLOB getCLOB(int parameterIndex)
               
     java.sql.ResultSet getCursor(int parameterIndex)
               
     java.lang.Object getCustomDatum(int parameterIndex, oracle.jsp.dbutil.CustomDatumFactory factory)
               
     java.sql.Date getDate(int parameterIndex)
               
     oracle.jsp.dbutil.DATE getDATE(int parameterIndex)
               
     double getDouble(int parameterIndex)
               
     int getExecuteBatch()
              Get the execute batch size for this cursor bean.
     float getFloat(int parameterIndex)
               
     int getInt(int parameterIndex)
               
     java.sql.Connection getJDBCConnection()
              Get the underlying connection object.
     long getLong(int parameterIndex)
               
     int getMaxRows()
               
     oracle.jsp.dbutil.NUMBER getNUMBER(int parameterIndex)
               
     java.lang.Object getObject(int parameterIndex)
               
     oracle.jsp.dbutil.Datum getOracleObject(int parameterIndex)
               
     int getPreFetch()
              Get the Row prefetch size for this cursor bean.
     int getQueryTimeout()
              The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.
     oracle.jsp.dbutil.RAW getRAW(int parameterIndex)
               
     oracle.jsp.dbutil.REF getREF(int parameterIndex)
               
     java.lang.String getResultAsHTMLTable()
              Execute the Sql and return the result as a HTM Table.
     java.lang.String getResultAsHTMLTable(java.lang.String sql)
              Execute the Sql and return the result as a HTM Table.
     org.w3c.dom.Document getResultAsXMLDocument(java.lang.String sql)
              Execute the Sql and return the result as a XML String
     java.lang.String getResultAsXMLString()
              Execute the Sql and return the result as a XML String Sql string is the one that was used at creation time.
     java.lang.String getResultAsXMLString(java.lang.String sql)
              Execute the Sql and return the result as a XML String
     int getResultSetConcurrency()
              Return the concurrency level set for this cursor.
     int getResultSetType()
              Return the result type set for this cursor.
     oracle.jsp.dbutil.ROWID getROWID(int parameterIndex)
               
     short getShort(int parameterIndex)
               
     int getSkipRows()
               
     java.lang.String getString(int parameterIndex)
               
     oracle.jsp.dbutil.STRUCT getSTRUCT(int parameterIndex)
               
     java.sql.Time getTime(int parameterIndex)
               
     java.sql.Timestamp getTimestamp(int parameterIndex)
               
     java.io.InputStream getUnicodeStream(int parameterIndex)
               
     int getUpdateCount()
               
     void outOfScope(JspScopeEvent ae)
              Invoked when a JSP scope that this object is attached to is ending.
     void registerOutParameter(int paramIndex, int sqlType)
               
     void registerOutParameter(int paramIndex, int sqlType, int scale)
               
     void registerOutParameter(int paramIndex, int sqlType, int scale, int maxLength)
               
     void registerOutParameter(int paramIndex, int sqlType, java.lang.String sqlName)
               
     void setARRAY(int paramIndex, oracle.jsp.dbutil.ARRAY arr)
               
     void setAsciiStream(int paramIndex, java.io.InputStream istream, int length)
               
     void setBfile(int paramIndex, oracle.jsp.dbutil.BFILE file)
               
     void setBFILE(int paramIndex, oracle.jsp.dbutil.BFILE file)
               
     void setBigDecimal(int paramIndex, java.math.BigDecimal x)
               
     void setBinaryStream(int paramIndex, java.io.InputStream istream, int length)
               
     void setBLOB(int paramIndex, oracle.jsp.dbutil.BLOB lob)
               
     void setBoolean(int paramIndex, boolean x)
               
     void setByte(int paramIndex, byte x)
               
     void setBytes(int paramIndex, byte[] x)
               
     void setCHAR(int paramIndex, oracle.jsp.dbutil.CHAR ch)
               
     void setCLOB(int paramIndex, oracle.jsp.dbutil.CLOB lob)
               
     void setConnBean(ConnBean cb)
              Set the underlying connection bean.
     void setCursor(int paramIndex, java.sql.ResultSet rs)
               
     void setCustomDatum(int paramIndex, oracle.jsp.dbutil.CustomDatum x)
               
     void setDate(int paramIndex, java.sql.Date x)
               
     void setDATE(int paramIndex, oracle.jsp.dbutil.DATE date)
               
     void setDouble(int paramIndex, double x)
               
     void setExecuteBatch(int bsize)
              Set the Execute Batch Size for DMLs.
     void setFixedCHAR(int paramIndex, java.lang.String x)
               
     void setFloat(int paramIndex, float x)
               
     void setInt(int paramIndex, int x)
               
     void setLong(int paramIndex, long x)
               
     void setMaxRows(int maxRows)
               
     void setNull(int paramIndex, int sqlType)
               
     void setNull(int paramIndex, int sqlType, java.lang.String sqlName)
               
     void setNUMBER(int paramIndex, oracle.jsp.dbutil.NUMBER num)
               
     void setObject(int paramIndex, java.lang.Object x)
               
     void setObject(int paramIndex, java.lang.Object x, int targetSqlType)
               
     void setObject(int paramIndex, java.lang.Object x, int targetSqlType, int scale)
               
     void setOracleObject(int paramIndex, oracle.jsp.dbutil.Datum x)
               
     void setPreFetch(int prefSize)
              Set the Row prefetch size for the rows returned for queries.
     void setQueryTimeout(int tout)
              The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.
     void setRAW(int paramIndex, oracle.jsp.dbutil.RAW raw)
               
     void setREF(int paramIndex, oracle.jsp.dbutil.REF ref)
               
     void setRefType(int paramIndex, oracle.jsp.dbutil.REF ref)
               
     void setResultSetConcurrency(int rscon)
              Set the ResultSet Concurrency for the cursor.
     void setResultSetType(int rtype)
              Set the ResultType for the cursor created.
     void setROWID(int paramIndex, oracle.jsp.dbutil.ROWID x)
               
     void setShort(int paramIndex, short x)
               
     void setSkipRows(int skipRows)
               
     void setString(int paramIndex, java.lang.String x)
               
     void setSTRUCT(int paramIndex, oracle.jsp.dbutil.STRUCT struct)
               
     void setTime(int paramIndex, java.sql.Time x)
               
     void setTimestamp(int paramIndex, java.sql.Timestamp x)
               
     void setUnicodeStream(int paramIndex, java.io.InputStream istream, int length)
               
     
    Methods inherited from class java.lang.Object
    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
     

    Field Detail

    PLAIN_STMT

    public static final int PLAIN_STMT

    PREP_STMT

    public static final int PREP_STMT

    CALL_STMT

    public static final int CALL_STMT

    TYPE_FORWARD_ONLY

    public static final int TYPE_FORWARD_ONLY

    TYPE_SCROLL_INSENSITIVE

    public static final int TYPE_SCROLL_INSENSITIVE

    TYPE_SCROLL_SENSITIVE

    public static final int TYPE_SCROLL_SENSITIVE

    CONCUR_READ_ONLY

    public static final int CONCUR_READ_ONLY

    CONCUR_UPDATABLE

    public static final int CONCUR_UPDATABLE
    Constructor Detail

    CursorBean

    public CursorBean()
    Method Detail

    setConnBean

    public void setConnBean(ConnBean cb)
    Set the underlying connection bean.
    Parameters:
    cb - underlying connection bean for the cursor

    create

    public void create(ConnBean cb,
                       int type,
                       java.lang.String sql)
                throws java.sql.SQLException
    Create a cursor with the given type and sql string on a given connection. Sql can be null for Plain Statement.

    Parameters:
    cb - underlying connection bean for the cursor
    stype - Statement Type. Possible values are
    • ConnBean.PLAIN_STMT : For Plain Statements
    • ConnBean.PREP_STMT : For Prepared Statement
    • ConnBean.CALL_STMT : For Callable Statements

    sql - Sql string to be executed
    Throws:
    java.sql.SQLException - if cursor creation fails.

    create

    public void create(ConnBean cb)
                throws java.sql.SQLException
    Create a cursor for Queries
    Parameters:
    cb - underlying connection bean for the cursor
    Throws:
    java.sql.SQLException - if cursor creation fails.

    create

    public void create()
                throws java.sql.SQLException
    Create a cursor for Queries
    Throws:
    java.sql.SQLException - if cursor creation fails.

    getJDBCConnection

    public java.sql.Connection getJDBCConnection()
    Get the underlying connection object.
    Returns:
    JDBC Connection Object

    create

    public void create(int type,
                       java.lang.String sql)
                throws java.sql.SQLException
    Create a cursor with the given type and sql string on a connection set before. Sql is ignored if it's a Plain Statement.

    Parameters:
    stype - Statement Type. Possible values are
    • ConnBean.PLAIN_STMT : For Plain Statements
    • ConnBean.PREP_STMT : For Prepared Statement
    • ConnBean.CALL_STMT : For Callable Statements

    sql - Sql string to be executed
    Throws:
    java.sql.SQLException - if cursor creation fails.

    executeQuery

    public java.sql.ResultSet executeQuery(java.lang.String sql)
                                    throws java.sql.SQLException
    Execute the Statement with the given Sql. Overwrites the previously set Sql String. Typically should be called for Vanilla Statements.
    Parameters:
    Sql - string to be executed
    Returns:
    Return the rows in the form of a ResultSet
    Throws:
    java.sql.SQLException - if sql execution fails

    executeQuery

    public java.sql.ResultSet executeQuery()
                                    throws java.sql.SQLException
    Execute the Statement and return the ResultSet. Typically should be called by Prepared and Callable Statements.
    Returns:
    Return the rows in the form of a ResultSet
    Throws:
    java.sql.SQLException - if sql execution fails

    executeUpdate

    public int executeUpdate(java.lang.String sql)
                      throws java.sql.SQLException
    Execute the Statement with the given Sql. Overwrites the previously set Sql String. Typically should be called for Vanilla Statements.
    Parameters:
    Sql - string to be executed
    Returns:
    Return the rows of rows affected.
    Throws:
    java.sql.SQLException - if sql execution fails

    executeUpdate

    public int executeUpdate()
                      throws java.sql.SQLException
    Execute the Statement and return the no of rows affected. Typically should be called by Prepared and Callable Statements.
    Returns:
    Return the rows of rows affected.
    Throws:
    java.sql.SQLException - if sql execution fails

    getUpdateCount

    public int getUpdateCount()
                       throws java.sql.SQLException

    execute

    public boolean execute(java.lang.String sql)
                    throws java.sql.SQLException
    Execute the Statement with the given sql. Typically should be called for Vanilla Statements.
    Returns:
    Return the status of the Statement execution
    Throws:
    java.sql.SQLException - if sql execution fails

    execute

    public boolean execute()
                    throws java.sql.SQLException
    Execute the Statement and return the status. Typically should be called by Prepared and Callable Statements.
    Returns:
    Return the status of the Statement execution
    Throws:
    java.sql.SQLException - if sql execution fails

    close

    public void close()
               throws java.sql.SQLException
    Close the cursor.
    Throws:
    java.sql.SQLException - error during closing

    setResultSetType

    public void setResultSetType(int rtype)
    Set the ResultType for the cursor created. The default is TYPE_FORWARD_ONLY

    Parameters:
    rtype - Result Set type. Possible values are
    • CursorBean.TYPE_FORWARD_ONLY
    • CursorBean.TYPE_SCROLL_INSENSITIVE
    • CursorBean.TYPE_SCROLL_SENSITIVE

    getResultSetType

    public int getResultSetType()
    Return the result type set for this cursor.
    Returns:
    result type set or the default if not set.

    setResultSetConcurrency

    public void setResultSetConcurrency(int rscon)
    Set the ResultSet Concurrency for the cursor. Default value is CONCUR_READ_ONLY

    Parameters:
    rscon. - ResultSet Concurrency. Possible values are
    • CursorBean.CONCUR_READ_ONLY
    • CursorBean.CONCUR_UPDATABLE

    getResultSetConcurrency

    public int getResultSetConcurrency()
    Return the concurrency level set for this cursor.
    Returns:
    concurrency level set or the default if not set.

    setPreFetch

    public void setPreFetch(int prefSize)
    Set the Row prefetch size for the rows returned for queries.

    Parameters:
    prefSize - prefetch size

    getPreFetch

    public int getPreFetch()
    Get the Row prefetch size for this cursor bean. Returns 10 (default) if not set.

    Returns:
    Row prefetch size for this cursor bean.


    setMaxRows

    public void setMaxRows(int maxRows)

    getMaxRows

    public int getMaxRows()

    setSkipRows

    public void setSkipRows(int skipRows)

    getSkipRows

    public int getSkipRows()

    setExecuteBatch

    public void setExecuteBatch(int bsize)
    Set the Execute Batch Size for DMLs.

    Parameters:
    bsize - Execute Batch Size

    getExecuteBatch

    public int getExecuteBatch()
    Get the execute batch size for this cursor bean. Returns 1 (default) if not set.

    Returns:
    execute batch size for this cursor bean.


    setQueryTimeout

    public void setQueryTimeout(int tout)
    The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown.

    Parameters:
    tout - the new query timeout limit in seconds; zero means unlimit

    getQueryTimeout

    public int getQueryTimeout()
    The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown.
    Returns:
    the current query timeout limit in seconds; zero means unlimited

    setNull

    public void setNull(int paramIndex,
                        int sqlType,
                        java.lang.String sqlName)
                 throws java.sql.SQLException

    setNull

    public void setNull(int paramIndex,
                        int sqlType)
                 throws java.sql.SQLException

    setBoolean

    public void setBoolean(int paramIndex,
                           boolean x)
                    throws java.sql.SQLException

    setByte

    public void setByte(int paramIndex,
                        byte x)
                 throws java.sql.SQLException

    setShort

    public void setShort(int paramIndex,
                         short x)
                  throws java.sql.SQLException

    setInt

    public void setInt(int paramIndex,
                       int x)
                throws java.sql.SQLException

    setLong

    public void setLong(int paramIndex,
                        long x)
                 throws java.sql.SQLException

    setFloat

    public void setFloat(int paramIndex,
                         float x)
                  throws java.sql.SQLException

    setDouble

    public void setDouble(int paramIndex,
                          double x)
                   throws java.sql.SQLException

    setBigDecimal

    public void setBigDecimal(int paramIndex,
                              java.math.BigDecimal x)
                       throws java.sql.SQLException

    setString

    public void setString(int paramIndex,
                          java.lang.String x)
                   throws java.sql.SQLException

    setFixedCHAR

    public void setFixedCHAR(int paramIndex,
                             java.lang.String x)
                      throws java.sql.SQLException

    setCursor

    public void setCursor(int paramIndex,
                          java.sql.ResultSet rs)
                   throws java.sql.SQLException

    setROWID

    public void setROWID(int paramIndex,
                         oracle.jsp.dbutil.ROWID x)
                  throws java.sql.SQLException

    setARRAY

    public void setARRAY(int paramIndex,
                         oracle.jsp.dbutil.ARRAY arr)
                  throws java.sql.SQLException

    setSTRUCT

    public void setSTRUCT(int paramIndex,
                          oracle.jsp.dbutil.STRUCT struct)
                   throws java.sql.SQLException

    setRAW

    public void setRAW(int paramIndex,
                       oracle.jsp.dbutil.RAW raw)
                throws java.sql.SQLException

    setCHAR

    public void setCHAR(int paramIndex,
                        oracle.jsp.dbutil.CHAR ch)
                 throws java.sql.SQLException

    setDATE

    public void setDATE(int paramIndex,
                        oracle.jsp.dbutil.DATE date)
                 throws java.sql.SQLException

    setNUMBER

    public void setNUMBER(int paramIndex,
                          oracle.jsp.dbutil.NUMBER num)
                   throws java.sql.SQLException

    setBLOB

    public void setBLOB(int paramIndex,
                        oracle.jsp.dbutil.BLOB lob)
                 throws java.sql.SQLException

    setCLOB

    public void setCLOB(int paramIndex,
                        oracle.jsp.dbutil.CLOB lob)
                 throws java.sql.SQLException

    setBFILE

    public void setBFILE(int paramIndex,
                         oracle.jsp.dbutil.BFILE file)
                  throws java.sql.SQLException

    setBfile

    public void setBfile(int paramIndex,
                         oracle.jsp.dbutil.BFILE file)
                  throws java.sql.SQLException

    setBytes

    public void setBytes(int paramIndex,
                         byte[] x)
                  throws java.sql.SQLException

    setDate

    public void setDate(int paramIndex,
                        java.sql.Date x)
                 throws java.sql.SQLException

    setTime

    public void setTime(int paramIndex,
                        java.sql.Time x)
                 throws java.sql.SQLException

    setTimestamp

    public void setTimestamp(int paramIndex,
                             java.sql.Timestamp x)
                      throws java.sql.SQLException

    setUnicodeStream

    public void setUnicodeStream(int paramIndex,
                                 java.io.InputStream istream,
                                 int length)
                          throws java.sql.SQLException

    setAsciiStream

    public void setAsciiStream(int paramIndex,
                               java.io.InputStream istream,
                               int length)
                        throws java.sql.SQLException

    setBinaryStream

    public void setBinaryStream(int paramIndex,
                                java.io.InputStream istream,
                                int length)
                         throws java.sql.SQLException

    setCustomDatum

    public void setCustomDatum(int paramIndex,
                               oracle.jsp.dbutil.CustomDatum x)
                        throws java.sql.SQLException

    setObject

    public void setObject(int paramIndex,
                          java.lang.Object x,
                          int targetSqlType,
                          int scale)
                   throws java.sql.SQLException

    setObject

    public void setObject(int paramIndex,
                          java.lang.Object x,
                          int targetSqlType)
                   throws java.sql.SQLException

    setRefType

    public void setRefType(int paramIndex,
                           oracle.jsp.dbutil.REF ref)
                    throws java.sql.SQLException

    setREF

    public void setREF(int paramIndex,
                       oracle.jsp.dbutil.REF ref)
                throws java.sql.SQLException

    setObject

    public void setObject(int paramIndex,
                          java.lang.Object x)
                   throws java.sql.SQLException

    setOracleObject

    public void setOracleObject(int paramIndex,
                                oracle.jsp.dbutil.Datum x)
                         throws java.sql.SQLException

    registerOutParameter

    public void registerOutParameter(int paramIndex,
                                     int sqlType,
                                     java.lang.String sqlName)
                              throws java.sql.SQLException

    registerOutParameter

    public void registerOutParameter(int paramIndex,
                                     int sqlType,
                                     int scale)
                              throws java.sql.SQLException

    registerOutParameter

    public void registerOutParameter(int paramIndex,
                                     int sqlType,
                                     int scale,
                                     int maxLength)
                              throws java.sql.SQLException

    registerOutParameter

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

    getString

    public java.lang.String getString(int parameterIndex)
                               throws java.sql.SQLException

    getOracleObject

    public oracle.jsp.dbutil.Datum getOracleObject(int parameterIndex)
                                            throws java.sql.SQLException

    getROWID

    public oracle.jsp.dbutil.ROWID getROWID(int parameterIndex)
                                     throws java.sql.SQLException

    getNUMBER

    public oracle.jsp.dbutil.NUMBER getNUMBER(int parameterIndex)
                                       throws java.sql.SQLException

    getDATE

    public oracle.jsp.dbutil.DATE getDATE(int parameterIndex)
                                   throws java.sql.SQLException

    getREF

    public oracle.jsp.dbutil.REF getREF(int parameterIndex)
                                 throws java.sql.SQLException

    getARRAY

    public oracle.jsp.dbutil.ARRAY getARRAY(int parameterIndex)
                                     throws java.sql.SQLException

    getSTRUCT

    public oracle.jsp.dbutil.STRUCT getSTRUCT(int parameterIndex)
                                       throws java.sql.SQLException

    getCHAR

    public oracle.jsp.dbutil.CHAR getCHAR(int parameterIndex)
                                   throws java.sql.SQLException

    getRAW

    public oracle.jsp.dbutil.RAW getRAW(int parameterIndex)
                                 throws java.sql.SQLException

    getBLOB

    public oracle.jsp.dbutil.BLOB getBLOB(int parameterIndex)
                                   throws java.sql.SQLException

    getCLOB

    public oracle.jsp.dbutil.CLOB getCLOB(int parameterIndex)
                                   throws java.sql.SQLException

    getBFILE

    public oracle.jsp.dbutil.BFILE getBFILE(int parameterIndex)
                                     throws java.sql.SQLException

    getBoolean

    public boolean getBoolean(int parameterIndex)
                       throws java.sql.SQLException

    getByte

    public byte getByte(int parameterIndex)
                 throws java.sql.SQLException

    getShort

    public short getShort(int parameterIndex)
                   throws java.sql.SQLException

    getInt

    public int getInt(int parameterIndex)
               throws java.sql.SQLException

    getLong

    public long getLong(int parameterIndex)
                 throws java.sql.SQLException

    getFloat

    public float getFloat(int parameterIndex)
                   throws java.sql.SQLException

    getDouble

    public double getDouble(int parameterIndex)
                     throws java.sql.SQLException

    getBigDecimal

    public java.math.BigDecimal getBigDecimal(int parameterIndex,
                                              int scale)
                                       throws java.sql.SQLException

    getBytes

    public byte[] getBytes(int parameterIndex)
                    throws java.sql.SQLException

    getDate

    public java.sql.Date getDate(int parameterIndex)
                          throws java.sql.SQLException

    getTime

    public java.sql.Time getTime(int parameterIndex)
                          throws java.sql.SQLException

    getTimestamp

    public java.sql.Timestamp getTimestamp(int parameterIndex)
                                    throws java.sql.SQLException

    getAsciiStream

    public java.io.InputStream getAsciiStream(int parameterIndex)
                                       throws java.sql.SQLException

    getUnicodeStream

    public java.io.InputStream getUnicodeStream(int parameterIndex)
                                         throws java.sql.SQLException

    getBinaryStream

    public java.io.InputStream getBinaryStream(int parameterIndex)
                                        throws java.sql.SQLException

    getObject

    public java.lang.Object getObject(int parameterIndex)
                               throws java.sql.SQLException

    getCustomDatum

    public java.lang.Object getCustomDatum(int parameterIndex,
                                           oracle.jsp.dbutil.CustomDatumFactory factory)
                                    throws java.sql.SQLException

    getCursor

    public java.sql.ResultSet getCursor(int parameterIndex)
                                 throws java.sql.SQLException

    getResultAsXMLString

    public java.lang.String getResultAsXMLString()
                                          throws java.sql.SQLException
    Execute the Sql and return the result as a XML String Sql string is the one that was used at creation time.
    Returns:
    Result as a XML String.
    Throws:
    java.sql.SQLException - if cursor execution fails.

    getResultAsXMLString

    public java.lang.String getResultAsXMLString(java.lang.String sql)
                                          throws java.sql.SQLException
    Execute the Sql and return the result as a XML String
    Parameters:
    sql - Sql String to be executed
    Returns:
    Result as a XML String.
    Throws:
    java.sql.SQLException - if cursor execution fails.

    getResultAsXMLDocument

    public org.w3c.dom.Document getResultAsXMLDocument(java.lang.String sql)
                                                throws java.sql.SQLException
    Execute the Sql and return the result as a XML String
    Parameters:
    sql - Sql String to be executed
    Returns:
    Result as a XML String.
    Throws:
    java.sql.SQLException - if cursor execution fails.

    getResultAsHTMLTable

    public java.lang.String getResultAsHTMLTable(java.lang.String sql)
                                          throws java.sql.SQLException
    Execute the Sql and return the result as a HTM Table.
    Parameters:
    sql - Sql String to be executed
    Returns:
    Result as a HTML table.
    Throws:
    java.sql.SQLException - if cursor execution fails.

    getResultAsHTMLTable

    public java.lang.String getResultAsHTMLTable()
                                          throws java.sql.SQLException
    Execute the Sql and return the result as a HTM Table. Sql string is the one that was used at creation time.
    Returns:
    Result as a HTML table.
    Throws:
    java.sql.SQLException - if cursor execution fails.

    outOfScope

    public void outOfScope(JspScopeEvent ae)
    Description copied from interface: JspScopeListener
    Invoked when a JSP scope that this object is attached to is ending.
    Specified by:
    outOfScope in interface JspScopeListener