L.U.
Sounds like he has found a way to see you in the middle of the night! When my son started this I decided to put a sippy in his bed. It had water in it, and we called it his nightime sippy. Maybe sit down with your son in the daytime and let him know that he is going to have a water sippy in his bed and isn't that exciting!!?? Have him help pick one out, my son picked out a special one at walmart, and then you will probably have to get up a few times and remind him that it's there. But hopefully within the week you will be back to sleeping through the night and he will too!
L.