如何让Hibernate基于DDL / SQL脚本创建表？ [英] How to get Hibernate to create tables based on DDL / SQL script?

问题描述

我有一个包含CREATE TABLE命令的sql / ddl脚本。

我使用hibernate，我希望hibernate执行这个脚本来创建数据库结构。

如何做到这一点？ 可以使用它的JDBC工具填充数据库：

 < beans xmlns =http://www.springframework.org/schema/ beansxmlns：xsi =http://www.w3.org/2001/XMLSchema-instance
 xmlns：jdbc =http://www.springframework.org/schema/jdbc
 xsi：schemaLocation =http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd 
 http：//www.springframework .org / schema / beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd\"> 
 
< jdbc：embedded-database id =dataSourcetype =H2/> 
 
< bean class =org.springframework.jdbc.datasource.init.DataSourceInitializerdepends-on =sessionFactory> 
< property name =databasePopulatorref =resourceDatabasePopulator/> 
< property name =dataSourceref =dataSource/> 
< / bean> 
 
< bean id =resourceDatabasePopulatorclass =org.springframework.jdbc.datasource.init.ResourceDatabasePopulator> 
< property name =scripts> 
< array> 
< value> classpath *：init-hibernate.sql< / value> 
< / array> 
< / property> 
< / bean> 
< / beans> 
  

I have a sql /ddl script containing CREATE TABLE commands.

I use hibernate and I want hibernate to execute this script to create the database structure.

How to do this?

解决方案

If you use Spring you can populate database using its JDBC utilities:

<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:jdbc="http://www.springframework.org/schema/jdbc"
    xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">

    <jdbc:embedded-database id="dataSource" type="H2" />

    <bean class="org.springframework.jdbc.datasource.init.DataSourceInitializer" depends-on="sessionFactory">
        <property name="databasePopulator" ref="resourceDatabasePopulator" />
        <property name="dataSource" ref="dataSource" />
    </bean>

    <bean id="resourceDatabasePopulator" class="org.springframework.jdbc.datasource.init.ResourceDatabasePopulator">
        <property name="scripts">
            <array>
                <value>classpath*:init-hibernate.sql</value>
            </array>
        </property>
    </bean>
</beans>

这篇关于如何让Hibernate基于DDL / SQL脚本创建表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！