[IBATISNET-104] QueryForXXX do not check cache before opening/closing connection

• Type: Wish
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: DataMapper 1.2.1
• Fix Version/s: DataMapper 1.6
• Component/s: DataMapper
• Assignee: Gilles Bayon
• Reporter: H. E. Sum
• Created: 20/Aug/05 08:25
• Updated: 15/Nov/06 20:22
• Resolved: 15/Nov/06 20:22

Description

I was confused by SqlMapper opening and closing database connections even when items were cached. I thought that it was fetching results from the database, but when I looked at the source, it seemed like the QueryForXXX methods are opening connections, calling MappedStatement to fetch results and then closing connections. Perhaps opening/closing should be pushed to the MappedStatement Class so connections are used only when there's a cache miss.