Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of phanibalaji.madgula@gmail.com
 designates 209.85.146.179 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=v4ZOpS0SgJTV6S1Od79kpzotQ0K3g9yI8oh4Ck4hYN9Yp5oJNgvR22X0selv5IbreX
         3GV3cC75WCcBVizPvzTBSMrwOXQTQIaBLFzfiVj3BB3EFOlDV1kCrVJakIQ+pHzihLsR
         q5duFKauaYk/blKFQrl252Kjf4VL9unJWFJYw=
Message-ID: <83e2fc4d0812170404l2c974146m4a5a196e04e16ce@mail.gmail.com>
Date: Wed, 17 Dec 2008 17:34:07 +0530
From: "Phani Madgula" <phanibalaji.madgula@gmail.com>
To: users@openjpa.apache.org
Subject: Re: Can somebody tell me how to generate DDLs
In-Reply-To: <72c1350f0812161323y3c4bd42fta33fb32fbcc1b6c3@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <83e2fc4d0812160423n59029e15ne4a7cb0f3b545c29@mail.gmail.com>
	 <1229459515674-1664781.post@n2.nabble.com>
	 <72c1350f0812161323y3c4bd42fta33fb32fbcc1b6c3@mail.gmail.com>

Thanks for info...I am able to generate the DDLs into a file. The
MappingTool requires database connection though.

Thanks
Phani

On 12/17/08, Michael Dick <michael.d.dick@gmail.com> wrote:
> Hi all,
>
> If a connection to the database is not available (or desired) you can try
> something like this.
>
> Assumptions :
>  1.  target/classes contains your compiled classes
>  2.  target/classes/META-INF/persistence.xml exists and includes a list of
> your entities
>  3.  ${OPENJPA_LOC} contains openjpa.jar
>  4.  ${OPENJPA_LOC}/lib includes the dependencies from our binary archive
>  5.  The example uses derby, you can use db2, oracle or any of the
> DBDictionary classes included with OpenJPA
>
> $ export CLASSPATH=target/classes:${OPENJPA_LOC}/openjpa.jar
> $ java -cp ${CLASSPATH} -Djava.ext.dirs=${OPENJPA_LOC}/lib
> org.apache.openjpa.jdbc.meta.MappingTool -sql temp.ddl -sa build
> -DBDictionary derby
>
> This will generate temp.ddl with the assumption that none of the tables
> exist.
>
> You can do something similar in ant with syntax similar to this :
> <taskdef name="mapping"
> classname="org.apache.openjpa.jdbc.ant.MappingToolTask"
> classpathref="openjpa.cp"/>
> .  . .
> <mapping sqlFile="${classes.location}/temp.ddl" schemaAction="build">
>     <config dbdictionary="derby"/>
> </mapping>
>
> Hope this helps,
> -mike
>
> On Tue, Dec 16, 2008 at 2:31 PM, Pinaki Poddar <ppoddar@apache.org> wrote:
>
>>
>> $ java org.apache.openjpa.jdbc.meta.MappingTool -sql test.ddl -p
>> persistence.xml
>>
>> classpath should have
>> a) openjpa libraries
>> b) a directory X such that X/META-INF/persistence.xml exists
>>
>> persistence.xml should declare the classes you want to generate DDL for in
>> <class> clause.
>> AFAIR, there were some issues with generating DDL without a database
>> connection. So specify a database configuration in persistence.xml also.
>>
>> If you have many persistence unit defined in persistence.xml but want only
>> a
>> specific persistence unit (say Y) to be processed then append it as
>> follows
>>
>> $ java org.apache.openjpa.jdbc.meta.MappingTool -sql test.ddl -p
>> persistence.xml#Y
>>
>> --
>> View this message in context:
>> http://n2.nabble.com/Can-somebody-tell-me-how-to-generate-DDLs-tp1662488p1664781.html
>> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>>
>>
>