You have to be careful with some of the rotary fittings - at each rotary connection there is a small o-ring inside there, which may leak if you put too much force on the fitting, which would end up tilting the connection just enough that it would break the seal with the o-ring and case a leak.

If you're set on using rotary compression fittings, look no further than the BitsPower range of fittings - these are by far the best rotary/compression fittings available on the market today, and as said above, you really shouldn't have problems with leakage if you put a bit of force on the fitting via the tubing