[dna-issues] [JBoss JIRA] Updated: (DNA-511) The JPA Source should provide a way of producing the DDL for the database dialect

[Brian Carothers (JIRA)]

     [ https://jira.jboss.org/jira/browse/DNA-511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brian Carothers updated DNA-511:
--------------------------------

    Attachment: DNA-511.patch


Attached an uncommented patch for review.  The patch leverages the Hibernate SchemaExport class to generate the DDL for a given model.  The POM packages the code into an executable jar, so DDL for a given model in a given schema would be generated with this syntax:

java -jar dna-jpa-ddl-gen-0.7-SNAPSHOT-jar-with-dependencies.jar -dialect org.hibernate.dialect.Oracle10gDialect -model Basic -out /tmp

I'd appreciate any feedback on the patch.  If it looks ok, I'll clean it up, add some comments, and commit it.

> The JPA Source should provide a way of producing the DDL for the database dialect
> ---------------------------------------------------------------------------------
>
>                 Key: DNA-511
>                 URL: https://jira.jboss.org/jira/browse/DNA-511
>             Project: DNA
>          Issue Type: Feature Request
>          Components: Connectors
>    Affects Versions: 0.6
>            Reporter: Randall Hauch
>             Fix For: 0.7
>
>         Attachments: DNA-511.patch
>
>
> Hibernate is capable of dynamically creating the schema, but this is really only practical in a development environment.  Production environments will rarely (ever?) want to allow the software to change the database, so having the DDL for the database used by the JpaSource would be very useful to have.  Hibernate is capable of generating this, and we should provide a mechanism for producing the DDL for the configured dialect.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira