[IBATIS-318] Transaction demarcated accross multiple threads...

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 2.1.5
• Component/s: Core
• Assignee: Unassigned
• Reporter: Adam Berry
• Created: 06/Jul/06 14:04
• Updated: 12/Jul/06 05:18
• Resolved: 06/Jul/06 18:47

Description

We are using iBATIS in the following way:

send the server a message which will do a SqlMap.startTransaction()
...
some time later
...
send the server a message which will do a SqlMap.<some sql operation>
...

If we set:
Pool.MaximumActiveConnections=1
Then we hit problems if the thread that does operations on the SqlMap is different to the thread which started the transaction
because
SqlMapClientImpl.getLocalSqlMapSession()
stores the session in a Threadlocal so it finds no session and attempts to automatically create a new one, but since the max connections has been reached it fails.