Package org.hibernate.sql

Examples of org.hibernate.sql.SimpleSelect

1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
  /**
   * 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
2171
2172
2173
2174
2175
2176
2177
2178
2179
2180
2181
        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
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
  /**
   * Generate the SQL that selects a row by id
   */
  protected String generateSelectString(LockMode lockMode) {
    SimpleSelect select = new SimpleSelect( getFactory().getDialect() )
      .setLockMode(lockMode)
      .setTableName( getTableName() )
      .addColumns( getIdentifierColumnNames() )
      .addColumns(
          getSubclassColumnClosure(),
          getSubclassColumnAliasClosure(),
          getSubclassColumnLazyiness()
      )
      .addColumns(
          getSubclassFormulaClosure(),
          getSubclassFormulaAliasClosure(),
          getSubclassFormulaLazyiness()
      );
    //TODO: include the rowids!!!!
    if ( hasSubclasses() ) {
      if ( isDiscriminatorFormula() ) {
        select.addColumn( getDiscriminatorFormula(), getDiscriminatorAlias() );
      }
      else {
        select.addColumn( getDiscriminatorColumnName(), getDiscriminatorAlias() );
      }
    }
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      select.setComment( "load " + getEntityName() );
    }
    return select.addCondition( getIdentifierColumnNames(), "=?" ).toStatementString();
  }
View Full Code Here
864
865
866
867
868
869
870
871
872
873
874
  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
875
876
877
878
879
880
881
882
883
884
885
  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
888
889
890
891
892
893
894
895
896
897
898
  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
899
900
901
902
903
904
905
906
907
908
909
        .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
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
  /**
   * 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
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
        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
887
888
889
890
891
892
893
894
895
896
897
  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.