topic controlDao implementations and databases support in Alfresco Archive

controlDao implementations and databases support

valery_antonov — Thu, 05 Apr 2012 11:01:28 GMT

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 def

Re: controlDao implementations and databases support

mrogers — Thu, 05 Apr 2012 12:15:14 GMT

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.)

Re: controlDao implementations and databases support

valery_antonov — Sat, 07 Apr 2012 12:20:12 GMT

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…

Re: controlDao implementations and databases support

mrogers — Sat, 07 Apr 2012 15:47:55 GMT

Oracle Express isn't open source?

About time someone forked MySql :evil: