Re: Avoiding N+1 Selects

iBatis came back with an error message indicating too many objects were being returned for executeQueryForObject. Brad On 2/20/07, Brad Handy [EMAIL PROTECTED] wrote: Wouldn't I have to give unique column names for those identifying the child data? For example table parentChild

Re: [JDBC type = ARRAY / Java type = ?] conditionally add a table to the from clause just once if either or both of two parameters is not empty

less ugly and more obvious to read - thanks Koka Kiknadze wrote: isNotEmpty property=supplierCompanyId , suppliers_for_parts sp /isNotEmpty isEmpty property=supplierCompanyId isNotEmpty property=supplierRef , suppliers_for_parts sp /isNotEmpty /isEmpty

Re: [JDBC type = ARRAY / Java type = ?] Deadlock found when trying to get lock (MySQL 5.0 with innodb)

No worries, and in all liklihood it isn't an ibatis specific bug, I had just held out hope that someone else might have encountered the issue and arrived at a solution. I've tried both simple and dbcp data sources witht the same results and I'm currently using mysql with innodb tables and row

RE: conditionally add a table to the from clause just once if either or both of two parameters is not empty

Perhaps moving that logic out of your xml file into Java land. Assuming you have a Map as the parameter. boolean useSupplierForParts = Boolean.valueOf(parameters.containsKey(supplierCompanyId) || parameters.containsKey(supplierRef)); Parameters.put(supplierTable, useSupplierForParts ? ,

parameters in select statements and performance

Just checking my understanding ... Is it the case that select statements that use # placeholders perform better than those using $ placeholders when executed multiple times? Is this because the compiled query is saved by the database so it can be reused later with different parameter

number of Initial connections

We have a problem where we exceed our maximum connections on our database. Our setup is here. Does MaximumIdleConnections mean that the database right away grabs 25 connections? Or is that the maximum idle connections before it starts to clean up? I see in the iBatis-SqlMaps-2.pdf it says

Re: parameters in select statements and performance

Yes, almost all databases will cache the execution plans for queries with ? in them. Some will also try to do the same with values in them, too, but that is not as common. Larry On 2/22/07, Mark Volkmann [EMAIL PROTECTED] wrote: Just checking my understanding ... Is it the case that select

RE: Just Another Stored Procedure Question

Hi all, Sorry for the misunderstanding, but it was just a problem of copy and paste.. (because before i tried using parameters passed as raw HashMap).. actually i had this : procedure id=elions.bas.procCounter parameterMap=elions.bas.procCounter.param but still the same problem.. oh and to Mr.