Examples of org.hibernate.SQLQuery.addRoot()

org.hibernate.SQLQuery.addRoot()
Add a new root return mapping, returning a {@link RootReturn} to allow further definition. @param tableAlias The SQL table alias to map to this entity @param entityName The name of the entity. @return The return config object for further control. @since 3.6

    SQLQuery sqlQuery = s.createSQLQuery( sql );
    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 )

View Full Code Here

    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" )
        .addProperty( "name" ).addColumnAlias( "name" );
    sqlQuery.addFetch( "emp", "org", "employments" )
        .addProperty( "key", "employer" )
        .addProperty( "element", "empid" )

View Full Code Here

    Session s = openSession();
    s.beginTransaction();
    s.createSQLQuery( sql ).addEntity( "t", AllTables.class ).list();
    s.createSQLQuery( sql2 ).setResultSetMapping( "all" ).list();
    SQLQuery q = s.createSQLQuery( sql2 );
    q.addRoot( "t", AllTables.class ).addProperty( "tableName", "t_name" ).addProperty( "daysOld", "t_time" );
    q.list();
    s.getTransaction().commit();
    s.close();
  }
  @FailureExpected( jiraKey = "HHH-2225")

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.