Juan,
Well in the case of using PgSQL for all my application I will have to rewrite a lot of codes, so I think it's much better to use their native MySQL databases instead.
Also it seems to me that DBI-Link can not do what I want, as it seems, it updates ALL the fields of table in remotre database & not just the changed fields. If this is true, it will rewrite some user setting that is specific for an application that was previously updated by the application itself. So this way it will cause a roll back to these settings that user is made in a specific application. Although I'm not sure about this, I will ask it in their mailing list to see if it only updates the fields I want, or all the fields..
Anyhow, after all, I can go ahead with a simple transaction code in Liferay that triggers a series of connections to different MySQL DBs, update special user information tables and then close connections. Also I can use LOCK table method to lock the tables that Liferay is writing to, so that other applications can not write to the same table at that moment & show a "temporary out of service" message to the user. Although this will not occure much, as this incidence is very rare to happen.
Also I should ask about a feature in MySQL. Is it possible to LOCK a row in a table in MySQL? I mean for e.g if I lock the table "members" , then no member related functions can be done by ANY of my members. But if for example, I can LOCK the 1st row only that contains the data about my first user, then his account information will be updated and meanwhile others can use the system with no problem.
I'm not that familiar with this LOCK method. If anyone can help me and show me how to use it, I will appreciate.
--
Warm Regards,
Amir
Warm Regards,
Amir
