title: Schema-validation: missing column [id] in table
body: <p>In my spring boot application i am trying to map a sql-server table to entity.</p>
  
  <pre><code>@Entity(name="Employee")
  @Table(name = "`Personels`")
  public class Employee {
      @Id
      @GeneratedValue(strategy = GenerationType.IDENTITY)
      @Column(name="`Id`")
      private Long id;
  
      @Column(name="`Name`")
      private String name;
  
      @Column(name="`Surname`")
      private String surname;
  ...
  }
  </code></pre>
  
  <p>The columns in the table are starting with uppercase and thats why i use @Column annotation for this, but in the error message it says that hibernate couldn't find the column "id"(not Id).</p>
  
  <pre><code>Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing column [id] in table [personels]
      at org.hibernate.tool.schema.internal.SchemaValidatorImpl.validateTable(SchemaValidatorImpl.java:85) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  </code></pre>
  
  <p>Here is my application.properties file</p>
  
  <pre><code>spring.datasource.url=jdbc:sqlserver://xxx.xxx.xx.xx;databaseName=xxx
  spring.datasource.username=xxx
  spring.datasource.password=xxx
  spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
  spring.jpa.show-sql=true
  spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
  spring.jpa.hibernate.ddl-auto = validate
  spring.jpa.hibernate.naming.implicit-strategy=org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyHbmImpl
  spring.jpa.hibernate.naming.physical-strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy
  </code></pre>
  
  <p>And here is the pom:</p>
  
  <pre><code>    &lt;parent&gt;
          &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
          &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt;
          &lt;version&gt;1.5.6.RELEASE&lt;/version&gt;
          &lt;relativePath /&gt; &lt;!-- lookup parent from repository --&gt;
      &lt;/parent&gt;
  
      &lt;properties&gt;
          &lt;project.build.sourceEncoding&gt;UTF-8&lt;/project.build.sourceEncoding&gt;
          &lt;start-class&gt;com.xxx.yyy.Application&lt;/start-class&gt;
          &lt;java.version&gt;1.8&lt;/java.version&gt;
      &lt;/properties&gt;
  
      &lt;dependencies&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-data-jpa&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;com.microsoft.sqlserver&lt;/groupId&gt;
              &lt;artifactId&gt;mssql-jdbc&lt;/artifactId&gt;
          &lt;/dependency&gt;
  
      &lt;/dependencies&gt;
  </code></pre>