Examples of javax.jdo.Query.declareParameters()

javax.jdo.Query.declareParameters()
Declare the list of parameters query execution. The parameter declaration is a String containing one or more query parameter declarations separated with commas. Each parameter named in the parameter declaration must be bound to a value when the query is executed.
The String parameter to this method follows the syntax for formal parameters in the Java language. @param parameters the list of parameters separated by commas.

      LOG.debug("Executing listMIndexes");
      dbName = dbName.toLowerCase().trim();
      origTableName = origTableName.toLowerCase().trim();
      Query query = pm.newQuery(MIndex.class,
          "origTable.tableName == t1 && origTable.database.name == t2");
      query.declareParameters("java.lang.String t1, java.lang.String t2");
      mindexes = (List<MIndex>) query.execute(origTableName, dbName);
      LOG.debug("Done executing query for listMIndexes");
      pm.retrieveAll(mindexes);
      success = commitTransaction();
      LOG.debug("Done retrieving all objects for listMIndexes");

View Full Code Here

      origTableName = origTableName.toLowerCase().trim();
      Query q = pm.newQuery(
          "select indexName from org.apache.hadoop.hive.metastore.model.MIndex "
          + "where origTable.database.name == t1 && origTable.tableName == t2 "
          + "order by indexName asc");
      q.declareParameters("java.lang.String t1, java.lang.String t2");
      q.setResult("indexName");
      Collection names = (Collection) q.execute(dbName, origTableName);
      pns = new ArrayList<String>();
      for (Iterator i = names.iterator(); i.hasNext();) {
        pns.add((String) i.next());

View Full Code Here

    MRoleMap mRoleMember = null;
    boolean commited = false;
    try {
      openTransaction();
      Query query = pm.newQuery(MRoleMap.class, "principalName == t1 && principalType == t2 && role.roleName == t3");
      query.declareParameters("java.lang.String t1, java.lang.String t2, java.lang.String t3");
      query.setUnique(true);
      mRoleMember = (MRoleMap) query.executeWithArray(userName, principalType.toString(), roleName);
      pm.retrieve(mRoleMember);
      commited = commitTransaction();
    } finally {

View Full Code Here

      LOG.debug("Executing listRoles");
      Query query = pm
          .newQuery(
              MRoleMap.class,
              "principalName == t1 && principalType == t2");
      query
          .declareParameters("java.lang.String t1, java.lang.String t2");
      query.setUnique(false);
      mRoleMember = (List<MRoleMap>) query.executeWithArray(
          principalName, principalType.toString());
      LOG.debug("Done executing query for listMSecurityUserRoleMap");

View Full Code Here

    try {
      openTransaction();
      LOG.debug("Executing listMSecurityPrincipalMembershipRole");
      Query query = pm.newQuery(MRoleMap.class,
          "principalName == t1 && principalType == t2");
      query
          .declareParameters("java.lang.String t1, java.lang.String t2");
      mRoleMemebership = (List<MRoleMap>) query.execute(roleName, principalType.toString());
      LOG
          .debug("Done executing query for listMSecurityPrincipalMembershipRole");
      pm.retrieveAll(mRoleMemebership);

View Full Code Here

    MRole mrole = null;
    boolean commited = false;
    try {
      openTransaction();
      Query query = pm.newQuery(MRole.class, "roleName == t1");
      query.declareParameters("java.lang.String t1");
      query.setUnique(true);
      mrole = (MRole) query.execute(roleName);
      pm.retrieve(mrole);
      commited = commitTransaction();
    } finally {

View Full Code Here

    boolean commited = false;
    try {
      openTransaction();
      name = name.toLowerCase().trim();
      Query query = pm.newQuery(MDatabase.class, "name == dbname");
      query.declareParameters("java.lang.String dbname");
      query.setUnique(true);
      mdb = (MDatabase) query.execute(name);
      pm.retrieve(mdb);
      commited = commitTransaction();
    } finally {

View Full Code Here

  {
    try
    {
      Query q = PMF.getPersistenceManager().newQuery(Class.forName(model));
      q.setFilter(filter);
      q.declareParameters(params);
      if (order != null && !order.trim().equals(""))
        q.setOrdering(order);


      return (Collection<Object>)q.executeWithMap(parVal);
    }

View Full Code Here

    query.declareImports("import com.google.appengine.api.datastore.Key");
    
    if (ignoreKey == null)
    {
      query.setFilter("name == nameParam");
      query.declareParameters("String nameParam");
      return querySingleDetachAndClose(Organisation.class, query, false, orgName);      
    } else {  
      query.setFilter("name == nameParam && key != ignoreKeyParam");
      query.declareParameters("String nameParam, Key ignoreKeyParam");
      return querySingleDetachAndClose(Organisation.class, query, false, orgName, ignoreKey);

View Full Code Here

      query.setFilter("name == nameParam");
      query.declareParameters("String nameParam");
      return querySingleDetachAndClose(Organisation.class, query, false, orgName);      
    } else {  
      query.setFilter("name == nameParam && key != ignoreKeyParam");
      query.declareParameters("String nameParam, Key ignoreKeyParam");
      return querySingleDetachAndClose(Organisation.class, query, false, orgName, ignoreKey);
    }
  }
  
  public static Organisation orgByKey (Key orgKey)

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.