can I get a copy of the online demo database

Submitted by Guest on Wed, 06/08/2008 - 05:07

General developer's discussion

Is it possible to get a copy of the demo database...the prepopulated database doesn't have a big enough dataset for me?

Re: [OpenVPMS Developers] can I get a copy of the online demo da

Submitted by tanderson on Wed, 06/08/2008 - 16:23.

If you check out the source to archetypes, you can load a database with a small set of data
used for testing purposes. You need to have maven 1.0.2 installed in order to do this.

To check out the 1.2-beta-2 archetypes source to a directory named 'archetypes':
svn co svn://svn.openvpms.org/openvpms/archetypes/tags/openvpms-archetypes-1.2-beta-2 archetypes

In the new archetypes directory, you need to create a file named 'build.properties'
containing the following:

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/openvpms
hibernate.connection.username=openvpms
hibernate.connection.password=openvpms

openvpms.data.loader.cmdline=-s -b 1000 -d src/data/org/openvpms/data/demo

Customise the hibernate connection properties according to your local database setup.
In order to perform the load, you need to start with an empty database: