However if would still like to use Hibernate for your read-only DB2 data,
make sure you're using Hibernate's StatelessSession API or else you'll just be paying a huge CPU and memory overhead using Hiberanate.
Hi Sanjiv, Is there a way to use the StatelessSession API and still have Spring managing the session? I've got three Spring managed datasources... one of them is only ever used to grab a sequence value out of an Oracle db, which sounds like a big waste of resources. But I'd like to keep all the config stuff in one spot and don't yet see an obvious way to do this with the StatelessSession API. Any pointers appreciated. Jason
