H.S.
The only thing that woke my kids up in the middle of the night is if they were in "big kid" underware (actual boxer briefs for my son and panties for my daughter) and if they had an accident; my son is just over four and a half and he doesn't wear pull-ups at night and if he has too much to drink too late, he'll have an accident in his sleep, he'll come out and whine until I get him in something dry then goes right back to sleep.
If he asks for something to drink when he wakes up, give him a small amount (in one of the small dixie cups that you use to rinse your mouth out with after brushing teeth) of water. No juice at night, it's bad for his teeth and will make him have to go to the bathroom faster.