Capgemini Sr. Software Engineer interview questions

I went there by 10 AM, they made me to wait for 2 hours and finally my name was called. Interview panel had only 1 member. he started grilling me on core Java, hibernate, spring questions and finally he ended up interviewing me for almost 45 min. He said I was selected, I was so happy. At the second round the HP team member called and discussed about package and everything was going OK till now. Finally again an technical round was scheduled, which I didn't expect. I was called at 3 pm. He asked me to write programs and queries which was also easy. I was very happy that everything went OK. But finally the result was you can leave, you are not selected. Totally dejected I did everything well but not selected they wasted my entire day.