List of innerJoin() Examples

Examples of innerJoin()

com.mysema.query.jpa.JPQLQuery.innerJoin()
com.mysema.query.jpa.hibernate.HibernateQuery.innerJoin()
org.datanucleus.store.mapped.expression.QueryExpression.innerJoin()
Method to do an inner join to another table, and optionally apply it to any unions for this query. @param expr the left hand expression @param expr2 the right hand expression @param tblExpr the @param equals if the join is applied as filter, if use equals or not equals @param unionQueries whether to apply the inner join in all queries unified by the union clause
org.datanucleus.store.rdbms.sql.SQLStatement.innerJoin()
Method to form an inner join to the specified table using the provided mappings. Will be applied to all unioned statements. @param sourceTable SQLTable for the source (null implies primaryTable) @param sourceMapping Mapping in this table to join from @param target Table to join to @param targetAlias Alias for the target table (if known) @param targetMapping Mapping in the other table to join to (also defines the table to join to) @param discrimValues Any discriminator values to apply for the joined table (null if not) @param tableGrpName Name of the table group for the target (null implies a new group) @return SQLTable for the target
org.jpox.store.mapped.expression.QueryExpression.innerJoin()
Method to do an inner join to another table, and optionally apply it to any unions for this query. @param expr the left hand expression @param expr2 the right hand expression @param tblExpr the @param equals if the join is applied as filter, if use equals or not equals @param unionQueries whether to apply the inner join in all queries unified by the union clause

Examples of com.mysema.query.jpa.JPQLQuery.innerJoin()

        QEmployee employee = QEmployee.employee;
        QUser user = QUser.user;


        JPQLQuery query = query();
        query.from(employee);
        query.innerJoin(employee.user, user);
        query.list(employee);
    }


    @Test
    public void Order() {

View Full Code Here

Examples of com.mysema.query.jpa.hibernate.HibernateQuery.innerJoin()

    @Test
    public void InnerJoin() {
        HibernateQuery hqlQuery = new HibernateQuery();
        QEmployee employee = QEmployee.employee;
        hqlQuery.from(employee);
        hqlQuery.innerJoin(employee.user, QUser.user);
        assertEquals("select employee\nfrom Employee employee\n  inner join employee.user as user", hqlQuery.toString());
    }


}

View Full Code Here

Examples of org.datanucleus.store.mapped.expression.QueryExpression.innerJoin()

                stmt.leftOuterJoin(selectExpression, candidateExpression, candidateTableExpression, true);
            }
            else
            {
                // Do INNER JOIN since we don't allow nulls in the results
                stmt.innerJoin(selectExpression, candidateExpression, candidateTableExpression, true);
            }
            discrimTableExpr = stmt.getTableExpression(candidateTableIdentifier);


            if (hasDiscriminator && selectDiscriminator)
            {

View Full Code Here

Examples of org.datanucleus.store.mapped.expression.QueryExpression.innerJoin()

            {
                stmt.leftOuterJoin(sourceExpr, rootElementExpr, rootElementTblExpr, true);
            }
            else
            {
                stmt.innerJoin(sourceExpr, rootElementExpr, rootElementTblExpr, true);
            }
            targetTableIdentifier = rootElementTblId;


            if (targetElementTable != candidateTable)
            {

View Full Code Here

Examples of org.datanucleus.store.mapped.expression.QueryExpression.innerJoin()

                {
                    stmt.leftOuterJoin(rootElementExpr, targetExpr, tgtElementTblExpr, true);
                }
                else
                {
                    stmt.innerJoin(rootElementExpr, targetExpr, tgtElementTblExpr, true);
                }
                targetTableIdentifier = tgtElementTblId;
            }


            discriminatorMapping = targetElementTable.getDiscriminatorMapping(false);

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.SQLStatement.innerJoin()

            else
            {
                // MAP_TYPE_KEY_IN_VALUE, MAP_TYPE_JOIN
                // Join to join table and select key fields
                JavaTypeMapping keyIdMapping = sqlStmt.getPrimaryTable().getTable().getIdMapping();
                containerSqlTbl = sqlStmt.innerJoin(sqlStmt.getPrimaryTable(), keyIdMapping,
                    containerTable, null, elementMapping, null, null);


                iteratorMappingDef = new StatementClassMapping();
                SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(sqlStmt, iteratorMappingDef,
                    ownerSM.getExecutionContext().getFetchPlan(), sqlStmt.getPrimaryTable(), emd, 0);

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.SQLStatement.innerJoin()

                    stmtGen.setOption(StatementGenerator.OPTION_SELECT_NUCLEUS_TYPE);
                    iteratorMappingDef.setNucleusTypeColumnName(UnionStatementGenerator.NUC_TYPE_COLUMN);
                    sqlStmt = stmtGen.getStatement();


                    JavaTypeMapping keyIdMapping = sqlStmt.getPrimaryTable().getTable().getIdMapping();
                    containerSqlTbl = sqlStmt.innerJoin(sqlStmt.getPrimaryTable(), keyIdMapping,
                        containerTable, null, elementMapping, null, null);


                    SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(sqlStmt, iteratorMappingDef,
                        ownerSM.getExecutionContext().getFetchPlan(), sqlStmt.getPrimaryTable(), emd, 0);
                }

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.SQLStatement.innerJoin()


            if (mapType == MapType.MAP_TYPE_VALUE_IN_KEY)
            {
                // Join to key table and select value fields
                JavaTypeMapping valueIdMapping = sqlStmt.getPrimaryTable().getTable().getIdMapping();
                containerSqlTbl = sqlStmt.innerJoin(sqlStmt.getPrimaryTable(), valueIdMapping,
                    containerTable, null, elementMapping, null, null);


                iteratorMappingDef = new StatementClassMapping();
                SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(sqlStmt, iteratorMappingDef,
                    ownerSM.getExecutionContext().getFetchPlan(), sqlStmt.getPrimaryTable(), emd, 0);

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.SQLStatement.innerJoin()

            }
            else
            {
                // Join to join table and select value fields
                JavaTypeMapping valueIdMapping = sqlStmt.getPrimaryTable().getTable().getIdMapping();
                containerSqlTbl = sqlStmt.innerJoin(sqlStmt.getPrimaryTable(), valueIdMapping,
                    containerTable, null, elementMapping, null, null);


                iteratorMappingDef = new StatementClassMapping();
                SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(sqlStmt, iteratorMappingDef,
                    ownerSM.getExecutionContext().getFetchPlan(), sqlStmt.getPrimaryTable(), emd, 0);

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.SQLStatement.innerJoin()

                    stmtGen.setOption(StatementGenerator.OPTION_SELECT_NUCLEUS_TYPE);
                    iteratorMappingDef.setNucleusTypeColumnName(UnionStatementGenerator.NUC_TYPE_COLUMN);
                    sqlStmt = stmtGen.getStatement();


                    JavaTypeMapping valueIdMapping = sqlStmt.getPrimaryTable().getTable().getIdMapping();
                    containerSqlTbl = sqlStmt.innerJoin(sqlStmt.getPrimaryTable(), valueIdMapping,
                        containerTable, null, elementMapping, null, null);


                    SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(sqlStmt, iteratorMappingDef,
                        ownerSM.getExecutionContext().getFetchPlan(), sqlStmt.getPrimaryTable(), emd, 0);
                }

View Full Code Here

0 1 2

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.