Examples of oracle.toplink.essentials.queryframework.ValueReadQuery

Package oracle.toplink.essentials.queryframework

Examples of oracle.toplink.essentials.queryframework.ValueReadQuery

oracle.toplink.essentials.queryframework.ValueReadQuery

Purpose: Concrete class to perform a read of a single data value.

Responsibilities: Used in conjunction with CursoredStream size and Platform getSequence. This can be used to read a single data value (i.e. one field). A single data value is returned, or null if no rows are returned. @author James Sutherland @since TOPLink/Java 1.2

  public boolean shouldNativeSequenceAcquireValueAfterInsert() {
    return true;
  }


  public ValueReadQuery buildSelectQueryForNativeSequence() {
    return new ValueReadQuery("CALL IDENTITY()");
  }

View Full Code Here

     * This method returns the query to select the timestamp from the server
     * for Derby.
     */
    public ValueReadQuery getTimestampQuery() {
        if (timestampQuery == null) {
            timestampQuery = new ValueReadQuery();
            timestampQuery.setSQLString("SELECT NOW()");
        }
        return timestampQuery;


    }

View Full Code Here

     * the returned query used until the sequence is disconnected.
     * If the platform supportsIdentity then (at least) one of buildSelectQueryForIdentity
     * methods should return non-null query.
     */
    public ValueReadQuery buildSelectQueryForIdentity() {
        ValueReadQuery selectQuery = new ValueReadQuery(); 
        selectQuery.setSQLString("select lastval()"); 
        return selectQuery;
    }

View Full Code Here

     * the returned query used until the sequence is disconnected.
     * If the platform supportsSequenceObjects then (at least) one of buildSelectQueryForSequenceObject
     * methods should return non-null query.
     */
    public ValueReadQuery buildSelectQueryForSequenceObject(String seqName, Integer size) {
        return new ValueReadQuery("select nextval(\'"  + getQualifiedSequenceName(seqName) + "\')");
    }

View Full Code Here

    return fieldTypeMapping;
  }


  @Override
    public final ValueReadQuery buildSelectQueryForIdentity() {
    return new ValueReadQuery("SELECT @@identity");
  }

View Full Code Here

     * This method returns the query to select the timestamp from the server
     * for Derby.
     */
    public ValueReadQuery getTimestampQuery() {
        if (timestampQuery == null) {
            timestampQuery = new ValueReadQuery();
            timestampQuery.setSQLString("VALUES CURRENT_TIMESTAMP");
        }
        return timestampQuery;


    }

View Full Code Here

    /**
     * INTERNAL:
     * Build the identity query for native sequencing.
     */
    public ValueReadQuery buildSelectQueryForIdentity() {
        ValueReadQuery selectQuery = new ValueReadQuery();
        selectQuery.setSQLString("values IDENTITY_VAL_LOCAL()");
        return selectQuery;
    }

View Full Code Here

     *    Produce a DataReadQuery which updates(!) the sequence number in the db
     *  and returns it. 
     *    @param sequenceName        Name known by TimesTen to be a defined sequence
     */
    public ValueReadQuery buildSelectQueryForSequenceObject(String seqName, Integer size) {
        return new ValueReadQuery("SELECT " + getQualifiedSequenceName(seqName) + ".NEXTVAL FROM DUAL");
    }

View Full Code Here

     * This method returns the query to select the timestamp
     * from the server for TimesTen.
     */
    public ValueReadQuery getTimestampQuery() {
        if (timestampQuery == null) {
            timestampQuery = new ValueReadQuery();
            timestampQuery.setSQLString("SELECT SYSDATE FROM DUAL");
        }
        return timestampQuery;
    }

View Full Code Here

    /**
     * INTERNAL:
     * Build the identity query for native sequencing.
     */
    public ValueReadQuery buildSelectQueryForIdentity() {
        ValueReadQuery selectQuery = new ValueReadQuery();
        StringWriter writer = new StringWriter();
        writer.write("SELECT LAST_INSERT_ID()");
        selectQuery.setSQLString(writer.toString());
        return selectQuery;
    }

View Full Code Here

0 1

TOP

Related Classes of oracle.toplink.essentials.queryframework.ValueReadQuery

net.sf.jpacriteria.TopLinkHsqlPlatform

oracle.toplink.essentials.platform.database.DerbyPlatform

oracle.toplink.essentials.platform.database.MySQL4Platform

oracle.toplink.essentials.platform.database.PostgreSQLPlatform

oracle.toplink.essentials.platform.database.SQLAnyWherePlatform

oracle.toplink.essentials.platform.database.TimesTenPlatform

org.springframework.samples.petclinic.toplink.EssentialsHSQLPlatformWithNativeSequence

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.