openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert Lee" <allee8...@gmail.com>
Subject Re: Generate Script SQL Script files.
Date Tue, 16 Dec 2008 15:03:47 GMT
Phani,

I don't think openjpa is complaining about the sqlFile option.

>From the openjpa manual, SchemaAction takes the following values:

-schemaAction/-sa <add | refresh | drop | build | retain | reflect |
createDB | dropDB | import | export | none> :

The other way to generate sql ddl is described in :

7.1.2. Generating DDL SQL
The examples below show how to use the mapping tool to generate DDL SQL
scripts, rather than modifying the database directly.
Example 7.5. Create DDL for Current Mappings
This example uses your existing mappings to determine the needed schema,
then writes the SQL to create that schema to create.
sql.
java org.apache.openjpa.jdbc.meta.MappingTool -schemaAction build -sql
create.sql Magazine.java
Example 7.6. Create DDL to Update Database for Current Mappings
This example uses your existing mappings to determine the needed schema. It
then writes the SQL to add any missing tables and
columns to the current schema to update.sql.
java org.apache.openjpa.jdbc.meta.MappingTool -sql update.sql Magazine.java

Albert Lee.

On Mon, Dec 15, 2008 at 11:28 PM, Phani Madgula <
phanibalaji.madgula@gmail.com> wrote:

> Forwaring this mail to dev list.
>
> Thanks in advance.
> Phani
>
>
> ---------- Forwarded message ----------
> From: Phani Madgula <phanibalaji.madgula@gmail.com>
> Date: Wed, 10 Dec 2008 15:27:28 +0530
> Subject: Generate Script SQL Script files.
> To: users@openjpa.apache.org
>
> Hi,
> I have the following persistence.xml file.
> ***************
> <?xml version="1.0" encoding="UTF-8" ?>
> - <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="Tutorial" transaction-type="JTA">
>
>  <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>  <non-jta-data-source>ProductDS</non-jta-data-source>
>
>  <class>samples.jpa.Product</class>
>  <class>samples.jpa.Book</class>
>
> - <properties>
>
>  <property name="openjpa.jdbc.SynchronizeMappings"
>
> value="buildSchema(SchemaAction='add,deleteTableContents',ForeignKeys=true,sqlFile=./logs/jpaSQL.log)"
> />
>
>  <property name="openjpa.Log"
>
> value="DefaultLevel=INFO,SQL=TRACE,File=./logs/jpaEnhancerLog.log,Runtime=INFO,Tool=INFO"
> />
>
>  </properties>
>
>  </persistence-unit>
>  </persistence>
> **********************
>
> I wanted JPA to generate SQL scripts for entities in my WAR file into
> "/logs/jpaSQL.log" file as configured above during runtime.
>
> When I used "sqlFile=./logs/jpaSQL.log", it threw an exception as below.
>
> ********************
> .servlet.ServletException: <openjpa-1.0.2-r420667:627158 nonfatal
> general error> org.apache.openjpa.persistence.PersistenceException:
> There was an error while setting up the configuration plugin option
> "SynchronizeMappings". The plugin was of type
> "org.apache.openjpa.jdbc.meta.MappingTool". Setter methods for the
> following plugin properties were not available in that type:
> [sqlFile]. Possible plugin properties are: [ACTIONS, ACTION_ADD,
> ACTION_BUILD_SCHEMA, ACTION_DROP, ACTION_EXPORT, ACTION_IMPORT,
> ACTION_REFRESH, ACTION_VALIDATE, DropUnusedComponents, ForeignKeys,
> IgnoreErrors, Indexes, MODE_ANN_MAPPING, MODE_MAPPING,
> MODE_MAPPING_INIT, MODE_META, MODE_NONE, MODE_QUERY, MappingWriter,
> MetaDataFile, PrimaryKeys, ReadSchema, Repository, SCHEMA_ACTION_NONE,
> SchemaAction, SchemaGroup, SchemaTool, SchemaWriter, Sequences].
> Ensure that your plugin configuration string uses key values that
> correspond to setter methods in the plugin class.
>        samples.jpa.Test.doGet(Test.java:63)
>        javax.servlet.http.HttpServlet.service(HttpServlet.java:693)
>        javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
> *************************
>
> Looks like "sqlFile" is not a valid option for "buildSchema" action.
> Currenty I am working around this problem by generating SQL scripts in
> "/logs/jpaEnhancerLog and manually copying the SQL statements.
>
> Questions??
>
> How do I generate SQL script files into a seperate file?? WHat
> configurations are required for forward mapping in a runtime
> environment??
>
> Thanks in advance.
> Phani
>



-- 
Albert Lee.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message