UTI :(

I've had a UTI for my entire pregnancy and I'm 17 weeks. At my next appointment they are going to have to give me a cathador and I am scared. How do you prepare for it? Has anyone had one and have suggestions?