Re: Prepared Statement caching

I want to report our findings in case someone stumbles across this thread. DBCP realization of poolPreparedStatements seems to contain bug. We observed that in a rare cases under heavy load some statements (procedure calls and select statements) were executed on different physical connections (mo

How does iBatis know which connection object to use from a pool?

As I understand it, SqlMapClientImpl (SqlMapClient) hides or wraps the primary JDBC object, Connection. So, we can essentially do everything with SqlMapClient that we can with JDBC's Connection object (including starting, commiting or aborting transactions). However, with iBatis, we don't have

Re: Strange behaviour when column is null

Hi Albert, I eventually figure out what the problem is. And it seems that it is a bug or something... The strangest things is , if I move the position of the result tag of path above the result tag of listPrice , everything work fine!!! If I move it back, the problem persist No

Re: Strange behaviour when column is null

If you can create a complete test case that makes it fall over and attach it to JIRA, one of us will get it fixed. Larry On 2/7/07, Jonathan Tse <[EMAIL PROTECTED]> wrote: Hi Albert, I eventually figure out what the problem is. And it seems that it is a bug or something... The strang

Re: How does iBatis know which connection object to use from a pool?

All connectins and transactions are managed using thread local storage, so each thread has it's own connection, etc.. Larry On 2/7/07, Abdullah Kauchali <[EMAIL PROTECTED]> wrote: As I understand it, SqlMapClientImpl (SqlMapClient) hides or wraps the primary JDBC object, Connection. So, we c

Re: cannot write to property without a setter

That is an interesting pattern - you can't change bah, but you can change it's properties. That *should* work, IMO. Can you add an issue in JIRA for that? Larry On 2/6/07, Reuben Firmin <[EMAIL PROTECTED]> wrote: Let's say I have a class structure as per below. Ibatis doesl not seem to let me

Re: How does iBatis know which connection object to use from a pool?

From: Larry Meadors [EMAIL PROTECTED]: >All connectins and transactions are managed using thread local >storage, so each thread has it's own connection, etc.. (Thanks Larry!) Ok. Understood. So, each time a new thread that uses SqlMapClientImpl is spawned, a Connection object is removed

Re: Strange behaviour when column is null

Hi Larry, Sure I can do it Any sample I can refer to? Best regards, Jonathan Larry Meadors wrote: If you can create a complete test case that makes it fall over and attach it to JIRA, one of us will get it fixed. Larry On 2/7/07, Jonathan Tse <[EMAIL PROTECTED]> wrote: Hi Albert, I

Re: How does iBatis know which connection object to use from a pool?

Almost, but not exactly. ;-) The connection does not remain with the thread for the life of the thread, but rather the thread gets the connection from the pool (the pool marks it as used so no one else gets it), then uses it, then closes it (which just tells the pool that it can give it to others

Re: Strange behaviour when column is null

Just create a sqlmapconfig.xml, a sqlmap.xml, and a simple class that loads up the configuration and runs a query that fails, you can zip it all up and attach it to a JIRA issue. You can probably even put the DDL for the table in the sqlmap.xml, too. Larry On 2/7/07, Jonathan Tse <[EMAIL PROTE

Iterating through Collection.

I'm passing in a Collection in the parameter map. This allows me to pass in a Set, but ibatis doesn't seem to handle this: com.ibatis.common.beans.ProbeException: The 'ids' property of the java.util.HashMap class is not a List or Array. Seems like a possible bug?

can abator do this: delete By Foriegn Key?

Hi there, Assuming I have in my table a foreign key. is there anyway to auto-generate a statement such as: deleteByForiegnKey? Currently, I do that manually and that is time consuming. wonder if there's a quick solution for that. thank you -- View this message in context: http://www.nabble.c

Re: Iterating through Collection.

Nope, just not a feature that has been implemented, you can pass an Array or a List. Larry On 2/7/07, Daniel Pitts <[EMAIL PROTECTED]> wrote: I'm passing in a Collection in the parameter map. This allows me to pass in a Set, but ibatis doesn't seem to handle this: com.ibatis.common.beans.Prob

RE: How does iBatis know which connection object to use from a pool?

Larry: > > Almost, but not exactly. ;-) > > The connection does not remain with the thread for the life of the > thread, but rather the thread gets the connection from the pool (the > pool marks it as used so no one else gets it), then uses it, then > closes it (which just tells the pool that i