cancel
Showing results for 
Search instead for 
Did you mean: 

derby DB upgrade

hreintke
Champ in-the-making
Champ in-the-making
LS,

I am running the default Derby database for version 3b and want to upgrade to 3c.
When starting a "automatic upgrade" I do get errors stating that the right upgrade scripts cannot be found.

Can you tell me which upgrade scripts are supposed to be run ?

Looking in the dbscripts/upgrade directory I have directories for 1.3, 1.4, 2.0, 2.1 and 2.2.

From the earlier posts I expect that the 2.2 scripts are the right one ??
In the 2.2 directory I have
org.hibernate.dialect.Dialect
org.hibernate.dialect.MysqlInnodbdialect
org.hibernate.dialect.Oracle9Dialect

Questions:

Are the scripts in ..Dialect the ones for the Derby DB ?
How does Alfresco select the scripts to run ?
Can I run the scripts manually to upgrade ?

Kind regards,

Herman
1 REPLY 1

hreintke
Champ in-the-making
Champ in-the-making
LS,

Still trying to understand whether there is an upgrade path for Derby DB v3b to v3c.

I have no dbscripts/upgrade directory labeled 3.0 -> Does that mean no scripts for any DB is available ?

I do have a dbscripts/upgrade directory 2.2 but no subdirectory with DerbyDialect
    -> Does that mean only Mysql and Oracle upgrade is available
    -> If I create a DerbyDialect directory, the system tries to run upgrade-from-2.2SP1.sql which is not available for the other dialects.

-> Is there an way to know which scripts should be available to be able to upgrade ?

Kind regards.

Herman