Class DbResultSet

  • All Implemented Interfaces:
    de.uplanet.lucy.server.util.db.IDbResultSet, de.uplanet.lucy.server.util.db.IValueAccess, de.uplanet.lucy.server.util.db.IValueHolderAccess, de.uplanet.util.ICloseable, AutoCloseable, Iterable<IDbRow>

    public final class DbResultSet
    extends Object
    implements de.uplanet.lucy.server.util.db.IDbResultSet, Iterable<IDbRow>
    • Method Detail

      • getRowCount

        public int getRowCount()
        Get the number of rows read so far.
        Returns:
        The number of rows read so far.
      • next

        public boolean next()
                     throws SQLException
        Specified by:
        next in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
      • wasNull

        public boolean wasNull​(int p_iIdx)
                        throws SQLException
        Specified by:
        wasNull in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
      • getValueHolder

        public IValueHolder<?> getValueHolder​(int p_iIdx)
                                       throws SQLException
        Specified by:
        getValueHolder in interface de.uplanet.lucy.server.util.db.IValueHolderAccess
        Throws:
        SQLException
      • getValueHolder

        public IValueHolder<?> getValueHolder​(int p_iIdx,
                                              QName p_qmnDataType)
                                       throws SQLException
        Specified by:
        getValueHolder in interface de.uplanet.lucy.server.util.db.IValueHolderAccess
        Throws:
        SQLException
      • getValueHolder

        public IValueHolder<?> getValueHolder​(int p_iIdx,
                                              String p_strDataTypeAsSerializedQName)
                                       throws SQLException
        Specified by:
        getValueHolder in interface de.uplanet.lucy.server.util.db.IValueHolderAccess
        Throws:
        SQLException
      • getValueHolder

        public IValueHolder<?> getValueHolder​(int p_iIdx,
                                              String p_strDataTypeAsSerializedQName,
                                              IValueHolder<?> p_valueIfNull)
                                       throws SQLException
        Specified by:
        getValueHolder in interface de.uplanet.lucy.server.util.db.IValueHolderAccess
        Throws:
        SQLException
      • getValue

        public Object getValue​(int p_iIdx)
                        throws SQLException
        Specified by:
        getValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
      • getValue

        public Object getValue​(int p_iIdx,
                               Object p_valueIfNull)
                        throws SQLException
        Specified by:
        getValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
      • getBooleanValue

        public Boolean getBooleanValue​(int p_iIdx)
                                throws SQLException,
                                       de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getBooleanValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getBooleanValue

        public Boolean getBooleanValue​(int p_iIdx,
                                       Boolean p_valueIfNull)
                                throws SQLException,
                                       de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getBooleanValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getByteValue

        public byte getByteValue​(int p_iIdx)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getByteValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getByteValue

        public Byte getByteValue​(int p_iIdx,
                                 Byte p_valueIfNull)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getByteValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getShortValue

        public Short getShortValue​(int p_iIdx)
                            throws SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getShortValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getShortValue

        public Short getShortValue​(int p_iIdx,
                                   Short p_valueIfNull)
                            throws SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getShortValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getIntValue

        public Integer getIntValue​(int p_iIdx)
                            throws SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getIntValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getIntValue

        public Integer getIntValue​(int p_iIdx,
                                   Integer p_valueIfNull)
                            throws SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getIntValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getLongValue

        public Long getLongValue​(int p_iIdx)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getLongValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getLongValue

        public Long getLongValue​(int p_iIdx,
                                 Long p_valueIfNull)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getLongValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getFloatValue

        public Float getFloatValue​(int p_iIdx)
                            throws SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getFloatValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getFloatValue

        public Float getFloatValue​(int p_iIdx,
                                   Float p_valueIfNull)
                            throws SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getFloatValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDoubleValue

        public Double getDoubleValue​(int p_iIdx)
                              throws SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDoubleValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDoubleValue

        public Double getDoubleValue​(int p_iIdx,
                                     Double p_valueIfNull)
                              throws SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDoubleValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getBigDecimalValue

        public BigDecimal getBigDecimalValue​(int p_iIdx)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getBigDecimalValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getBigDecimalValue

        public BigDecimal getBigDecimalValue​(int p_iIdx,
                                             BigDecimal p_valueIfNull)
                                      throws SQLException,
                                             de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getBigDecimalValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getStringValue

        public String getStringValue​(int p_iIdx)
                              throws SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getStringValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getStringValue

        public String getStringValue​(int p_iIdx,
                                     String p_valueIfNull)
                              throws SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getStringValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimestampValue

        public Timestamp getTimestampValue​(int p_iIdx)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimestampValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimestampValue

        public Timestamp getTimestampValue​(int p_iIdx,
                                           Calendar p_cal)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimestampValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimestampValue

        public Timestamp getTimestampValue​(int p_iIdx,
                                           TimeZone p_tz)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimestampValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimestampValue

        public Timestamp getTimestampValue​(int p_iIdx,
                                           Timestamp p_valueIfNull)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimestampValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimestampValue

        public Timestamp getTimestampValue​(int p_iIdx,
                                           Timestamp p_valueIfNull,
                                           TimeZone p_tz)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimestampValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimestampValue

        public Timestamp getTimestampValue​(int p_iIdx,
                                           Timestamp p_valueIfNull,
                                           Calendar p_cal)
                                    throws SQLException,
                                           de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimestampValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDateValue

        public Date getDateValue​(int p_iIdx)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDateValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDateValue

        public Date getDateValue​(int p_iIdx,
                                 Calendar p_cal)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDateValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDateValue

        public Date getDateValue​(int p_iIdx,
                                 TimeZone p_tz)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDateValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDateValue

        public Date getDateValue​(int p_iIdx,
                                 Date p_valueIfNull)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDateValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDateValue

        public Date getDateValue​(int p_iIdx,
                                 Date p_valueIfNull,
                                 TimeZone p_tz)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDateValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDateValue

        public Date getDateValue​(int p_iIdx,
                                 Date p_valueIfNull,
                                 Calendar p_cal)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getDateValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimeValue

        public Date getTimeValue​(int p_iIdx)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimeValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimeValue

        public Date getTimeValue​(int p_iIdx,
                                 Calendar p_cal)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimeValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimeValue

        public Date getTimeValue​(int p_iIdx,
                                 TimeZone p_tz)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimeValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimeValue

        public Date getTimeValue​(int p_iIdx,
                                 Date p_valueIfNull)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimeValue in interface de.uplanet.lucy.server.util.db.IValueAccess
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimeValue

        public Date getTimeValue​(int p_iIdx,
                                 Date p_valueIfNull,
                                 TimeZone p_tz)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimeValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getTimeValue

        public Date getTimeValue​(int p_iIdx,
                                 Date p_valueIfNull,
                                 Calendar p_cal)
                          throws SQLException,
                                 de.uplanet.lucy.server.util.db.ValueCastException
        Specified by:
        getTimeValue in interface de.uplanet.lucy.server.util.db.IDbResultSet
        Throws:
        SQLException
        de.uplanet.lucy.server.util.db.ValueCastException
      • getDisconnectedRowList

        public de.uplanet.lucy.server.util.db.DbRowList getDisconnectedRowList()
        Create a list of disconnected rows from this result set.

        Note:

        • The result set data are at once fetched into memory so that calling this method may result in excessive memory consumption.
        • After this method has been called, subsequent iterations over this result set will give no result. However anew call to this method will return the previous returned rows.
        • Rows that were consumed in previous iterations over this result set will not be present in this list.
        Returns:
        A list of disconnected rows.
      • findAll

        public List<?> findAll​(groovy.lang.Closure<?> p_closure)
        Calls the given closure for every row in the result set and returns a list of rows for which the closure is valid.
        Parameters:
        p_closure - The closure that's being called.
        Returns:
        A list of rows the closure is valid for.
        Throws:
        UnsupportedOperationException - - If the result set does not provide disconnected rows.