Monday, June 05, 2006

async messaging from mysql to java ?

Is there a way to send a async message from mysql to the JVM. I want to execute a java method on a row insert in the mysql table. Is there a neat or a standard way to achieve this? I want to avoid polling the table. I think it should be doable using GET_LOCK, RELEASE_LOCK function calls and some application level logic, but there are side effects to this function and doesnt seem to me to be a cool solution :)

Trip to Munnar

We start. On Time.
This weekend we went to munnar. Munnar is a hill station in western ghats (kerela). We started at 9:30 PM on thursday. Before that I had to go to commercial street in druelling traffic to get some stuff for the trip. But by our standards we started off "on time".


Journey to Munnar - Amazing and long; very long
I dont know who proposed it but the first hop on our trip was mysore. As usual we didnt research the route in advance and paid for it :). We did reach mysore on time but noone knew the definitive route from mysore to munnar. Apparently there is no direct route to munnar from mysore. Anyway the best route from there seemed to be thru chamrajnagar. We got it from a lorry driver. There werent many people on the road to ask. So we blocked the road using our two cars and hoped that someone would stop. Definitely not a suggested way, but it worked. we headed toward chamrajnagar looking for the ever reclusive left turn after the railway crossing. After some 30 kms it turned out that we missed it.

We decided to continue and go thru ooty. The route to ooty was amazing - we stopped and enjoyed the scary lightless jungle night for some time. We saw some wild bisons too.

We had to stop at the entry point to ooty, since it was "locked". It was 2 AM in the morning and gates were locked till 6 AM. We bribed the guards and proceeded further. I slept afterwards in the car , but we went to ooty, then connoor and then reached coimbatore in the morning. Had a good breakfast there. Munnar was another 180 KMs from coimbatore. Saw a wind mill farm.

Finally finally reached munnar at around 1PM. Finally we reached, after a full 16+ hours.

Munnar and around- the town
Munnar turned out to be a lacklustre town. There was only one bar in the town :). Saravana bhavan was a good food place. All the chicks in the town seem to hang around there. Anyway we found a place for ourselves near the town and took rest for the rest of the day.

Munnar and around - waterfall and viewpoints
Next day we checked out attukal water fall. Took a bath. Had a great time over there.


We checked out some of the view points and the mattupeti dam. Went back to our hotel. It was already night by then.



Munnar and around - national park
Next day we just checked out the national park. Park had amazing cool view. We saw some wild life too - a snake and a goat :)


All done - The Journey back
We started our return journey. This time we decided to ask often and not to take the oooty route. We went to coimbatore and then took NH47 to salem. From salem took the route to hosur and then finally reached bangalore at 3:15 AM monday morning. Without any untoward incident. Awesome:).