RE: Ibatis throttle - possible deadlock (ibatis 2.2, 2.3)

2008-01-11 Thread Clinton Begin
If you're using Spring, then the transaction/session scope is managed completely by Spring. Somehow you'll have to verify the same thing I mentioned, but within the context of Spring... make sure the transactions are guaranteed to be opened and closed consistently and in a fault tolerant way... A

RE: Ibatis throttle - possible deadlock (ibatis 2.2, 2.3)

2008-01-11 Thread Chris Lamey
Hello, Is this running in an app server? How is the data source wired up to the SqlMapClientTemplate? Can we see the Spring xml doing this binding? Are you using declarative transactions anywhere in the app? Cheers, Chris -Original Message- From: Stéphane Hanser [mailto:[EMAIL PROTE

Re: Ibatis throttle - possible deadlock (ibatis 2.2, 2.3)

2008-01-11 Thread Stéphane Hanser
Hi everybody. I join this discussion because I'm working with Nikolas on this project and I'm fighting with this problem as well. Thank you very much for your answer. However I don't know yet how it will help us. Indeed we never use SqlMapClient but only SqlMapClientTemplate and we don't us

Re: queryForList returns only one row even though SQL query returns many

2008-01-11 Thread Stephen Boyd
Probably because you are inserting only one bind variable which is a string of four number separated by commas. Is that the correct datatype of condition_id? The quick fix would be to change #value# to $value$. However, the proper way to pass in the list of numbers is with a java.util.List and u

queryForList returns only one row even though SQL query returns many

2008-01-11 Thread dandante
Hi, I have an IBATIS select query. I also have logging at the DEBUG level so I can see what queries are sent to my database (mysql). When I call this query from a unit test, using queryForList(), it only returns one row. However it prints out the following to the console: 15:18:27,696 DEBUG Prep

Re: Call stored procedure with reference to a table as the input param.

2008-01-11 Thread Sundar Sankar
I found a way to insert a table of Strings. But I am still working on inserting a table of objects. The code for inserting the table table of String is 1. We have to use a type handler for this. Create a typeHandler like this * * * ** ** ** * * ** * * ** ** * *package* some.package*;* *import* j

RE: Ibatis throttle - possible deadlock (ibatis 2.2, 2.3)

2008-01-11 Thread Clinton Begin
It's most likely that somewhere in your code you're not properly ending a transaction or closing a session Every single SqlMapClient usage should be wrapped with something like this (unless you're not using a transaction at all): try { // start // work // commit } finally { // end } I

What would my jdbc type be for this

2008-01-11 Thread Sundar Sankar
Hi, I have a custom type variable in oracle that I am using in my stored proc. CREATE OR REPLACE TYPE strarray IS TABLE OF VARCHAR2(75); What would be my corresponding jdbctype be or how would I use tyhandler for this case. Regards Sundar Sankarnarayanan

Re: Ibatis throttle - possible deadlock (ibatis 2.2, 2.3)

2008-01-11 Thread Nikolas Kyriazopoulos Panagiotopoulos
[I resend this message because I hadn't confirmed the subscription to the list before sending. Sorry for all those that might receive it twice] Hello, I would like to bring this: https://issues.apache.org/jira/browse/IBATIS-249 into attention. It seems that either an old problem is resurging (not

Re: nullValue for Boolean wrapper class property

2008-01-11 Thread top de castro
Stephen, that did work for me. I added a check for null in the getResult method of my TypeHandlerCallback class. Thanks for the suggestion. --- Stephen Boyd <[EMAIL PROTECTED]> wrote: > This should be handled in your type handler callback > if you have one > implemented. > > > > On Jan 9, 2

Re: nullValue for Boolean wrapper class property

2008-01-11 Thread Stephen Boyd
This should be handled in your type handler callback if you have one implemented. On Jan 9, 2008 8:28 PM, topgd <[EMAIL PROTECTED]> wrote: > > I am using a TypeHandlerCallback to map a Boolean property to a DB2 > character(1) field that contains 'T' or 'F'. > > I cannot get the nullValue proper

Re: Spring DAO executeBatch() returns 0 ??

2008-01-11 Thread Stephen Boyd
What version of Spring are you using? I *think* they fixed it in 2.0.5. On Jan 9, 2008 6:15 PM, Warren <[EMAIL PROTECTED]> wrote: > I just got done switching the Ibatis DAO to Spring DAO per the > instructions > written by Larry. Everything is working fine except whenever I use > SqlMapClient e

SQL Maps outside of classpath with dynamic reloading

2008-01-11 Thread Jörg Gottschling
Hello, for rapid prototyping while integrating in a very special architecture (not our) we consider to work with SQL Maps which are not included in zip or jar. We want that the XML-Files are stored in the filesystem an loaded dynamically as we use them. So we want them to be reloaded when we