Discussion: The urologist I visit regularly has advised me to wait for a new and very effective antibiotic that will come out soon in 2023.

To me, it sounds like an evasion exercise! I am very skeptical about the effectiveness of new or old antibiotics. The explanation is more profound than it seems: in chronic disease, the pathogen (bacterium, virus, or parasite) is just the catalyst of the disease, and the cause of the disease is an overly weak immune system. I do not know of any antibiotic that strengthens the immune system. In particular, the prostate has a barrier against numerous types of antibiotics. Even intravenous antibiotics do not lead to recovery from chronic prostatitis.

Link: Recovery from Chronic Prostatitis and Epididymitis, by Self-Healing Medicine.
https://www.sf-healing.com/page/123 (Copy & Paste)