List of clearForNewSQL() Examples

Examples of clearForNewSQL()

edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()
With the exception of the (optional) connection, clear out all of this object's data in preparation for a new SQL statement.

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

      } else if (parentType == ContentType.COLLECTION) {
        sql.append("insert into bundle2collection ");
        sql.append("(bundle_id, collection_id) values (?, ?) ");
      }


      qp.clearForNewSQL();
      qp.setSql(sql.toString());
      qp.addPreparedStmtElementDefinition(childId);
      qp.addPreparedStmtElementDefinition(parentId);


      Configuration.getConnectionPool().executeInsertOrUpdate(qp);

View Full Code Here

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

    if (preInsertCheck == 0) {
      sql = new StringBuffer();
      sql.append("insert into community2community ");
      sql.append("(child_id, parent_id) values (?, ?) ");


      qp.clearForNewSQL();
      qp.setSql(sql.toString());
      qp.addPreparedStmtElementDefinition(childId);
      qp.addPreparedStmtElementDefinition(parentId);


      Configuration.getConnectionPool().executeInsertOrUpdate(qp);

View Full Code Here

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

      } else if (parentType == ContentType.COLLECTION) {
        sql.append("insert into collection2collection ");
        sql.append("(child_id, parent_id) values (?, ?) ");
      }


      qp.clearForNewSQL();
      qp.setSql(sql.toString());
      qp.addPreparedStmtElementDefinition(childId);
      qp.addPreparedStmtElementDefinition(parentId);


      Configuration.getConnectionPool().executeInsertOrUpdate(qp);

View Full Code Here

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

      Logger.fatal("Couldn't execute query", e1);
      return null;
    }


    if (qp.getResultCount() == 0) {
      qp.clearForNewSQL();
      sql = null;
      sql = new StringBuffer();
      sql.append("select count(*) as theCount ");
      sql.append("from users ");
      sql.append("where user_name=? ");

View Full Code Here

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

      } else if (parentType == ContentType.BUNDLE) {
        sql.append("insert into item2bundle ");
        sql.append("(item_id, bundle_id) values (?, ?) ");
      }


      qp.clearForNewSQL();
      qp.setSql(sql.toString());
      qp.addPreparedStmtElementDefinition(childId);
      qp.addPreparedStmtElementDefinition(parentId);


      Configuration.getConnectionPool().executeInsertOrUpdate(qp);

View Full Code Here

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

      sql.append("set display_order=display_order-1 ");
      sql.append("where project_id=? ");
      sql.append("and content_type=? ");
      sql.append("and display_order>? ");


      qp.clearForNewSQL();
      qp.setSql(sql.toString());
      qp.addPreparedStmtElementDefinition(meta.getProjectId());
      qp.addPreparedStmtElementDefinition(meta.getContentType());
      qp.addPreparedStmtElementDefinition(currentDisplayOrder);

View Full Code Here

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

      sql = new StringBuffer();
      sql.append("update metadata_registry ");
      sql.append("set display_order=? ");
      sql.append("where metadata_id=? ");


      qp.clearForNewSQL();
      qp.setSql(sql.toString());
      qp.addPreparedStmtElementDefinition(moveTo);
      qp.addPreparedStmtElementDefinition(meta.getMetadataId());


      Configuration.getConnectionPool().executeInsertOrUpdate(qp);

View Full Code Here

Examples of edu.uga.galileo.voci.db.QueryParser.clearForNewSQL()

        throw new NoSuchMetadataException(
            "No matching row was found to update");
      } else {
        // if that worked, then set the rest of the fields for
        // this projectId+contentType combination to false
        qp.clearForNewSQL();


        sql = new StringBuffer();
        sql.append("update metadata_registry ");
        sql.append("set is_key_field=false ");
        sql.append("where project_id=");

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.