Examples of org.hibernate.SQLQuery.addFetch()

org.hibernate.SQLQuery.addFetch()
Declare a join fetch result. @param tableAlias The SQL table alias for the data to be mapped to this fetch @param ownerTableAlias Identify the table alias of the owner of this association. Should match the alias of apreviously added root or fetch @param joinPropertyName The name of the property being join fetched. @return The return config object for further control. @since 3.6

    sqlQuery.setResultSetMapping( "org-description" );
    sqlQuery.list();


    // next try a partial mapping def
    sqlQuery.addRoot( "org", Organization.class );
    sqlQuery.addFetch( "emp", "org", "employments" );
    sqlQuery.list();


    // now try full explicit mappings
    sqlQuery.addRoot( "org", Organization.class )
        .addProperty( "id", "orgid" )

View Full Code Here


    // now try full explicit mappings
    sqlQuery.addRoot( "org", Organization.class )
        .addProperty( "id", "orgid" )
        .addProperty( "name" ).addColumnAlias( "name" );
    sqlQuery.addFetch( "emp", "org", "employments" )
        .addProperty( "key", "employer" )
        .addProperty( "element", "empid" )
        .addProperty( "element.employee", "employee" )
        .addProperty( "element.employer", "employer" )
        .addProperty( "element.startDate", "startDate" )

View Full Code Here

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.