Currently βCMS configures Jackrabbit to use PostgreSQL as the back end RDBMS. It would be nice to be able to configure βCMS to use other RDBMS as long as Jackrabbit supports them too.
Description
Currently βCMS configures Jackrabbit to use PostgreSQL as the back end RDBMS. It would be nice to be able to configure βCMS to use other RDBMS as long as Jackrabbit supports them too.
Also there has been a general improvement of RDBMS initialization and handling by βCMS so that other RDBMS could be plugged in future releases.
Users already using βCMS must execute the following SQL statements in PostgreSQL in case they choose to update βCMS distribution
ALTER TABLE cmsrepositoryentityassociatio_cmsrepositoryentityassociatio_seq RENAME TO hibernate_sequence;
SELECT max(cmsrepositoryentityassociationid) from cmsrepositoryentityassociation;
Use the outcome of the last SQL in the following ALTER
ALTER SEQUENCE hibernate_sequence restart with 'outcome of previous statement';
Savvas Triantafyllou added a comment - 26/Sep/09 07:34 PM βCMS may use one of the following 2 RDBMS
PostgreSQL
Apache Derby
Also there has been a general improvement of RDBMS initialization and handling by βCMS so that other RDBMS could be plugged in future releases.
Users already using βCMS must execute the following SQL statements in PostgreSQL in case they choose to update βCMS distribution
ALTER TABLE cmsrepositoryentityassociatio_cmsrepositoryentityassociatio_seq RENAME TO hibernate_sequence;
SELECT max(cmsrepositoryentityassociationid) from cmsrepositoryentityassociation;
Use the outcome of the last SQL in the following ALTER
ALTER SEQUENCE hibernate_sequence restart with 'outcome of previous statement';
There is no active plan in supporting other RDBMS other than PostgreSQL and ApacheDerby for the moment. This issue is closed and when another RDBMS will be supported, a new issue will be created
Savvas Triantafyllou added a comment - 15/Apr/10 06:21 AM There is no active plan in supporting other RDBMS other than PostgreSQL and ApacheDerby for the moment. This issue is closed and when another RDBMS will be supported, a new issue will be created
Improvement
Closed
Minor
Add support for other RDBMS besides Postgres
PostgreSQL
Apache Derby
Also there has been a general improvement of RDBMS initialization and handling by βCMS so that other RDBMS could be plugged in future releases.
Users already using βCMS must execute the following SQL statements in PostgreSQL in case they choose to update βCMS distribution
ALTER TABLE cmsrepositoryentityassociatio_cmsrepositoryentityassociatio_seq RENAME TO hibernate_sequence;
SELECT max(cmsrepositoryentityassociationid) from cmsrepositoryentityassociation;
Use the outcome of the last SQL in the following ALTER
ALTER SEQUENCE hibernate_sequence restart with 'outcome of previous statement';