Package org.hibernate.sql

Examples of org.hibernate.sql.SimpleSelect

1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
  /**
   * Generate the SQL that selects the version number by id
   */
  protected String generateSelectVersionString() {
    SimpleSelect select = new SimpleSelect( getFactory().getDialect() )
        .setTableName( getVersionedTableName() );
    if ( isVersioned() ) {
      select.addColumn( versionColumnName );
    }
    else {
      select.addColumns( rootTableKeyColumnNames );
    }
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      select.setComment( "get version " + getEntityName() );
    }
    return select.addCondition( rootTableKeyColumnNames, "=?" ).toStatementString();
  }
View Full Code Here
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
        getIdentifierType().sqlTypes( getFactory() )[0]
    );
  }

  public String getSelectByUniqueKeyString(String propertyName) {
    return new SimpleSelect( getFactory().getDialect() )
      .setTableName( getTableName(0) )
      .addColumns( getKeyColumns(0) )
      .addCondition( getPropertyColumnNames(propertyName), "=?" )
      .toStatementString();
  }
View Full Code Here
974
975
976
977
978
979
980
981
982
983
984
  protected String generateSelectSizeString(boolean isIntegerIndexed) {
    String selectValue = isIntegerIndexed ?
        "max(" + getIndexColumnNames()[0] + ") + 1" : // lists, arrays
        "count(" + getElementColumnNames()[0] + ")"; // sets, maps, bags
    return new SimpleSelect( dialect )
        .setTableName( getTableName() )
        .addCondition( getKeyColumnNames(), "=?" )
        .addColumn( selectValue )
        .toStatementString();
  }
View Full Code Here
985
986
987
988
989
990
991
992
993
994
995
  protected String generateDetectRowByIndexString() {
    if ( !hasIndex() ) {
      return null;
    }
    return new SimpleSelect( dialect )
        .setTableName( getTableName() )
        .addCondition( getKeyColumnNames(), "=?" )
        .addCondition( getIndexColumnNames(), "=?" )
        .addCondition( indexFormulas, "=?" )
        .addColumn( "1" )
View Full Code Here
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
  protected String generateSelectRowByIndexString() {
    if ( !hasIndex() ) {
      return null;
    }
    return new SimpleSelect( dialect )
        .setTableName( getTableName() )
        .addCondition( getKeyColumnNames(), "=?" )
        .addCondition( getIndexColumnNames(), "=?" )
        .addCondition( indexFormulas, "=?" )
        .addColumns( getElementColumnNames(), elementColumnAliases )
View Full Code Here
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
        .addColumns( indexFormulas, indexColumnAliases )
        .toStatementString();
  }

  protected String generateDetectRowByElementString() {
    return new SimpleSelect( dialect )
        .setTableName( getTableName() )
        .addCondition( getKeyColumnNames(), "=?" )
        .addCondition( getElementColumnNames(), "=?" )
        .addCondition( elementFormulas, "=?" )
        .addColumn( "1" )
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
  protected String generateLockString(int lockTimeout) {
    SessionFactoryImplementor factory = getLockable().getFactory();
    LockOptions lockOptions = new LockOptions( getLockMode() );
    lockOptions.setTimeOut( lockTimeout );
    SimpleSelect select = new SimpleSelect( factory.getDialect() )
        .setLockOptions( lockOptions )
        .setTableName( getLockable().getRootTableName() )
        .addColumn( getLockable().getRootTableIdentifierColumnNames()[0] )
        .addCondition( getLockable().getRootTableIdentifierColumnNames(), "=?" );
    if ( getLockable().isVersioned() ) {
      select.addCondition( getLockable().getVersionColumnName(), "=?" );
    }
    if ( factory.getSettings().isCommentsEnabled() ) {
      select.setComment( getLockMode() + " lock " + getLockable().getEntityName() );
    }
    return select.toStatementString();
  }
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
  protected String generateLockString(int timeout) {
    SessionFactoryImplementor factory = getLockable().getFactory();
    LockOptions lockOptions = new LockOptions( getLockMode() );
    lockOptions.setTimeOut( timeout );
    SimpleSelect select = new SimpleSelect( factory.getDialect() )
        .setLockOptions( lockOptions )
        .setTableName( getLockable().getRootTableName() )
        .addColumn( getLockable().getRootTableIdentifierColumnNames()[0] )
        .addCondition( getLockable().getRootTableIdentifierColumnNames(), "=?" );
    if ( getLockable().isVersioned() ) {
      select.addCondition( getLockable().getVersionColumnName(), "=?" );
    }
    if ( factory.getSettings().isCommentsEnabled() ) {
      select.setComment( getLockMode() + " lock " + getLockable().getEntityName() );
    }
    return select.toStatementString();
  }
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
  protected String generateLockString(int lockTimeout) {
    SessionFactoryImplementor factory = getLockable().getFactory();
    LockOptions lockOptions = new LockOptions( getLockMode() );
    lockOptions.setTimeOut( lockTimeout );
    SimpleSelect select = new SimpleSelect( factory.getDialect() )
        .setLockOptions( lockOptions )
        .setTableName( getLockable().getRootTableName() )
        .addColumn( getLockable().getRootTableIdentifierColumnNames()[0] )
        .addCondition( getLockable().getRootTableIdentifierColumnNames(), "=?" );
    if ( getLockable().isVersioned() ) {
      select.addCondition( getLockable().getVersionColumnName(), "=?" );
    }
    if ( factory.getSettings().isCommentsEnabled() ) {
      select.setComment( getLockMode() + " lock " + getLockable().getEntityName() );
    }
    return select.toStatementString();
  }
View Full Code Here
926
927
928
929
930
931
932
933
934
935
936
  protected String generateSelectSizeString(boolean isIntegerIndexed) {
    String selectValue = isIntegerIndexed ?
      "max(" + getIndexColumnNames()[0] + ") + 1": //lists, arrays
      "count(" + getElementColumnNames()[0] + ")"; //sets, maps, bags
    return new SimpleSelect(dialect)
        .setTableName( getTableName() )
        .addCondition( getKeyColumnNames(), "=?" )
        .addColumn(selectValue)
        .toStatementString();
  }
View Full Code Here
TOP

Related Classes of org.hibernate.sql.SimpleSelect

  • org.hibernate.dialect.lock.PessimisticReadSelectLockingStrategy
  • org.hibernate.dialect.lock.PessimisticWriteSelectLockingStrategy
  • org.hibernate.dialect.lock.SelectLockingStrategy
  • org.hibernate.persister.collection.AbstractCollectionPersister
  • org.hibernate.persister.entity.AbstractEntityPersister
  • org.hibernate.persister.entity.UnionSubclassEntityPersister
  • java.util.Set
  • java.util.HashSet
  • java.util.Iterator
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.