Eclipse Community Forums: EMF » [CDO] - Migrating from 4.6 to 4.10

Home » Modeling » EMF » [CDO] - Migrating from 4.6 to 4.10 - All tables are not created

[CDO] - Migrating from 4.6 to 4.10 - All tables are not created [message #1835914]

Wed, 16 December 2020 05:42

Eclipse User

Hi,
I'm migrating from CDO 4.6 to 4.10.
I'm using an embedded CDO server whith H2.
When the CDO server start all tables are not created in the DB.

With the same code in 4.6 and 4.10.
CDO 4.6 : over 300 tables are created.
CDO 4.10 : only 30 tables are created.

In 4.6 : with initialPackages set
In 4.10 : same behavior with or without initialPackages set?

Thanks for reply,
--
Philippe

[Updated on: Wed, 16 December 2020 05:42] by Moderator

Re: [CDO] - Migrating from 4.6 to 4.10 - All tables are not created [message #1835922 is a reply to message #1835914]

Wed, 16 December 2020 10:18

Eclipse User

In CDO 4.6, the tables are created at the startup in AbstractMappingStrategy#createMapping

Quote:

if (packageUnits != null && packageUnits.length != 0)
{
IDBSchemaTransaction schemaTransaction = store.getDatabase().openSchemaTransaction();

try
{
mapPackageUnits(packageUnits, connection, false);
schemaTransaction.commit();
}
finally
{
schemaTransaction.close();
}
}

The table are created on the schemaTransaction.commit();

In CDO 4.10, the method has been refactored this way :
Quote:

try
{
if (packageUnits != null && packageUnits.length != 0)
{
async = monitor.forkAsync();

mapPackageUnits(packageUnits, connection, false);
}
}

This call schemaTransaction.commit(); was deleted.

The tables are now created in : DBStoreAccessor#writeRevisions.
The creation of tables are based on a list of initial revisions.

In my case these revisions contains only few tables, and then only few tables are created in the schema.
When my application want retrieve data from an Eclass, the underlying table does not exist and an exception occured.

Re: [CDO] - Migrating from 4.6 to 4.10 - All tables are not created [message #1835923 is a reply to message #1835914]

Wed, 16 December 2020 10:23

Eclipse User

As of CDO 4.7 tables are created lazily by default. See https://bugs.eclipse.org/bugs/show_bug.cgi?id=534254 .
This can be configured via org.eclipse.emf.cdo.server.db.mapping.IMappingStrategy.Props.EAGER_TABLE_CREATION or via the <property name="eagerTableCreation" value="true|false"/> element in the cdo-server.xml.

Re: [CDO] - Migrating from 4.6 to 4.10 - All tables are not created [message #1835929 is a reply to message #1835923]

Wed, 16 December 2020 11:13

Eclipse User

Thanks Eike.
If i set the property eagerTableCreation to true. CDO create all table but only for one package unit.
Now , i'm not initialized initialPackage when i start the CDO server.
Then in CDO_PACKAGE_UNITS i have only 4 record :
- three record about CDO
- one record for my model.

Only table of this nsURI are created at startup.

I need all tables created at startup. But i can't initialize all the nsURI in initialPackage.

In the MappingStrategy, when the class mapping is done, all the Eclass are known.
I see the constructor of AbstractHorizontalClassMapping that used the EAGER_TABLE_CREATION property but i don't see why all tables for mapped classes are not created.

[Updated on: Wed, 16 December 2020 11:14] by Moderator

Re: [CDO] - Migrating from 4.6 to 4.10 - All tables are not created [message #1835963 is a reply to message #1835929]

Thu, 17 December 2020 04:23

Eclipse User

peugene Mising name wrote on Wed, 16 December 2020 17:13

I need all tables created at startup.

Then you need to wait for my fix to the setInitialPackages() fix, which I can only start after you've submitted the respective bugzilla...

Re: [CDO] - Migrating from 4.6 to 4.10 - All tables are not created [message #1836660 is a reply to message #1835963]

Mon, 11 January 2021 08:26

Eclipse User

I ran into the same issue. I also need all the tables to create a schema diff if my model has changed and adapt the database accordingly.
I created a bugzilla here: https://bugs.eclipse.org/bugs/show_bug.cgi?id=570250

Previous Topic:	How to get reference and value from diff
Next Topic:	load model by using EMF API

Goto Forum:

-=] Back to Top [=-

Current Time: Thu May 15 09:48:19 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter