We recorded a fabulous Irish version of this (entitled The Barley Grain) from two elderly brothers in North Clare back in the 70s
It has a nice conclusion where Little Sir John ends up being "pissed against the wall" by a drunkard
I think it can still be heard on the Irish Traditional Music Archive site (sung by either Austin or Michael Flanagan of Luach)
Jim Caarroll