Re: Generating schema.xml

thanks, I found introduction how to generate from jdbc later on
http://db.apache.org/torque/torque-4.0/documentation/orm-reference/running-the-generator.html

Running generator I get
[ERROR]
java.lang.NullPointerException
	at org.apache.torque.generator.source.jdbc.JdbcMetadataSource.createRootElement(JdbcMetadataSource.java:215)
	at org.apache.torque.generator.source.SourceImpl.getRootElement(SourceImpl.java:48)
	at org.apache.torque.generator.control.Controller.processSourceInOutput(Controller.java:256)
...

 Changed log level to "debug" made clear that some tables have been
processed, and that error occures for specific table.

Since I do not need all table available in the specified db scheme, I
have a question how to specify a set of tables for which generation
should be done?
Or the generation is done always for whole scheme, that is for all
tables defined in this scheme?



2013/9/12 Thomas Fox <[email protected]>
>
> > is there a way to generate schema.xml from existing db schema (this woulb
> > be prefered way) or from existing POJOs (entities)?
>
> Yes.
> For maven, fgenerate the schema from the database using jdbc metadata by:
>
>       <plugin>
>         <groupId>org.apache.torque</groupId>
>         <artifactId>torque-maven-plugin</artifactId>
>         <version>4.0</version>
>         <executions>
>           <execution>
>             <id>generate-schema-from-jdbc</id>
>             <phase>generate-resources</phase>
>             <goals>
>               <goal>generate</goal>
>             </goals>
>             <configuration>
>               <packaging>classpath</packaging>
>
> <configPackage>org.apache.torque.templates.jdbc2schema</configPackage>
>               <defaultOutputDir>target/generated-schema</defaultOutputDir>
>               <defaultOutputDirUsage>none</defaultOutputDirUsage>
>               <loglevel>info</loglevel>
>               <options>
>                 <torque.jdbc2schema.driver>$
> {driver}</torque.jdbc2schema.driver>
>                 <torque.jdbc2schema.url>$
> {database.url}</torque.jdbc2schema.url>
>                 <torque.jdbc2schema.user>$
> {database.user}</torque.jdbc2schema.user>
>                 <torque.jdbc2schema.password>$
> {database.password}</torque.jdbc2schema.password>
>               </options>
>             </configuration>
>           </execution>
>         </executions>
>       </plugin>
>
> Note that the generated schema is just a starting point, there is some
> information missing from jdbc metadata (e.g. foreign keys, indexes, unique
> constraints...)
>
>    Hope that helps,
>
>         Thomas
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>