JPA/Hibernate在SQL Server 2012自动建表异常：全表未生成/单表缺失

Hey there! Let's tackle these two table-creation headaches with Hibernate/JPA and SQL Server 2012 step by step.

Problem 1: Hibernate fails to auto-create all tables in SQL Server #

Here are the most common culprits and fixes:

• Verify hibernate.hbm2ddl.auto setting: This is the most frequent issue. Make sure this property in your persistence.xml is set to a value that allows table creation—create, create-drop, or update (use update if you want to keep existing data). If it’s set to validate or none, Hibernate won’t generate any tables. Double-check for this line:

  <property name="hibernate.hbm2ddl.auto" value="update"/>
  

• Check database user permissions: The account your app uses to connect to SQL Server needs explicit permissions like CREATE TABLE and ALTER TABLE on the target database. Without these, Hibernate can’t execute the DDL commands.
• Confirm all entities are registered: Ensure every class you want mapped to a table has the @Entity annotation. If you’re using <class> tags in persistence.xml, list all entities there. If you use <exclude-unlisted-classes>false</exclude-unlisted-classes>, make sure your entities are in a package that gets scanned.
• Use the correct SQL Server dialect: Mismatched dialects break DDL generation. For SQL Server 2012, explicitly set:

  <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServer2012Dialect"/>
  

• Fix entity mapping errors: A single invalid mapping (like missing @Id for a primary key, incompatible data types, or duplicate column names) can block all table creation. Audit all your entities for these issues.

Problem 2: Only one table fails to create (others work) #

Since most tables generate successfully, the issue is specific to that one entity. Try these targeted checks:

• Inspect the problematic entity:
  • Ensure it has a valid @Entity annotation (no typos, and the class is public).
  • Verify the primary key: Every entity needs an @Id annotation on a field or getter, and the data type must be compatible with SQL Server (e.g., Long maps to BIGINT, String with @Column(length=36) for GUIDs).
  • Escape reserved words: If your table or column name uses a SQL Server reserved word (like ORDER, USER, DATE), Hibernate will fail to create the table. Escape it with backticks using @Table(name="Order") or @Column(name="User").
• Check for constraint conflicts: If the entity has a foreign key pointing to a non-existent table (unlikely, but possible) or a unique constraint that clashes with existing data (when using update mode), this can block creation.
• Enable verbose Hibernate logging: Turn on debug logs to see the exact CREATE TABLE statement Hibernate is trying to run. Add these properties to persistence.xml:

  <property name="hibernate.show_sql" value="true"/>
  <property name="hibernate.format_sql" value="true"/>
  <property name="hibernate.use_sql_comments" value="true"/>
  

  You can then run that SQL manually in SQL Server Management Studio to see the exact error (syntax issues, permission problems, etc.).
• Avoid duplicate table names: Make sure no other entity is using the same table name via @Table—this causes silent conflicts.

Quick persistence.xml Validation #

From your snippet, here’s a complete, valid example for SQL Server 2012 to reference:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
  <persistence-unit name="teknikPU" transaction-type="RESOURCE_LOCAL">
    <!-- List all your entity classes here, or use exclude-unlisted-classes=false -->
    <class>com.yourpackage.YourEntity</class>
    <class>com.yourpackage.ProblematicEntity</class>
    <properties>
      <property name="javax.persistence.jdbc.driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
      <property name="javax.persistence.jdbc.url" value="jdbc:sqlserver://localhost:1433;databaseName=yourDB;encrypt=false"/>
      <property name="javax.persistence.jdbc.user" value="dbUser"/>
      <property name="javax.persistence.jdbc.password" value="dbPassword"/>
      <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServer2012Dialect"/>
      <property name="hibernate.hbm2ddl.auto" value="update"/>
      <property name="hibernate.show_sql" value="true"/>
    </properties>
  </persistence-unit>
</persistence>

If you’re still stuck after these steps, share the full persistence.xml and code for the problematic entity, and we can dig deeper!

内容的提问来源于stack exchange，提问作者Royken