hi guys,I'm currently trying to upgrade a 3.1.0 to 3.3.3 (both enterprise). (yub, i know that this path ist not directly supported…but my prob is not related to upgrade path).(ACT #15024-24128)DB-settings are done in alfresco-global.properties, I also set hibernate.default_schema:db.username=myname…hibernate.default_schema=mynameWhen starting the 3.3.3 system org.alfresco.repo.domain.schema.SchemaBootstrap is executed & test if my scheme exists by invoking countAppliedPatches-method.In my case a NoSchemaException seems to be thrown & SchemaBootstrap turns into create-mode.
private boolean updateSchema(Configuration cfg, Session session, Connection connection) throws Exception
{
boolean create = false;
try
{
countAppliedPatches(cfg, connection);
}
catch (NoSchemaException e)
{
create = true;
}
// Get the dialect
final Dialect dialect = Dialect.getDialect(cfg.getProperties());
String dialectStr = dialect.getClass().getSimpleName();
if (create)
{
// execute pre-create scripts (not patches)
for (String scriptUrl : this.preCreateScriptUrls)
{
executeScriptUrl(cfg, connection, scriptUrl);
}
// the applied patch table is missing - we assume that all other tables are missing
// perform a full update using Hibernate-generated statements
File tempFile = TempFileProvider.createTempFile("AlfrescoSchema-" + dialectStr + "-Update-", ".sql");
SchemaBootstrap.dumpSchemaCreate(cfg, tempFile);
executeScriptFile(cfg, connection, tempFile, null);
// execute post-create scripts (not patches)
for (String scriptUrl : this.postCreateScriptUrls)
{
executeScriptUrl(cfg, connection, scriptUrl);
}
}
else
{…
My DB has more than 1 DB scheme. But each scheme has dedicated user…Any hints?best, jan
