Examples of QueryNoResultException

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

410
411
412
413
414
415
416
417
418
419
        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

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

448
449
450
451
452
453
454
455
    { // Open the record
        open(cmd, conn);
        // Get First Record
        if (!moveNext())
        { // Close
            throw new QueryNoResultException(cmd.getSelect());
        }
    }
View Full Code Here

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

806
807
808
809
810
811
812
813
     */
    public final Object querySingleValue(String sqlCmd, Object[] sqlParams, Connection conn)
    {
        Object value = querySingleValue(sqlCmd, sqlParams, DataType.UNKNOWN, conn);
        if (value==ObjectUtils.NO_VALUE)
          throw new QueryNoResultException(sqlCmd);
        return value;
    }
View Full Code Here

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

824
825
826
827
828
829
830
831
     */
    public final Object querySingleValue(DBCommand cmd, DataType dataType, Connection conn)
    {
        Object value = querySingleValue(cmd.getSelect(), cmd.getParamValues(), dataType, conn);
        if (value==ObjectUtils.NO_VALUE)
          throw new QueryNoResultException(cmd.getSelect());
        return value;
    }
View Full Code Here

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

887
888
889
890
891
892
893
894
     */
    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

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

936
937
938
939
940
941
942
943
     */
    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

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

986
987
988
989
990
991
992
993
     */
    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

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

1267
1268
1269
1270
1271
1272
1273
1274
    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

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

806
807
808
809
810
811
812
813
     */
    public final Object querySingleValue(String sqlCmd, Object[] sqlParams, Connection conn)
    {
        Object value = querySingleValue(sqlCmd, sqlParams, DataType.UNKNOWN, conn);
        if (value==ObjectUtils.NO_VALUE)
          throw new QueryNoResultException(sqlCmd);
        return value;
    }
View Full Code Here

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

824
825
826
827
828
829
830
831
     */
    public final Object querySingleValue(DBCommand cmd, DataType dataType, Connection conn)
    {
        Object value = querySingleValue(cmd.getSelect(), cmd.getParamValues(), dataType, conn);
        if (value==ObjectUtils.NO_VALUE)
          throw new QueryNoResultException(cmd.getSelect());
        return value;
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.