Examples of SQLCall

oracle.toplink.essentials.queryframework.SQLCall
Purpose: Used as an abstraction of an SQL call. A call is an SQL string with parameters.
org.eclipse.persistence.queries.SQLCall
Purpose: Used as an abstraction of an SQL call. A call is an SQL string with parameters.
org.eigenbase.sql.SqlCall
A SqlCall is a call to an {@link SqlOperator operator}. (Operators can be used to describe any syntactic construct, so in practice, every non-leaf node in a SQL parse tree is a SqlCall of some kind.)

Examples of org.eclipse.persistence.queries.SQLCall

        if ((!session.getPlatform().supportsForeignKeyConstraints()) || getForeignKeyMap().isEmpty()) {
            return;
        }


        for (ForeignKeyConstraint foreignKey : getForeignKeyMap().values()) {
            session.executeNonSelectingCall(new SQLCall(buildConstraintCreationWriter(session, foreignKey, new StringWriter()).toString()));
        }
    }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

            return;
        }
        
        for (UniqueKeyConstraint uniqueKey : getUniqueKeys()) {
            try {
                session.executeNonSelectingCall(new SQLCall(buildUniqueConstraintDeletionWriter(session, uniqueKey, new StringWriter()).toString()));
            } catch (DatabaseException ex) {/* ignore */
            }
        }        
    }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

            return;
        }


        for (ForeignKeyConstraint foreignKey : getForeignKeyMap().values()) {
            try {
                session.executeNonSelectingCall(new SQLCall(buildConstraintDeletionWriter(session, foreignKey, new StringWriter()).toString()));
            } catch (DatabaseException ex) {/* ignore */
            }
        }
    }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

    /**
     * INTERNAL:
     * Returns null unless the platform supports call with returning
     */
    public DatabaseCall buildCallWithReturning(SQLCall sqlCall, Vector returnFields) {
        SQLCall call = new SQLCall();
        call.setParameters(sqlCall.getParameters());
        call.setParameterTypes(sqlCall.getParameterTypes());


        Writer writer = new CharArrayWriter(200);
        try {
            writer.write("BEGIN ");
            writer.write(sqlCall.getSQLString());
            writer.write(" RETURNING ");


            for (int i = 0; i < returnFields.size(); i++) {
                DatabaseField field = (DatabaseField)returnFields.elementAt(i);
                writer.write(field.getNameDelimited(this));
                if ((i + 1) < returnFields.size()) {
                    writer.write(", ");
                }
            }


            writer.write(" INTO ");


            for (int i = 0; i < returnFields.size(); i++) {
                DatabaseField field = (DatabaseField)returnFields.elementAt(i);
                call.appendOut(writer, field);
                if ((i + 1) < returnFields.size()) {
                    writer.write(", ");
                }
            }


            writer.write("; END;");


            call.setQueryString(writer.toString());


        } catch (IOException exception) {
            throw ValidationException.fileError(exception);
        }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

                query = query + " AND OWNER LIKE " + creator;
            } else {
                query = query + " AND OWNER = " + creator;
            }
        }
        return session.executeSelectingCall(new SQLCall(query));
    }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

    /**
     * INTERNAL:
     * Uses the returning clause on Postgres.
     */
    public DatabaseCall buildCallWithReturning(SQLCall sqlCall, Vector returnFields) {
        SQLCall call = new SQLCall();
        call.setParameters(sqlCall.getParameters());
        call.setParameterTypes(sqlCall.getParameterTypes());
        call.returnOneRow();
        Writer writer = new CharArrayWriter(sqlCall.getSQLString().length() + 32);
        try {
            writer.write(sqlCall.getSQLString());
            writer.write(" RETURNING ");
            for (int i = 0; i < returnFields.size(); i++) {
                DatabaseField field = (DatabaseField)returnFields.elementAt(i);
                writer.write(field.getNameDelimited(this));
                if ((i + 1) < returnFields.size()) {
                    writer.write(", ");
                }
            }
            call.setQueryString(writer.toString());
        } catch (IOException exception) {
            throw ValidationException.fileError(exception);
        }
        return call;
    }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall


        for (String string : keySet) {
          String currentSQL = (String) string;
          String sqlQuery = resourceBundleArr[i].getString(currentSQL);
          System.out.println("Executing Query - " + sqlQuery);
          SQLCall sqlCall = new SQLCall(sqlQuery);


          DataModifyQuery query = new DataModifyQuery();
          query.setCall(sqlCall);
          session.executeQuery(query);
        }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

    if (deleteStatements.length > 0) { // If configuration is proper with at least one delete Statements
      Session session = ((EntityManagerImpl) entityManager).getActiveSession();
      entityManager.getTransaction().begin();
      for (String deleteStatement : deleteStatements) {
        System.out.println("Cleaning - " + deleteStatement);
        SQLCall sqlCall = new SQLCall(deleteStatement);


        DataModifyQuery query = new DataModifyQuery();
        query.setCall(sqlCall);
        session.executeQuery(query);
      }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

    public void setTable(DatabaseTable table) {
        this.table = table;
    }


    public DatabaseCall buildCall(AbstractSession session) {
        SQLCall sqlCall = buildCallWithoutReturning(session);
        if ((getReturnFields() == null) || getReturnFields().isEmpty()) {
            return sqlCall;
        } else {
            return session.getPlatform().buildCallWithReturning(sqlCall, getReturnFields());
        }

View Full Code Here

Examples of org.eclipse.persistence.queries.SQLCall

     * {@inheritDoc}
     */
    @Override
    public void initializeCall(XRServiceAdapter xrService, QueryOperation queryOperation,
        DatabaseQuery databaseQuery) {
        databaseQuery.setCall(new SQLCall(getSqlString()));
    }

View Full Code Here

0 1 2 3 4 5

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.