controlDao implementations and databases support

[valery_antonov]

I'm just curious - controlDao has 2 implementations for dealing with savepoints, one for PostgresSQL and empty for all others. And savepoints are used extensively in code. Is it a strange quickfix for PostgreSQL, or support for all dialects is postponed?

BTW, Alfresco Community uses PostgreSQL as default DB nowadays - is it a kind of recommenation?

[mrogers]

It's an oddity of PostgreSQL.

The default database in the installers is no recommendation.  Just a reflection of the fact that we can't distribute MySQL.   (Last I heard we couldn't get an answer from Oracle.)

[valery_antonov]

Distribute Oracle Express instead

Really, I'm investigating save points, because I have a problem with bootstrapping system on first start. I have to create some number of nodes, so I just start new retrying transaction (with RetryingTransactionHelper), and use NodeService.createNode(). Under windows it works, under linux I'm getting sql exceptions from MySQL about constraint violation (duplicated acl_id) after some time. I know that Alfresco ACL's use optimistic locking, so I guess it could happen from time to time (well, all nodes created have the same ACL, hmmm…) - but the whole transaction gets restarted, and it seems it never ends…

[mrogers]

Oracle Express isn't open source?

About time someone forked MySql :evil: