Migration from Derby to MySql

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

naveenalfresco

Hi

We are making use of alfresco 3.0 stable with derby database.Due to database scalability issues we are migrating to mysql database.
Step 1:
Followed the steps from the below shown link. 
http://docs.alfresco.com/3.4/index.jsp?topic=%2Fcom.alfresco.Enterprise_3_4_0.doc%2Ftasks%2Fmigrate-derby.html

Parameters at Source database

Database System: Generic Jdbc
Class Name:
org.derbydb.jdbcDriver
&
org.apache.derby.jdbc.EmbeddedDriver

Connection String:

few connection strings we tried

jdbc:derbydb:file:C:/Alfresco/alf_data/derby_data/alfresco
jdbc:derby:C:/Alfresco/alf_data/derby_data/alfresco;create=true

Username: alfresco
Password: alfresco

Parameters at Target database

Hostname: localhost
Username: alfrescoderby
Password: <password for user above>

After step 8 we get the following error message

Connecting to source database and retrieve schemata names.
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :org.derbydb.jdbcDriver
Details: 
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
java.lang.ClassLoader.loadClass(Unknown Source)
sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
java.lang.ClassLoader.loadClass(Unknown Source)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:84)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(ReverseEngineeringGeneric.java:230)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Step:2
Full Export using the webfrontend (http://wiki.alfresco.com/wiki/Export_and_Import). Unfortunatley exporting a complete repository has been disabled in this alfresco version 3.0
Export complete space/repository using the webfrontend. This is not helping as only the data are transferred but not the associated user, rules etc.

Is there any solution to migrate derby to mysql database?

Any help is highly appreciated….

Regards,
Naveen

mrogers

Looks like you may be missing the driver class.  Make sure your derby driver is on the classpath.


In particular I note that the doc you refer to above is not for your version and is assuming HSQL as the default database.