On Tue, Oct 19, 2010 at 9:40 AM, Kevin Sutter <[email protected]> wrote:
> You want your EM query to pick up the uncommitted changes on > your JDBC connection. Yes, and I'm doing this simply by using the same connection. Both the JDBC connection and the EM are available on a ThreadLocal variable. The EM gets its connection via a DataSource. The DataSource simply hands it the JDBC connection. > Have you tried adjusting the isolation level? > No, I've never played with such a thing. > so I'm not completely clear on how overriding the close() allows the EM to see your > JDBC updates. > I hope I made it clear with the first paragraph above (same connection). > > I'm also assuming that you are not using any type of connection pooling, > right? Yes I am. I'm using "Proxool" which enhances the driver which causes Connection.close() to return the connection to the pool. -- Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com http://www.opentempo.com mailto:[email protected]
