<persistence xmlns="http://java.sun.com/xml/ns/persistence"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
    http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
   version="1.0">

   <persistence-unit name="astrosoft" transaction-type="RESOURCE_LOCAL">

       <provider>org.hibernate.ejb.HibernatePersistence</provider>
       
       
      <properties>
          <!-- Scan for annotated classes and Hibernate mapping XML files -->
          <property name="hibernate.archive.autodetection" value="class, hbm"/>

          <!-- SQL stdout logging -->
          <property name="hibernate.show_sql" value="true"/>
          <property name="hibernate.format_sql" value="true"/>
          <property name="use_sql_comments" value="true"/>
         

          <property name="hibernate.connection.driver_class"
                    value="org.hsqldb.jdbcDriver"/>
          <property name="hibernate.connection.url"
                    value="jdbc:hsqldb:file:db/astrodb;hsqldb.default_table_type=cached"/>                   
          <!-- <property name="hibernate.connection.url"
                    value="jdbc:hsqldb:hsql://localhost"/> -->
          <property name="hibernate.connection.username"
                    value="sa"/>
                   
          <property name="hibernate.connection.shutdown"
                    value="true"/>                   

          <property name="hibernate.c3p0.min_size"
                    value="5"/>
          <property name="hibernate.c3p0.max_size"
                    value="20"/>
          <property name="hibernate.c3p0.timeout"
                    value="300"/>
          <property name="hibernate.c3p0.max_statements"
                    value="50"/>
          <property name="hibernate.c3p0.idle_test_period"
                    value="3000"/>

          <property name="hibernate.dialect"
                    value="org.hibernate.dialect.HSQLDialect"/>
                   
          <!-- <property name="hibernate.hbm2ddl.auto" value="create" />  -->

      </properties>
   </persistence-unit>

</persistence>

Ejb3Configuration cfg = new Ejb3Configuration().configure("/META-INF/persistence.xml");
Configuration hbmcfg = cfg.getHibernateConfiguration();
SchemaExport schemaExport = new SchemaExport(hbmcfg);
schemaExport.create(true, true);

Ejb3Configuration cfg = new Ejb3Configuration().configure("PersistenceUnitName", new Properties());
Configuration config = cfg.getHibernateConfiguration();

Dialect dialect = Dialect.getDialect(config.getProperties());
String[] createSql = config.generateSchemaCreationScript(dialect);