« Return to Thread: getting ddl output to the console

Re: getting ddl output to the console

by Burt Beckwith :: Rate this Message:

This works, but it's clumsy because you have to capture the logging output
manually. I wrote a Gant script that's pretty flexible; I started writing it
up a while back but got distracted. I finished the writeup and have a link to
the script here: http://burtbeckwith.com/blog/?p=59

Burt

On Monday 31 March 2008 9:34:04 pm Jon Gunnip wrote:

> Never mind, I think this is what Burt was suggesting to get hibernate
> to output the DDL:
> 1) set org.'hibernate.tool.hbm2ddl'="debug" in the log4j settings in
> Config.groovy
> 2) set dbCreate to "create-drop"
> 3) start grails
>
> When grails starts up and the schema is dropped and created, you will
> see all of the ddl printed to stdout:
>
> [2797] hbm2ddl.SchemaExport Running hbm2ddl schema export
> [2812] hbm2ddl.SchemaExport import file not found: /import.sql
> [2812] hbm2ddl.SchemaExport exporting generated schema to database
> [2812] hbm2ddl.SchemaExport alter table bibliography drop foreign key
> FK563143626D2169FE
> ...
>
> I was missing step 2 since I was mapping against a legacy database.
>
> Jon
>
> On Mon, Mar 31, 2008 at 4:06 PM, Jon Gunnip <jongunnip@...> wrote:
> > Burt,
> >
> > Could you give a little more detail on how you call SchemaExport to
> > get the debug to output the DDL? Where/how are you calling
> > SchemaExport within the loaded Grails app?
> >
> > By the way, I've added jira issues for "generate-ddl"
> > (http://jira.codehaus.org/browse/GRAILS-2760) and "generate-hbm-xml"
> > (http://jira.codehaus.org/browse/GRAILS-2761) commands.
> >
> > Thanks,
> > Jon
> >
> > On Mon, Feb 11, 2008 at 10:04 PM, Burt Beckwith <burt@...>

wrote:

> > > I've been struggling with this myself - there should be a simple way
> > > to use the Hibernate-generated DDL as an initial script that a DBA can
> > > customize for production. In regular Spring/Hibernate apps I use the
> > > Ant tasks (which wrap SchemaExport) but am having trouble figuring out
> > > how to build the Configuration using .groovy files as domain classes.
> > >
> > > SchemaExport does call "log.debug(formatted);" though so as a
> > > temporary measure I configured debug logging in Config.groovy for
> > > category 'org.hibernate.tool.hbm2dll' and I capture the DDL from the
> > > log4j output.
> > >
> > > Burt
> > >
> > > On Monday 11 February 2008 10:52:27 pm Justin Edelson wrote:
> > > > For "regulatory" reasons, I can't have Hibernate/GORM create
> > > > tables, etc. directly on the database. Is it possible to get these
> > > > statements output to the console (or a file). I'm aware of how this
> > > > is done with Hibernate, but is it possible with GORM?
> > > >
> > > > Thanks,
> > > > Justin
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe from this list, please visit:
> > >
> > > http://xircles.codehaus.org/manage_email
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
> http://xircles.codehaus.org/manage_email

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

« Return to Thread: getting ddl output to the console