Page Comparison

...

1. Use the mysql client to connect to the database host and drop/create the database as needed
2. Set up the database configuration
   • trunk/lib/jdomodels/src/main/resources/datanucleus.properties is already configured for a local MySQL instance
   • For RDS, locally edit trunk/lib/jdomodels/src/main/resources/datanucleus.properties to include the RDS host, user, and password (do not check in any production database passwords into svn)
3. Run the Datanucleus schema creation tool

   Code Block
   cd trunk/lib/jdomodels mvn compile mvn datanucleus:enhance mvn datanucleus:schema-create

How to get the repository service to use local MySQL instead of HDSQL

Pass a property with your jdbc connection string:

-DJDBC_CONNECTION_STRING=jdbc:mysql://localhost/test2

The default username is 'root'. If you want a different username, pass it via property -DPARAM1=myUsername

The default password is the empty string. If you want a different password, pass it via property -DPARAM2=myUsername

The relevant code is in trunk/lib/jdomodels/src/main/java/org/sagebionetworks/repo/model/jdo/PMF.java.

How to load data into an empty repository service

...