Yeah, either do cylindrical or try object cubic. You'll then have to play with the texture scaling to get it where you want it. I think it depends a lot on what part of the object you want to be visible in the scene and have the material show best on.