Continuum Data Management Export

1.1-beta-4 Users database only

imbrium:tmp wsmoak$ java -Xmx1024m -jar ~/Downloads/data-management-cli-1.1-beta-4-app.jar -usersJdbcUrl jdbc:derby:/Applications/continuum-1.1-beta-4/data/users/database/ -mode EXPORT -directory backup11beta4users
0 [main] INFO org.apache.maven.continuum.management.DataManagementCli  - Processing Redback database...
18407 [main] WARN JPOX.JDO  - Property org.jpox.validateSchema unknown - will be ignored
18753 [main] INFO JPOX.JDO  - PersistenceManagerFactory - Vendor: JPOX  Version: 1.1.6
18754 [main] INFO JPOX.JDO  - PersistenceManagerFactory initialised for datastore URL=jdbc:derby:/Applications/continuum-1.1-beta-4/data/users/database/ driver=org.apache.derby.jdbc.EmbeddedDriver userName=sa
20735 [main] INFO JPOX.RDBMS  - ================ DatabaseAdapter ==================
20735 [main] INFO JPOX.RDBMS  - Adapter : org.jpox.store.rdbms.adapter.DerbyAdapter
20735 [main] INFO JPOX.RDBMS  - Datastore : name="Apache Derby" version="10.1.3.1" (major=10, minor=1, revision=3)
20735 [main] INFO JPOX.RDBMS  - Driver : name="Apache Derby Embedded JDBC Driver" version="10.1.3.1" (major=10, minor=1)
20735 [main] INFO JPOX.RDBMS  - ===================================================
20836 [main] INFO JPOX.RDBMS.Schema  - Initialising Catalog "", Schema "SA" using "SchemaTable" auto-start option
21539 [main] INFO JPOX.JDO  - Managing Persistence of org.codehaus.plexus.redback.keys.jdo.JdoAuthenticationKey since it was managed previously
21571 [main] WARN JPOX.MetaData  - No manager for annotations was found in the CLASSPATH so all annotations are ignored.
21891 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.codehaus.plexus.redback.keys.jdo.JdoAuthenticationKey [Table : JDOAUTHENTICATIONKEY, InheritanceStrategy : new-table]
21997 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table JDOAUTHENTICATIONKEY
22094 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table JDOAUTHENTICATIONKEY
22095 [main] INFO JPOX.RDBMS.Schema  - Catalog "", Schema "SA" initialised - managing 1 classes
Exception in thread "main" java.io.FileNotFoundException: backup11beta4users/keys.xml (No such file or directory)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
	at java.io.FileWriter.<init>(FileWriter.java:73)
	at org.codehaus.plexus.redback.management.JdoDataManagementTool.backupKeyDatabase(JdoDataManagementTool.java:115)
	at org.apache.maven.continuum.management.redback.JdoDataManagementTool.backupDatabase(JdoDataManagementTool.java:66)
	at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:250)
	at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:165)

1.1-beta-4 both Users and Builds databases

imbrium:tmp wsmoak$ java -Xmx1024m -jar ~/Downloads/data-management-cli-1.1-beta-4-app.jar -usersJdbcUrl jdbc:derby:/Applications/continuum-1.1-beta-4/data/users/database/ -buildsJdbcUrl jdbc:derby:/Applications/continuum-1.1-beta-4/data/continuum/database/ -mode EXPORT -directory backup11beta4both
0 [main] INFO org.apache.maven.continuum.management.DataManagementCli  - Processing Continuum database...
6390 [main] INFO JPOX.JDO  - PersistenceManagerFactory - Vendor: JPOX  Version: 1.1.6
6390 [main] INFO JPOX.JDO  - PersistenceManagerFactory initialised for datastore URL=jdbc:derby:/Applications/continuum-1.1-beta-4/data/continuum/database/ driver=org.apache.derby.jdbc.EmbeddedDriver userName=sa
7309 [main] INFO JPOX.RDBMS  - ================ DatabaseAdapter ==================
7309 [main] INFO JPOX.RDBMS  - Adapter : org.jpox.store.rdbms.adapter.DerbyAdapter
7309 [main] INFO JPOX.RDBMS  - Datastore : name="Apache Derby" version="10.1.3.1" (major=10, minor=1, revision=3)
7309 [main] INFO JPOX.RDBMS  - Driver : name="Apache Derby Embedded JDBC Driver" version="10.1.3.1" (major=10, minor=1)
7310 [main] INFO JPOX.RDBMS  - ===================================================
7341 [main] INFO JPOX.RDBMS.Schema  - Initialising Catalog "", Schema "SA" using "None" auto-start option
7440 [main] INFO JPOX.RDBMS.Schema  - Catalog "", Schema "SA" initialised - managing 0 classes
7456 [main] WARN JPOX.MetaData  - No manager for annotations was found in the CLASSPATH so all annotations are ignored.
7973 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.system.SystemConfiguration [Table : SYSTEMCONFIGURATION, InheritanceStrategy : new-table]
8835 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table SYSTEMCONFIGURATION
8929 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table SYSTEMCONFIGURATION
9102 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.system.Installation [Table : INSTALLATION, InheritanceStrategy : new-table]
9103 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.system.Profile [Table : PROFILES, InheritanceStrategy : new-table]
9103 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.Schedule [Table : SCHEDULE, InheritanceStrategy : new-table]
9103 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildDefinition [Table : BUILDDEFINITION, InheritanceStrategy : new-table]
9103 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectNotifier [Table : PROJECTNOTIFIER, InheritanceStrategy : new-table]
9104 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectDependency [Table : PROJECTDEPENDENCY, InheritanceStrategy : new-table]
9104 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ChangeFile [Table : CHANGEFILE, InheritanceStrategy : new-table]
9104 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ChangeSet [Table : CHANGESET, InheritanceStrategy : new-table]
9104 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ScmResult [Table : SCMRESULT, InheritanceStrategy : new-table]
9105 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildResult [Table : BUILDRESULT, InheritanceStrategy : new-table]
9105 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectDeveloper [Table : PROJECTDEVELOPER, InheritanceStrategy : new-table]
9105 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.Project [Table : PROJECT, InheritanceStrategy : new-table]
9106 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectGroup [Table : PROJECTGROUP, InheritanceStrategy : new-table]
9138 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectNotifier.configuration [Table : PROJECTNOTIFIER_CONFIGURATION]
9145 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.Project.buildDefinitions [Table : PROJECT_BUILDDEFINITIONS]
9149 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.Project.notifiers [Table : PROJECT_NOTIFIERS]
9153 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectGroup.buildDefinitions [Table : PROJECTGROUP_BUILDDEFINITIONS]
9154 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectGroup.notifiers [Table : PROJECTGROUP_NOTIFIERS]
9156 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.system.Profile.environmentVariables [Table : PROFILE_ENVIRONMENTVARIABLES]
9373 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTNOTIFIER
9385 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table PROJECTNOTIFIER
9423 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table CHANGESET
9457 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table CHANGESET
9468 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table CHANGESET
9477 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table CHANGEFILE
9485 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table CHANGEFILE
9491 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table CHANGEFILE
9509 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECT
9555 [main] INFO JPOX.RDBMS  - Validated 3 foreign key(s) for table PROJECT
9577 [main] INFO JPOX.RDBMS  - Validated 4 index(es) for table PROJECT
9585 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table SCHEDULE
9606 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table SCHEDULE
9617 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table INSTALLATION
9631 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table INSTALLATION
9638 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTDEPENDENCY
9650 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECTDEPENDENCY
9659 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECTDEPENDENCY
9665 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTDEVELOPER
9673 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table PROJECTDEVELOPER
9678 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table PROJECTDEVELOPER
9687 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table BUILDRESULT
9702 [main] INFO JPOX.RDBMS  - Validated 3 foreign key(s) for table BUILDRESULT
9710 [main] INFO JPOX.RDBMS  - Validated 4 index(es) for table BUILDRESULT
9715 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTGROUP
9735 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table PROJECTGROUP
9743 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table BUILDDEFINITION
9753 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table BUILDDEFINITION
9761 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table BUILDDEFINITION
9765 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table SCMRESULT
9775 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table SCMRESULT
9782 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROFILES
9793 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROFILES
9799 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROFILES
9806 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECT_NOTIFIERS
9820 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECT_NOTIFIERS
9827 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECT_NOTIFIERS
9834 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECT_BUILDDEFINITIONS
9862 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECT_BUILDDEFINITIONS
9869 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECT_BUILDDEFINITIONS
9875 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTGROUP_NOTIFIERS
9885 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECTGROUP_NOTIFIERS
9894 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECTGROUP_NOTIFIERS
9902 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTGROUP_BUILDDEFINITIONS
9909 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECTGROUP_BUILDDEFINITIONS
9915 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECTGROUP_BUILDDEFINITIONS
9920 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTNOTIFIER_CONFIGURATION
9926 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table PROJECTNOTIFIER_CONFIGURATION
9936 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table PROJECTNOTIFIER_CONFIGURATION
9948 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROFILE_ENVIRONMENTVARIABLES
9957 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROFILE_ENVIRONMENTVARIABLES
9963 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROFILE_ENVIRONMENTVARIABLES
14241 [main] INFO org.apache.maven.continuum.management.DataManagementCli  - Processing Redback database...
16168 [main] WARN JPOX.JDO  - Property org.jpox.validateSchema unknown - will be ignored
16606 [main] INFO JPOX.JDO  - PersistenceManagerFactory - Vendor: JPOX  Version: 1.1.6
16606 [main] INFO JPOX.JDO  - PersistenceManagerFactory initialised for datastore URL=jdbc:derby:/Applications/continuum-1.1-beta-4/data/users/database/ driver=org.apache.derby.jdbc.EmbeddedDriver userName=sa
17122 [main] INFO JPOX.RDBMS  - ================ DatabaseAdapter ==================
17122 [main] INFO JPOX.RDBMS  - Adapter : org.jpox.store.rdbms.adapter.DerbyAdapter
17122 [main] INFO JPOX.RDBMS  - Datastore : name="Apache Derby" version="10.1.3.1" (major=10, minor=1, revision=3)
17122 [main] INFO JPOX.RDBMS  - Driver : name="Apache Derby Embedded JDBC Driver" version="10.1.3.1" (major=10, minor=1)
17122 [main] INFO JPOX.RDBMS  - ===================================================
17150 [main] INFO JPOX.RDBMS.Schema  - Initialising Catalog "", Schema "SA" using "SchemaTable" auto-start option
17605 [main] INFO JPOX.JDO  - Managing Persistence of org.codehaus.plexus.redback.keys.jdo.JdoAuthenticationKey since it was managed previously
17617 [main] WARN JPOX.MetaData  - No manager for annotations was found in the CLASSPATH so all annotations are ignored.
17724 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.codehaus.plexus.redback.keys.jdo.JdoAuthenticationKey [Table : JDOAUTHENTICATIONKEY, InheritanceStrategy : new-table]
17823 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table JDOAUTHENTICATIONKEY
17872 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table JDOAUTHENTICATIONKEY
17873 [main] INFO JPOX.RDBMS.Schema  - Catalog "", Schema "SA" initialised - managing 1 classes
Exception in thread "main" org.apache.maven.continuum.management.DataManagementException: javax.xml.stream.XMLStreamException: Underlying stream encoding 'MacRoman' and input paramter for writeStartDocument() method 'UTF-8' do not match.
	at org.apache.maven.continuum.management.redback.JdoDataManagementTool.backupDatabase(JdoDataManagementTool.java:72)
	at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:250)
	at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:165)
Caused by: javax.xml.stream.XMLStreamException: Underlying stream encoding 'MacRoman' and input paramter for writeStartDocument() method 'UTF-8' do not match.
	at com.sun.xml.internal.stream.writers.XMLStreamWriterImpl.writeStartDocument(XMLStreamWriterImpl.java:1182)
	at javanet.staxutils.IndentingXMLStreamWriter.writeStartDocument(IndentingXMLStreamWriter.java:142)
	at org.codehaus.plexus.redback.keys.jdo.io.stax.RedbackKeyManagementJdoStaxWriter.write(RedbackKeyManagementJdoStaxWriter.java:86)
	at org.codehaus.plexus.redback.management.JdoDataManagementTool.backupKeyDatabase(JdoDataManagementTool.java:118)
	at org.apache.maven.continuum.management.redback.JdoDataManagementTool.backupDatabase(JdoDataManagementTool.java:66)
	... 2 more
imbrium:tmp wsmoak$ java -Xmx1024m -jar ~/Downloads/data-management-cli-1.1-beta-4-app.jar -usersJdbcUrl jdbc:derby:/Applications/continuum-1.1-beta-4/data/users/database/ -mode EXPORT -directory backup11beta4users

1.1 Users database only

java -Xmx512m -jar ~/Downloads/data-management-cli-1.1-app.jar -usersJdbcUrl jdbc:derby:/Applications/continuum-1.1/data/users/database -mode EXPORT -directory userbackups

FAIL

1.1 Builds database only

java -Xmx512m -jar ~/Downloads/data-management-cli-1.1-app.jar -buildsJdbcUrl jdbc:derby:/Applications/continuum-1.1/data/continuum/database -mode EXPORT -directory backups

SUCCESS

1.1 both Builds and Users databases

java -Xmx512m -jar ~/Downloads/data-management-cli-1.1-app.jar -buildsJdbcUrl jdbc:derby:/Applications/continuum-1.1/data/continuum/database -usersJdbcUrl jdbc:derby:/Applications/continuum-1.1/data/users/database -mode EXPORT -directory backups

SUCCESS