This must have been a well-known song at one time because of the number of parodies posted above.
It's still very well known in Ireland and amongst the diaspora, leenia.
Many trinkets sold in Killarney for the tourists still play the tune- even if they are made in China :)