Why do they play sweet Caroline during red Sox games? Where did it originate

There had been rumors that the song was sung in honor of President Kennedy's daughter Caroline.