title: Boolean field Oracle vs MySQL
body: <p>I am using hibernate to create tables. In my entity I have following fields. This entity is successfully created when I use MySQL database. but on oracle 10g it throws error</p>
  
  <p><code>create table MetaData (ID bigint not null auto_increment, metaDataId varchar(255) not null, parentId bigint not null, locked bit, userId bigint not null, primary key (ID), unique (metaDataId))</code></p>
  
  <p><code>java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis</code></p>
  
  <p>Entity:</p>
  
  <pre><code>@Entity
  @Inheritance(strategy = InheritanceType.SINGLE_TABLE)
  @DiscriminatorOptions(force = true)
  @Table(name = "MetaData", uniqueConstraints = @UniqueConstraint(columnNames = "metaDataId"))
  public class MetaData extends SavableEntity {
  
      @Column(nullable = false)
      private String metaDataId;
  
      @Column(nullable = false)
      private Long parentId;
  
      @Column(nullable = false)
      private Long userId;
  
      @Column
      @Type(type = "boolean")
      private boolean locked;
  }
  </code></pre>
  
  <p>Any idea what could be wrong?</p>