Examples of org.apache.empire.db.exceptions.QueryNoResultException

org.apache.empire.db.exceptions.QueryNoResultException

     */
    public final int querySingleInt(DBCommand cmd, Connection conn)
    { 
        Object value = querySingleValue(cmd.getSelect(), cmd.getParamValues(), DataType.INTEGER, conn);
    if (ObjectUtils.isEmpty(value))
      throw new QueryNoResultException(cmd.getSelect());
    return ObjectUtils.getInteger(value);
    }

View Full Code Here

     */
    public final long querySingleLong(DBCommand cmd, Connection conn)
    { 
        Object value = querySingleValue(cmd.getSelect(), cmd.getParamValues(), DataType.INTEGER, conn);
    if (ObjectUtils.isEmpty(value))
      throw new QueryNoResultException(cmd.getSelect());
    return ObjectUtils.getLong(value);
    }

View Full Code Here

     */
    public final String querySingleString(DBCommand cmd, Connection conn)
    { 
        Object value = querySingleValue(cmd.getSelect(), cmd.getParamValues(), DataType.TEXT, conn);
    if (value==ObjectUtils.NO_VALUE)
      throw new QueryNoResultException(cmd.getSelect());
    return StringUtils.toString(value, "");
    }

View Full Code Here

    public Object[] querySingleRow(String sqlCmd, Object[] sqlParams, Connection conn)
    {
        List<Object[]> result = new ArrayList<Object[]>();
        queryObjectList(sqlCmd, sqlParams, conn, result, 1);
        if (result.size()<1)
            throw new QueryNoResultException(sqlCmd);
        return result.get(0);
    }

View Full Code Here

        String sqlCmd = cmd.getSelect();
        // Create Statement
        db = cmd.getDatabase();
        rset = db.executeQuery(sqlCmd, cmd.getParamValues(), scrollable, conn);
        if (rset==null)
            throw new QueryNoResultException(sqlCmd);
        // successfully opened
        colList = cmd.getSelectExprList();
        addOpenResultSet();
    }

View Full Code Here

    { // Open the record
        open(cmd, conn);
        // Get First Record
        if (!moveNext())
        { // Close
            throw new QueryNoResultException(cmd.getSelect());
        }
    }

View Full Code Here

                throw new UnexpectedReturnValueException(rs, "driver.executeQuery()");
            // Check Result
            if (rs.next() == false)
            {   // no result
                log.debug("querySingleValue returned no result");
                throw new QueryNoResultException(sqlCmd);
            }
            // Read value
            Object result = driver.getResultValue(rs, 1, dataType);
            // Debug
            long queryTime = (System.currentTimeMillis() - start);

View Full Code Here

    public Object[] querySingleRow(String sqlCmd, Object[] sqlParams, Connection conn)
    {
        List<Object[]> result = new ArrayList<Object[]>();
        queryObjectList(sqlCmd, sqlParams, conn, result, 1);
        if (result.size()<1)
            throw new QueryNoResultException(sqlCmd);
        return result.get(0);
    }

View Full Code Here

                throw new UnexpectedReturnValueException(rs, "driver.executeQuery()");
            // Check Result
            if (rs.next() == false)
            {   // no result
                log.debug("querySingleValue returned no result");
                throw new QueryNoResultException(sqlCmd);
            }
            // Read value
            Object result = driver.getResultValue(rs, 1, dataType);
            // Debug
            long queryTime = (System.currentTimeMillis() - start);

View Full Code Here

    public Object[] querySingleRow(String sqlCmd, Object[] sqlParams, Connection conn)
    {
        List<Object[]> result = new ArrayList<Object[]>();
        queryObjectList(sqlCmd, sqlParams, conn, result, 1);
        if (result.size()<1)
            throw new QueryNoResultException(sqlCmd);
        return result.get(0);
    }

View Full Code Here

0 1 2

TOP

Related Classes of org.apache.empire.db.exceptions.QueryNoResultException

org.apache.empire.db.DBDatabase

org.apache.empire.db.DBReader

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.