If you don't want to sweat, there is an epoxy that worked fine the two times
I used it 2 years ago. I got mine at Lowes.
A big down side is that when I wanted to use it last week it had gone bad.
(I did notice that one of the caps wasn't on real good, but poor design made
that difficult.) So, $7/joint is pretty expensive if you just have the one.
Much easier to justify if you can use it a few times before it expires.
There is also a cyanoacrylic on the market, but I haven't gotten around to
trying it yet.