Re: Shutting down Connection Pool at runtime (for maintenance)

2008-09-27 Thread Ian Zabel
Quick update on this: We've found that we're able to shutdown and restart the database at will, and DBCP is able to recover connections once the database is back up. So for now, we do not need to restart our app servers, and there's no immediate need to change the backup procedures. We're looking

Problem with textbook spring/ibatis query

2008-09-27 Thread Steve Johnson
Greetings, I'm getting a NullPointerException deep down in iBATIS when I issue a two-level query to build a LIST of sub-objects within a parent object. I attached the iBATIS source to my IDE, and I can see that txManager is null in SqlMapExecutorDelegate.endTransaction(). It is the reference t

1:1 JOIN vs. caching

2008-09-27 Thread Jeremy Cowgar
Hello, I am curious about 1:1 relations and the cache. For instance, on my claim model, it links to a claim status. There are only 30 possible statuses. The status table contains 15 fields. Instead of linking in via a JOIN the claim status table each time I query a claim, would I be better off to