If we go official record then War between Rome and Carthage can be considered as longest war, which started in 264 BC with the outbreak of the Punic Wars, "ended" with a peace treaty signed in 1985.
Time Frame: 2,248 year war,
Result - Carthage was completely destroyed by the Romans and its territory completely annexed. By 146 BC, Carthage's existence as a independent state was over.