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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
