Altering sequences through annotations in postgres

olav78 · **Joined:** Thu Oct 26, 2006 7:16 am **Posts:** 5

Hibernate version: 3.2

Name and version of the database you are using: postgres 8.1.4

Hi,

I'm trying to set up a sequence in postgreSQL like this:

Code:

@Id
  @GeneratedValue(generator="entityGen")
  @GenericGenerator(name="entityGen", strategy="sequence",
      parameters= {
        @Parameter(name="min_value", value="100")
      }
  )
  public Integer getId() {
    return id;
  }

The problem is that the min_value stays at 1 in the database table (and do not change to 100). (I've also tried to use @SequenceGenerator and set initialValue to 100, but hibernate does not seem to support the initialValue for @SequenceGenerator..)

Anyone knows how I can changed min_value, or other attributes in the sequence table in Postgres, using annotations?

- Olav

batmat · **Posted:** Tue Jan 02, 2007 9:03 am

Did you just run Hibernate or did you run SchemaUpdate? Because Hibernate won't do anything with this I guess. These infos are only present for SchemaUpdate to create the right sequence, so if you don't run SchemaUpdate, or at least force its automatic execution through the "hbm2ddl" property in the hibernate.cfg.xml file, it won't change anything related to the sequence in the db (apart from just calling nextval on it).

olav78 · **Joined:** Thu Oct 26, 2006 7:16 am **Posts:** 5

yes, i updated the schema.

I found out that i can change the minvalue and lastvalue by doing this:

Code:

@Id
  @GeneratedValue(generator="entityGen")
  @GenericGenerator(name="entityGen", strategy="sequence",
      parameters= {
        @Parameter (name="sequence", value="entity_sequence START 100 MINVALUE 100")
      }
  )
  public Integer getId() {
    return id;
  }

but now i get org.hibernate.exception.SQLGrammarException: could not get next sequence value....(?)