Hibernate schema generation can be used to generate DDL without connecting to a database

Question

I would like to use Hibernate schema generation to generate DDL for a database with which I cannot access directly from my PC, simply using the hibernate configuration files. I would like to skip, if possible, setting up a local oracle database. Can hibernate generate DDL for a “theoretical” database of the corresponding dialect, version, etc., Or is it a dream dream?

Are there other tools that can do this?

Answer 1

• You can either use the database in memory during the testing phase ;

  hibernate.hbm2ddl.auto = ""

• DDL hibernatetool Maven:

  <plugin>
      <groupId>org.apache.maven.plugins</groupId>
      <artifactId>maven-antrun-plugin</artifactId>
      <executions>
          <execution>
              <id>generate-test-sql-scripts</id>
              <phase>generate-test-resources</phase>
              <goals>
                  <goal>run</goal>
              </goals>
              <configuration>
                  <tasks>
                      <property name="maven_test_classpath" refid="maven.test.classpath"/>
                      <path id="hibernate_tools_path">
                          <pathelement path="${maven_test_classpath}"/>
                      </path>
                      <property name="hibernate_tools_classpath" refid="hibernate_tools_path"/>
                      <taskdef name="hibernatetool"
                               classname="org.hibernate.tool.ant.HibernateToolTask"/>
                      <mkdir dir="${project.build.directory}/test-classes/hsqldb"/>
                      <hibernatetool destdir="${project.build.directory}/test-classes/hsqldb">
                          <classpath refid="hibernate_tools_path"/>
                          <jpaconfiguration persistenceunit="testPersistenceUnit"
                                            propertyfile="src/test/resources/META-INF/spring/jdbc.properties"/>
                          <hbm2ddl drop="false" create="true" export="false"
                                   outputfilename="create_db.sql"
                                   delimiter=";" format="true"/>
                          <hbm2ddl drop="true" create="false" export="false"
                                   outputfilename="drop_db.sql"
                                   delimiter=";" format="true"/>
                      </hibernatetool>
                  </tasks>
              </configuration>
          </execution>
      </executions>
  </plugin>
  

  Maven DDL:

  • create_db.sql( DDL )
  • drop_db.sql( DDL )