JoinSyntaxTypes.java :  » Database-ORM » db-ojb » org » apache » ojb » broker » accesslayer » Java Open Source

Java Open Source » Database ORM » db ojb 
db ojb » org » apache » ojb » broker » accesslayer » JoinSyntaxTypes.java
package org.apache.ojb.broker.accesslayer;

/* Copyright 2002-2005 The Apache Software Foundation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */


/**
 * Constants used to denote the type of SQL syntax of JOINs
 *
 * @author <a href="mailto:on@ibis.odessa.ua">Oleg Nitz</a>
 * @version $Id: JoinSyntaxTypes.java,v 1.4.2.1 2005/12/21 22:22:58 tomdz Exp $
 */
public interface JoinSyntaxTypes
{
    /**
     * SQL-92 syntax for joins: <br>
     * SELECT ... FROM A INNER JOIN B ON A.PK=B.FK <br>
     * SELECT ... FROM A LEFT OUTER JOIN B ON A.PK=B.FK <br>
     * Nested joins:<br>
     * SELECT ... FROM A INNER JOIN (B INNER JOIN C ON B.PK=C.FK) ON A.PK=B.FK <br>
     * SELECT ... FROM A LEFT OUTER JOIN (B LEFT OUTER JOIN C ON B.PK=C.FK) ON A.PK=B.FK <br>
     */
    public final byte SQL92_JOIN_SYNTAX = 0;

    /**
     * SQL-92 without parenthesis syntax for joins: <br>
     * SELECT ... FROM A INNER JOIN B ON A.PK=B.FK <br>
     * SELECT ... FROM A LEFT OUTER JOIN B ON A.PK=B.FK <br>
     * Nested joins:<br>
     * SELECT ... FROM A INNER JOIN ON A.PK=B.FK INNER JOIN C ON B.PK=C.FK <br>
     * SELECT ... FROM A LEFT OUTER JOIN ON A.PK=B.FK LEFT OUTER JOIN C ON B.PK=C.FK<br>
     */
    public final byte SQL92_NOPAREN_JOIN_SYNTAX = 1;

    /**
     * Oracle syntax for joins: <br>
     * SELECT ... FROM A, B WHERE A.PK=B.FK <br>
     * SELECT ... FROM A, B WHERE A.PK=B.FK(+) <br>
     */
    public final byte ORACLE_JOIN_SYNTAX = 2;

    /**
     * Sybase ASE syntax for joins: <br>
     * SELECT ... FROM A, B WHERE A.PK=B.FK <br>
     * SELECT ... FROM A, B WHERE A.PK*=B.FK <br>
     */
    public final byte SYBASE_JOIN_SYNTAX = 3;
}

java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.