Extracting Liferay content via MySQL

[Guenter Baumgart, modificado hace 12 años.]

Hi,
we'd like to extract journal articles and a few others over MySQL. The procedure it self is easy but as there are updates by cache or cluster, I am wondering how to schedule it properly. Is there something I can intercept or ask about status of the synchronization ?

Thanks,
g

[Hitoshi Ozawa, modificado hace 12 años.]

You should use Liferay's API or Web Service interface to extract them instead of directly from MySQL.

[Guenter Baumgart, modificado hace 12 años.]

Funny, I guessed already you will say that :-)

Unfortunately we'd prefer our existing methods of using XQuery over remote MySQL. It saves us from additional work and we can process the data directly into our format.

Does the JournalArticleLocalServiceUtil class guarantees data integrity at the time of the download ? We're not sure what happens when using multiple Liferay instances.

Thanks,
g

[Hitoshi Ozawa, modificado hace 12 años.]

By "multiple instances", I'm going to assume that you mean Liferay in a cluster instead of multi-tenancy.

I haven't checked the codes but from Liferay's documents, Liferay's services are suppose to support integrity when ehcache is setup properly.