Yes you have two version of hibernate classes loaded in your server, you have an instance of one of the loaded org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider class and cast it to another load of this class, which exists in another hibernate jar file.
try to use one version of libaries, sometimes the library in samples are older than the server libraries or vice verse. use them same and preferably a shared library for both.