Java Code Examples for org.hibernate.sql.Select#setOrderByClause()

The following examples show how to use org.hibernate.sql.Select#setOrderByClause() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: BasicCollectionJoinWalker.java From lams with GNU General Public License v2.0

4 votes

private void initStatementString(
	final String alias,
	final int batchSize,
	final String subquery) throws MappingException {

	final int joins = countEntityPersisters( associations );
	final int collectionJoins = countCollectionPersisters( associations ) + 1;

	suffixes = BasicLoader.generateSuffixes( joins );
	collectionSuffixes = BasicLoader.generateSuffixes( joins, collectionJoins );

	StringBuilder whereString = whereString(
			alias, 
			collectionPersister.getKeyColumnNames(), 
			subquery,
			batchSize
		);

	String manyToManyOrderBy = "";
	String filter = collectionPersister.filterFragment( alias, getLoadQueryInfluencers().getEnabledFilters() );
	if ( collectionPersister.isManyToMany() ) {
		// from the collection of associations, locate OJA for the
		// ManyToOne corresponding to this persister to fully
		// define the many-to-many; we need that OJA so that we can
		// use its alias here
		// TODO : is there a better way here?
		Iterator itr = associations.iterator();
		AssociationType associationType = ( AssociationType ) collectionPersister.getElementType();
		while ( itr.hasNext() ) {
			OuterJoinableAssociation oja = ( OuterJoinableAssociation ) itr.next();
			if ( oja.getJoinableType() == associationType ) {
				// we found it
				filter += collectionPersister.getManyToManyFilterFragment( 
						oja.getRHSAlias(), 
						getLoadQueryInfluencers().getEnabledFilters() 
					);
				manyToManyOrderBy += collectionPersister.getManyToManyOrderByString( oja.getRHSAlias() );
			}
		}
	}
	whereString.insert( 0, StringHelper.moveAndToBeginning( filter ) );

	JoinFragment ojf = mergeOuterJoins(associations);
	Select select = new Select( getDialect() )
		.setSelectClause(
			collectionPersister.selectFragment(alias, collectionSuffixes[0] ) +
			selectString(associations)
		)
		.setFromClause( collectionPersister.getTableName(), alias )
		.setWhereClause( whereString.toString()	)
		.setOuterJoins(
			ojf.toFromFragmentString(),
			ojf.toWhereFragmentString()
		);

	select.setOrderByClause( orderBy( associations, mergeOrderings( collectionPersister.getSQLOrderByString(alias), manyToManyOrderBy ) ) );

	if ( getFactory().getSettings().isCommentsEnabled() ) {
		select.setComment( "load collection " + collectionPersister.getRole() );
	}

	sql = select.toStatementString();
}

Example 2

Source File: OneToManyJoinWalker.java From lams with GNU General Public License v2.0

4 votes

private void initStatementString(
		final OuterJoinLoadable elementPersister,
		final String alias,
		final int batchSize,
		final String subquery)
		throws MappingException {

	final int joins = countEntityPersisters( associations );
	suffixes = BasicLoader.generateSuffixes( joins + 1 );

	final int collectionJoins = countCollectionPersisters( associations ) + 1;
	collectionSuffixes = BasicLoader.generateSuffixes( joins + 1, collectionJoins );

	StringBuilder whereString = whereString(
			alias,
			oneToManyPersister.getKeyColumnNames(),
			subquery,
			batchSize
	);
	String filter = oneToManyPersister.filterFragment( alias, getLoadQueryInfluencers().getEnabledFilters() );
	whereString.insert( 0, StringHelper.moveAndToBeginning( filter ) );

	JoinFragment ojf = mergeOuterJoins( associations );
	Select select = new Select( getDialect() )
			.setSelectClause(
					oneToManyPersister.selectFragment(
							null,
							null,
							alias,
							suffixes[joins],
							collectionSuffixes[0],
							true
					) +
							selectString( associations )
			)
			.setFromClause(
					elementPersister.fromTableFragment( alias ) +
							elementPersister.fromJoinFragment( alias, true, true )
			)
			.setWhereClause( whereString.toString() )
			.setOuterJoins(
					ojf.toFromFragmentString(),
					ojf.toWhereFragmentString() +
							elementPersister.whereJoinFragment( alias, true, true )
			);

	select.setOrderByClause( orderBy( associations, oneToManyPersister.getSQLOrderByString( alias ) ) );

	if ( getFactory().getSessionFactoryOptions().isCommentsEnabled() ) {
		select.setComment( "load one-to-many " + oneToManyPersister.getRole() );
	}

	sql = select.toStatementString();
}

Example 3

Source File: BasicCollectionJoinWalker.java From cacheonix-core with GNU Lesser General Public License v2.1

4 votes

private void initStatementString(
	final String alias,
	final int batchSize,
	final String subquery)
throws MappingException {

	final int joins = countEntityPersisters( associations );
	final int collectionJoins = countCollectionPersisters( associations ) + 1;

	suffixes = BasicLoader.generateSuffixes( joins );
	collectionSuffixes = BasicLoader.generateSuffixes( joins, collectionJoins );

	StringBuffer whereString = whereString(
			alias, 
			collectionPersister.getKeyColumnNames(), 
			subquery,
			batchSize
		);

	String manyToManyOrderBy = "";
	String filter = collectionPersister.filterFragment( alias, getEnabledFilters() );
	if ( collectionPersister.isManyToMany() ) {
		// from the collection of associations, locate OJA for the
		// ManyToOne corresponding to this persister to fully
		// define the many-to-many; we need that OJA so that we can
		// use its alias here
		// TODO : is there a better way here?
		Iterator itr = associations.iterator();
		AssociationType associationType = ( AssociationType ) collectionPersister.getElementType();
		while ( itr.hasNext() ) {
			OuterJoinableAssociation oja = ( OuterJoinableAssociation ) itr.next();
			if ( oja.getJoinableType() == associationType ) {
				// we found it
				filter += collectionPersister.getManyToManyFilterFragment( 
						oja.getRHSAlias(), 
						getEnabledFilters() 
					);
					manyToManyOrderBy += collectionPersister.getManyToManyOrderByString( oja.getRHSAlias() );
			}
		}
	}
	whereString.insert( 0, StringHelper.moveAndToBeginning( filter ) );

	JoinFragment ojf = mergeOuterJoins(associations);
	Select select = new Select( getDialect() )
		.setSelectClause(
			collectionPersister.selectFragment(alias, collectionSuffixes[0] ) +
			selectString(associations)
		)
		.setFromClause( collectionPersister.getTableName(), alias )
		.setWhereClause( whereString.toString()	)
		.setOuterJoins(
			ojf.toFromFragmentString(),
			ojf.toWhereFragmentString()
		);

	select.setOrderByClause( orderBy( associations, mergeOrderings( collectionPersister.getSQLOrderByString(alias), manyToManyOrderBy ) ) );

	if ( getFactory().getSettings().isCommentsEnabled() ) {
		select.setComment( "load collection " + collectionPersister.getRole() );
	}

	sql = select.toStatementString();
}

Example 4

Source File: OneToManyJoinWalker.java From cacheonix-core with GNU Lesser General Public License v2.1

4 votes

private void initStatementString(
	final OuterJoinLoadable elementPersister,
	final String alias,
	final int batchSize,
	final String subquery)
throws MappingException {

	final int joins = countEntityPersisters( associations );
	suffixes = BasicLoader.generateSuffixes( joins + 1 );

	final int collectionJoins = countCollectionPersisters( associations ) + 1;
	collectionSuffixes = BasicLoader.generateSuffixes( joins + 1, collectionJoins );

	StringBuffer whereString = whereString(
			alias, 
			oneToManyPersister.getKeyColumnNames(), 
			subquery,
			batchSize
		);
	String filter = oneToManyPersister.filterFragment( alias, getEnabledFilters() );
	whereString.insert( 0, StringHelper.moveAndToBeginning(filter) );

	JoinFragment ojf = mergeOuterJoins(associations);
	Select select = new Select( getDialect() )
		.setSelectClause(
			oneToManyPersister.selectFragment(null, null, alias, suffixes[joins], collectionSuffixes[0], true) +
			selectString(associations)
		)
		.setFromClause(
			elementPersister.fromTableFragment(alias) +
			elementPersister.fromJoinFragment(alias, true, true)
		)
		.setWhereClause( whereString.toString() )
		.setOuterJoins(
			ojf.toFromFragmentString(),
			ojf.toWhereFragmentString() +
			elementPersister.whereJoinFragment(alias, true, true)
		);

	select.setOrderByClause( orderBy( associations, oneToManyPersister.getSQLOrderByString(alias) ) );

	if ( getFactory().getSettings().isCommentsEnabled() ) {
		select.setComment( "load one-to-many " + oneToManyPersister.getRole() );
	}

	sql = select.toStatementString();
}