| Sample: VelocityXmlBeans |
| Category: sql |
| Author: Philip Mark Donaghy |
| Last Updated: Dec. 4, 2004 |
| |
| Versions: |
| xmlbeans-v1 1.0.3 |
| xmlbeans-v2 |
| |
| -------------------------------------------------------------------------------- |
| |
| Vxsdb is a XmlBeans sample application which derives a Jakarta Commons SQL data |
| model from an xml schema. It was conceived from things I have learned from using |
| XmlBeans and talking to people at the ASF conference. Vxsdb uses Jakarta |
| Velocity as its templating engine. |
| |
| Features: |
| |
| - Inputs a xml schema |
| - Outputs an Commons SQL data model in xml |
| |
| Building this sample requires Jakarta dependancies which are automatically |
| downloaded to the lib directory when Ant is executed. |
| |
| To try out this sample: |
| |
| 1. Set XMLBEANS_HOME in your environment |
| 2. Ant must be on your PATH |
| 3. To compile the sample source, run "ant" |
| 4. To execute the sample, run "ant -f run.xml" |
| 5. The files xml/datamodel.xml and sql/create.sql are generated |
| |
| To build this sample without downloading dependencies |
| ----------------------------------------------------- |
| ant -Ddeps.exist=true |
| |
| By default run creates a ddl for the Postgres RDBMS. To change the target |
| database add a directive on the command line. |
| |
| Change database |
| --------------- |
| ant -f run.xml -DtargetDatabase=oracle |
| |
| Postgres quickstart |
| ------------------- |
| $ su - |
| # su - postgres |
| $ initdb |
| $ createdb easypo |
| $ psql easypo |
| # \i xml/create.sql |
