I think that's a stretch, John. The scansion is different from the bawdy song (which means a different tune), and the "boring" metaphor was probably sufficient to inspire it.
The first commercial oil well anywhere was drilled in Pennsylvania in 1859.