I want to leverage get_lock() function of mysql as a global lock, but it looks like impossible as I also use JPA as my database layer. Because get_lock() is connection based that means you have to lock/unlock using the same connection, however, there is no native way to retrieve a JDBC connection from JPA. Does that mean get_lock()/release_lock() is totally impossible in JPA? I don t like unwrap to underlying JPA implementation as it s not portable.
Here is something I am trying desperately to get to work: I have an app that polls the GPS module in specified intervals and then sends out coords out to a server using Unix calls such as write(); It ...