NY Straight Forward

I remember when I was twenty five living in Northern California. The atmosphere was vibrant and the views were fantastic and I can easily say that those were the best days of my life. I have recently got divorced and am looking for some excitement in my life. Anyways, can any of you recommend any good San Jose dance clubs? I know that this is a weird question but since I have not gone dancing in so long I figured that I should ask people that are more up with things. If I go I will ask my female friend Amy to come with me since she has been asking me a lot since I split from my wife.