geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Neal Sanche <n...@nsdev.org>
Subject Re: CMP SQL Generation at Deployment?
Date Wed, 14 Sep 2005 05:37:04 GMT
About all I was able to figure out regarding this tonight was how to use 
Tranql to generate Derby Database DDL and so I guess I'll use that and 
tie my demo app into the SystemDatabase. Here's a section I added to my 
Maven build script:

    <goal name="exportDDL">
        <ant:taskdef name="ddlExporter" 
classname="org.openejb.deployment.ant.DDLExporterTask">
            <classpath>
                <pathelement 
location="${maven.repo.local}/openejb/jars/openejb-builder-${openejb_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/tranql/jars/tranql-${tranql_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/geronimo/jars/geronimo-kernel-${geronimo_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/geronimo/jars/geronimo-deployment-${geronimo_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/geronimo/jars/geronimo-common-${geronimo_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/geronimo/jars/geronimo-j2ee-schema-${geronimo_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/xmlbeans/jars/xbean-${xmlbeans_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/stax/jars/stax-api-${stax_api_version}.jar"/>
                <pathelement 
location="${maven.repo.local}/geronimo-spec/jars/geronimo-spec-ejb-${geronimo_spec_ejb_version}.jar"/>
            </classpath>
        </ant:taskdef>
       
        <ddlExporter
            ejbJar="jar:${basedir}/target/${pom.artifactId}-ejb.jar"
            openejbJar="jar:${basedir}/target/${pom.artifactId}-ejb.jar"
            output="${basedir}/target/${pom.artifactId}-ejb.sql"
            ddlCommandBuilder="org.tranql.ddl.DerbyDDLCommandBuilder"
            type="drop-create-constraint">
            <classpath>
                <pathelement location="target/${pom.artifactId}-ejb.jar"/>
            </classpath>
        </ddlExporter>
    </goal>

This was found in an itest module that is part of the openejb part of 
the geronimo sourcetree. This will generate the SQL, but there is a 
manual step to run the SQL on the Derby database using the features 
found in the geronimo console. But that works alright for what I need 
right now.

Cheers.

-Neal

Neal Sanche wrote:

> Hi Guys,
>
> I've followed through the mentions of CMP beans and saw a bunch of 
> JIRA entries about work related to automatic DDL generation upon 
> deployment of CMP beans. How's the work coming along on this? Is there 
> anything in the current SVN releases that would allow me to try this 
> functionality out?
>
> Thanks for any info.
>
> Cheers.
>
> -Neal



Mime
View raw message