R: Reporting with iBatis

Larry, thanks for your reply. It's a pity that iBatis could not return a java.sql.resultset to be passed to JasperReports for the following reasons: 1) Now all the sql statements of our application are in sqlmap xml files 2) If we cannot use iBatis for the reports we cannot use the powerful featur

resultMap HashMap and with a list

Hi All, can someone tell me if this can be done... QRY Select type, name from table order by type, name where the result will be TYPE NAME type1 aaa type1 bbb type2 ccc type3 axzd I want a map with 3 Keys (type1, type2, and type3) and the value of each Key is the list or Names? can this be

Re: resultMap HashMap and with a list

iBATIS will not do this on its own. You could probably do it with a custom rowHandler. Jeff Butler On Nov 27, 2007 1:50 PM, eznibe <[EMAIL PROTECTED]> wrote: > > Hi All, > > can someone tell me if this can be done... > > QRY > > Select type, name > from table > order by type, name > > where t

DBCP Deadlock? [Was: iBatis settings and datasource configuration]

A follow up on this issue: We replaced the SimpleDataSource with Apache Commons DBCP but see the same issue: The pool is getting in some kind of deadlock state where threads are blocked while trying to get a lock on the pool in order to return or borrow a connection to or from the pool. Please