I have a business service that has to perform reiterative queries against two Hibernate DAOs (each working against a different data source).
I can't wrap the service in a JTA transaction because one of the DBs doesn't support transactions at all (it's a legacy turnkey system).
The first query to each DAO works fine, but the second query kicks out "SessionImpl.finalize - unclosed connection, forgot to call close() on your session?" and the service hangs. I suspect this is because Spring isn't managing Hibernate's sessions since a transaction isn't wrapped around the service, right?
What are my options until the turnkey system suports JTA transactions? :?
Thanks in advance,