RE: SqlMapClient gets stuck when running under multiple threads

2009-09-22 Thread Ejaz X Mohammed
Note! Transactions cannot be nested. Calling .startTransaction() from the same thread more than once, before calling commit() or rollback(), will cause an exception to be thrown. In other words, each thread can have -at most- one transaction open, per SqlMapClient instance. Note! SqlMapClient tr

Re: SqlMapClient gets stuck when running under multiple threads

2009-09-22 Thread Clinton Begin
SqlMapClient supports multiple threads, you should not have more than one copy. In fact, if you do, you might run into these kinds of problems. I think that's in the documentation in the first sections regarding SqlMapClient. Clinton On Tue, Sep 22, 2009 at 4:22 PM, Ejaz X Mohammed wrote: > H

Re: IBatis 3 TypeHandler resolution

2009-09-22 Thread Clinton Begin
No, that's actually correct. If you specify the JDBC type in the type handler, then you have to specify it in the result map. However, if you don't specify the JDBC type in either, that should work too, but will override ALL string types (for example). The reason is that iBATIS doesn't introspec

SqlMapClient gets stuck when running under multiple threads

2009-09-22 Thread Ejaz X Mohammed
Hello, I'm having problem using SqlMapClient in multiple threads ... I'm storing SqlMapClient instance as ThreadLocal variable - thus each thread gets it's own separate copy. I've supplied startTransaction(), commitTransaction() and endTransaction() which operate on thread local SqlMapClient i

IBatis 3 TypeHandler resolution

2009-09-22 Thread Guy Rouillier
I'm new to iBatis and writing my first type handler to map a database column to an enum whose underlying type is integer. I've got it working after falling prey to some Java limitations (can't extend enum, can't define static methods in interfaces, the combination of which seems to prevent me

Outer Join - Mapping More Than One

2009-09-22 Thread quinya
Hi, I am having problems mapping more than one outer join to a result set. I saw another posting for a similar issue, but I still can't get it to work. I basically have three objects - User, Role and UserGroup. The respective tables have many-to-many relationships implemented with join tables.