Following Steve's suggestions, I put together an example on StackOverflow.
http://stackoverflow.com/questions/16213573/setting-up-a-multitenantconnectionprovider-using-hibernate-4-2-and-spring-3-1-1/31825971#31825971