Migration from Derby to MySql

naveenalfresco — Thu, 20 Oct 2011 09:01:38 GMT

HiWe 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.htmlPar

Re: Migration from Derby to MySql

mrogers — Thu, 20 Oct 2011 12:15:56 GMT

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.

Re: Migration from Derby to MySql

naveenalfresco — Thu, 20 Oct 2011 12:48:56 GMT

Yes that was a mistake . I changed the hsqldb.jar to derby.jar but now I am getting the following error

Connecting to source database and retrieve schemata names.
Initializing JDBC driver … 
Driver class Generic Jdbc
Opening connection … 
[b]Connection jdbc:derby:C:/Alfresco/alf_data/derby_data/alfresco;create=true[/b]
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :Failed to start database 'C:/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.
Details: 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:138)
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)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I believe the connection string is wrong. "jdbc:derby:C:/Alfresco/alf_data/derby_data/alfresco;create=true"

this string was copied from C:\Alfresco\tomcat\shared\classes\alfresco\extension\custom-repository.properties
db.url

Parameters at Source database

Database System: Generic Jdbc
Class Namerg.apache.derby.jdbc.EmbeddedDriver

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

Username: alfresco
Password: alfresco

I was not able to find any document relevant to Alfresco 3.0. Is there any document relevant to derby to mysql migration for alfresco v3.0?

Thanks

Re: Migration from Derby to MySql

naveenalfresco — Fri, 21 Oct 2011 10:09:26 GMT

Hi,

Please I would like to know the exact connection string for derby database because "jdbc:derby:C:/Alfresco/alf_data/derby_data/alfresco" this doesn't work.It throws the above shown error.Can somebody help me out with this?

Regards,
Naveen

topic Migration from Derby to MySql in Alfresco Archive

Migration from Derby to MySql

Re: Migration from Derby to MySql

Re: Migration from Derby to MySql

Re: Migration from Derby to MySql