Package org.beangle.db.jdbc.grammar

Examples of org.beangle.db.jdbc.grammar.SequenceGrammar

16
17
18
19
20
21
22
23
24
25
26
27
    super("[8.0]");
  }

  @Override
  protected SequenceGrammar buildSequenceGrammar() {
    SequenceGrammar ss = new SequenceGrammar();
    ss.setQuerySequenceSql("select name as sequence_name,start-1 as current_value,increment,cache from sysibm.syssequences where schema=':schema'");
    ss.setNextValSql("values nextval for :name");
    ss.setDropSql("drop sequence :name restrict");
    ss.setSelectNextValSql("nextval for :name");
    return ss;
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
    super("[8.4)");
  }

  @Override
  protected SequenceGrammar buildSequenceGrammar() {
    SequenceGrammar ss = new SequenceGrammar();
    ss.setQuerySequenceSql("select relname as sequence_name from pg_class where relkind='S'");
    ss.setNextValSql("select nextval (':name')");
    ss.setSelectNextValSql("nextval (':name')");
    return ss;
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
    super("[2.0.0,)");
  }

  @Override
  protected SequenceGrammar buildSequenceGrammar() {
    SequenceGrammar ss = new SequenceGrammar();
    ss.setQuerySequenceSql("select sequence_name,next_value,increment from information_schema.sequences where sequence_schema=':schema'");
    ss.setNextValSql("call next value for :name");
    ss.setSelectNextValSql("next value for :name");
    ss.setCreateSql("create sequence :name start with :start increment by :increment");
    ss.setDropSql("drop sequence if exists :name");
    return ss;
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
    super("[1.3,)");
  }

  @Override
  protected SequenceGrammar buildSequenceGrammar() {
    SequenceGrammar ss = new SequenceGrammar();
    ss.setQuerySequenceSql("select sequence_name,current_value,increment,cache from information_schema.sequences where sequence_schema=':schema'");
    ss.setNextValSql("call next value for :name");
    ss.setSelectNextValSql("next value for :name");
    ss.setCreateSql("create sequence :name start with :start increment by :increment cache :cache");
    ss.setDropSql("drop sequence if exists :name");
    return ss;
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
  public HSQL18Dialect() {
    super("(,1.8)");
  }

  protected SequenceGrammar buildSequenceGrammar() {
    SequenceGrammar ss = new SequenceGrammar();
    ss.setQuerySequenceSql("select sequence_name,start_with as current_value,increment from information_schema.system_sequences where sequence_schema=':schema'");
    ss.setNextValSql("call next value for :name");
    ss.setSelectNextValSql("next value for :name");
    ss.setCreateSql("create sequence :name start with :start increment by :increment");
    ss.setDropSql("drop sequence if exists :name");
    return ss;
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
    registerKeywords("resource","level");
  }

  @Override
  protected SequenceGrammar buildSequenceGrammar() {
    SequenceGrammar ss = new SequenceGrammar();
    ss.setQuerySequenceSql("select sequence_name,last_number,increment_by,cache_size from all_sequences where sequence_owner=':schema'");
    ss.setCreateSql("create sequence :name increment by :increment start with :start cache :cache");
    ss.setNextValSql("select :name.nextval from dual");
    ss.setSelectNextValSql(":name.nextval");
    return ss;
  }
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
175
    }
  }

  public Set<Sequence> loadSequences(Connection connection, String schema) throws SQLException {
    Set<Sequence> sequences = CollectUtils.newHashSet();
    SequenceGrammar ss = dialect.getSequenceGrammar();
    if (null == ss) return sequences;
    String sql = ss.getQuerySequenceSql();
    sql = replace(sql, ":schema", schema);
    if (sql != null) {
      Statement statement = null;
      ResultSet rs = null;
      try {
View Full Code Here
TOP

Related Classes of org.beangle.db.jdbc.grammar.SequenceGrammar

  • org.beangle.db.jdbc.dialect.DB2Dialect
  • org.beangle.db.jdbc.dialect.H2Dialect
  • org.beangle.db.jdbc.dialect.HSQL18Dialect
  • org.beangle.db.jdbc.dialect.HSQL2Dialect
  • org.beangle.db.jdbc.dialect.OracleDialect
  • org.beangle.db.jdbc.dialect.PostgreSQLDialect
  • org.beangle.db.jdbc.meta.MetadataLoader
    • 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.