Re: Nested resultMaps and ambiguous columns - can I force qualified name?

2009-04-15 Thread Chad McHenry
Ok, that worked for me. I am able to copy/paste the fields from the generated selects, and reuse the generated resultMaps. Thanks for the quick response. ...Chad == ibatorConfig.xml === ... ... == person_SqlMap.xml === ...

Re: Nested resultMaps and ambiguous columns - can I force qualified name?

2009-04-15 Thread Jeff Butler
As far as I know, MySQL is the only database that supports qualifying column names with the table. It is not standard for JDBC so it won't work in general. The only way to avoid this problem in most databases is to alias the column names so they become unique in the request set. Ibator will gene

Re: how to update a column value by old column value within update statement in ibatis?

2009-04-15 Thread Larry Meadors
You would say: update foo_table set column=column+1 where name='abc' Larry

how to update a column value by old column value within update statement in ibatis?

2009-04-15 Thread ha a
hi, in fact, in sql, I can write "update foo_table set column=column+1 where name='abc'". It resets the new value with one sql. but how can I do that in ibatis with one statement, not by three statements: one gets the value, then add 1, then set the new value? BTW, Can I do it by JDBC? Thank

Nested resultMaps and ambiguous columns - can I force qualified name?

2009-04-15 Thread Chad McHenry
I have generated a number of sqlMaps using ibator. These are working great, but now I would like to take advantage of compound properties to avoid N+1 issues. I would like to minimize the amount of handwritten sqlmap code, and reuse ibators output as much as possible, so in the resultMap for the pa

Re: Ibatis not closing prepared statements?

2009-04-15 Thread Andrius Juozapaitis
hey, just thought I'll report back on this one. The problem, as it turns out, was in our ibatis mapping, but not in an obvious way. The specific mapping that was causing problems was defined as (notice that the property didn't have the javaType="ja

Re: Idle Threads - Glassfish/DB2

2009-04-15 Thread Mario Ds Briggs
Did you do a compare of the JCC log for the same application run with a - the glassfish connection pool b - the ibatis SIMPLE datasource thanks Mario "Jeff Hibbs"