Examples of de.danet.an.util.UniversalPrepStmt.executeQuery()

Class de.danet.an.util.UniversalPrepStmt

Examples of de.danet.an.util.UniversalPrepStmt.executeQuery()

de.danet.an.util.UniversalPrepStmt.executeQuery()
Calls the executeQuery method on the delegee prepared statement. Throws a UnsupportedOperationException if no delegee is available. @param string a String value. @return a ResultSet value. @throws SQLException if an error occurs. @see java.sql.PreparedStatement#executeQuery

            if (hasParameters()) {
                PreparedStatement ps 
        = new UniversalPrepStmt (conn, sqlStatement);
                statement = ps;
                setParameters(ps);
                rs = ps.executeQuery();
            } else {
                statement = conn.createStatement();
                rs = statement.executeQuery(sqlStatement);
            }

View Full Code Here

      // select
      offset = 1;
      prepStmt = new UniversalPrepStmt
    (con, "SELECT Header, Xpdl FROM ProcessDefinition " 
     + "WHERE DBId = 1000000");
      ResultSet rs = prepStmt.executeQuery();
      rs.next();
      if (!isOracle) {
    return;
      }
      Object blobObject = JDBCUtil.getBinary(rs, offset++);

View Full Code Here

    prepStmt = new UniversalPrepStmt
        (ds, con, "SELECT ActivityKey, ProcessKey, ProcessMgr, "
         + "ResourceKey, AssignedAt, InstData "
         + "FROM SimpleAppl WHERE DBId = ?");
    prepStmt.setLong (1, instId);
    rs = prepStmt.executeQuery();
    if (! rs.next()) {
        throw new InvalidKeyException 
      ("No application instance with key = " + instId);
    }
    String actKey = rs.getString (1);

View Full Code Here

         + "FROM SimpleAppl WHERE ActivityKey = ? "
         + "AND ProcessKey = ? AND ProcessMgr = ?");
    prepStmt.setString (1, auk.activityKey());
    prepStmt.setString (2, auk.processKey());
    prepStmt.setString (3, auk.managerName());
    rs = prepStmt.executeQuery();
    if (! rs.next()) {
        throw new InvalidKeyException 
      ("No application instance for activity = " + auk);
    }
    long instId = rs.getLong(1);

View Full Code Here

                prepStmt = new UniversalPrepStmt
                    (ds, con, "SELECT DBId, ActivityKey, ProcessKey, "
                     + "ProcessMgr, ResourceKey, AssignedAt, InstData "
                     + "FROM SimpleAppl WHERE ApplName = ? ");
                prepStmt.setString (1, applName);
                rs = prepStmt.executeQuery();
                while (rs.next()) {
                    int pos = 1;
                    long instId = rs.getLong(pos++);
                    String actKey = rs.getString(pos++);
                    String procKey = rs.getString(pos++);

View Full Code Here

                    (ds, con, "SELECT DBId, ActivityKey, ProcessKey, "
                     + "ProcessMgr, ResourceKey, AssignedAt, InstData "
                     + "FROM SimpleAppl WHERE ApplName = ? AND InstKey = ?");
                prepStmt.setString (1, applName);
                prepStmt.setString (2, applInstKey);
                rs = prepStmt.executeQuery();
                while (rs.next()) {
                    int pos = 1;
                    long instId = rs.getLong(pos++);
                    String actKey = rs.getString(pos++);
                    String procKey = rs.getString(pos++);

View Full Code Here

                     + "ProcessMgr, AssignedAt, InstData "
                     + "FROM SimpleAppl "
                     + "WHERE ApplName = ? AND ResourceKey = ? ");
                prepStmt.setString (1, applName);
                prepStmt.setString (2, resourceKey);
                rs = prepStmt.executeQuery();
                while (rs.next()) {
                    int pos = 1;
                    long instId = rs.getLong(pos++);
                    String actKey = rs.getString(pos++);
                    String procKey = rs.getString(pos++);

View Full Code Here

                prepStmt = new UniversalPrepStmt
                    (ds, con, "SELECT XPDL FROM PROCESSDEFINITION "
                     + "WHERE PACKAGEID = ? AND PROCESSID = ?");
                prepStmt.setString(1, packageId);
                prepStmt.setString(2, processId);
                rs = prepStmt.executeQuery();
                if(!rs.next()) {
                    return;
                }
                String xpdl = JDBCUtil.getString(ds, rs, 1);
                if (xpdl == null) {

View Full Code Here

TOP

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.