title: Play framework 2.0 : H2 DB evolution with a simple model
body: <p>I have tried to create a simple controller/model (based on the samples code of play 2.0)
  and got a message concerning evolution of DB:</p>
  
  <pre><code>Database 'default' needs evolution!
  
  An SQL script will be run on your database - "Apply this script now"
  
  1 # --- Rev:1,Ups - fbdc2fd
  2 create table group (
  3 id                        bigint not null,
  4 name                      varchar(255),
  5 description               varchar(255),
  6 due_date                  timestamp,
  7 constraint pk_group primary key (id))
  8 ;
  9 
  10 create sequence group_seq;
  </code></pre>
  
  <p>But when clicking on the button, i have got the below error message:</p>
  
  <pre><code>Database 'default' is in inconsistent state!
  
  An evolution has not been applied properly. Please check the problem and resolve it manually before making it as resolved 
  
  We got the following error: SQLステートメントに文法エラーがあります "CREATE TABLE GROUP[*] ( ID BIGINT NOT NULL, NAME VARCHAR(255), DESCRIPTION VARCHAR(255), DUE_DATE TIMESTAMP, CONSTRAINT PK_GROUP PRIMARY KEY (ID)) "; 期待されるステートメント "identifier" Syntax error in SQL statement "CREATE TABLE GROUP[*] ( ID BIGINT NOT NULL, NAME VARCHAR(255), DESCRIPTION VARCHAR(255), DUE_DATE TIMESTAMP, CONSTRAINT PK_GROUP PRIMARY KEY (ID)) "; expected "identifier"; SQL statement: create table group ( id bigint not null, name varchar(255), description varchar(255), due_date timestamp, constraint pk_group primary key (id)) [42001-158] [ERROR:42001, SQLSTATE:42001], while trying to run this SQL script:
  
   1# --- Rev:1,Ups - fbdc2fd
  2
  3 create table group (
  4 id                        bigint not null,
  5 name                      varchar(255),
  6 description               varchar(255),
  7 due_date                  timestamp,
  8 constraint pk_group primary key (id))
  9 ;
  10
  11 create sequence group_seq;
  </code></pre>
  
  <p>My configuration file</p>
  
  <pre><code>#DB setting
  db.default.driver=org.h2.Driver
  db.default.url="jdbc:h2:mem:play"
  
  # Ebean configuration
  ebean.default="models.*"
  </code></pre>
  
  <p>My controller</p>
  
  <pre><code>public class Application extends Controller {
  
      /**
       * 
       * @return
       */
    public static Result index() {
  
        Group g = new Group("New group Test","This is a test !");
        g.save();
  
      return ok(index.render("Render page"));
    }
  
  }
  </code></pre>
  
  <p>And finally my model:</p>
  
  <pre><code>@Entity
  public class Group extends Model {
  
      public static Finder&lt;Long,Group&gt; find = new Finder (Long.class, Group.class);
  
      @Id
      public Long id;
  
      @Required
      public String name;
  
      @Required
      public String description;
  
      @DateTime(pattern = "MM/dd/yy")
      public Date dueDate;
  
  
      /**
       *  ToString method
       */
      public String toString() {
          return "Group(" + id + ") in project " + name;
          }
  
  
      /**
       *  Constructor
       * @param name
       * @param description
       */
      public Group(String name, String description){
              this.name=name;
              this.description=description;
      }
  
  }
  </code></pre>
  
  <p>has someone encounter the same problem ?
  Thank you !</p>