The St. John's Waltz, originally by Ron Hynes, is the official one. A performance from his funeral:
• Video Link
...
All the sailors got a story
Some are true, some are false
But they're always wrecked and they're up on the deck
Dancin' the St. John's Waltz
Oh we've had our share of history
We've seen nations come and go
We've seen battles rage over land and stage
Five hundred years and more
For glory or for freedom
For country or for King
...
All the nine to fives survive the day
With a sigh and a dose of salts
And they're parkin' their cars and packin' the bars
Dancin' the St. John's Waltz
...
So leave the wayward free to wander
Leave the restless free to roam
If it's rocks in the bay or it's old cliche
You'll find your way back home
So don't question or inquire
What's been gained, what's been lost
In a world of romance don't miss out on the chance
To be Dancin' the St. John's Waltz