Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Received-SPF: neutral (hermes.apache.org: local policy)
Message-ID: <41B49460.2040506@corksurf.com>
Date: Mon, 06 Dec 2004 17:18:24 +0000
From: Peter Bracken <bracken@corksurf.com>
Reply-To: bracken@corksurf.com
Organization: CorkSurf
User-Agent: Mozilla Thunderbird 1.0RC1 (Windows/20041201)
MIME-Version: 1.0
To: ibatis-user-java@incubator.apache.org
Subject: Re: iBatis Connection Management
References: <41B44050.5080607@corksurf.com>
 <16178eb104120606184e468508@mail.gmail.com>
In-Reply-To: <16178eb104120606184e468508@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I think I got it,

I was parseing the config file every time I called my getSqlMapClient() 
method. I'd been meaning to fix that but didn't think it was a big priority.
Put this one down to extremely bad coding on my part! :)
Sorry about that!

Peter

Clinton Begin wrote:

>Hi Peter,
>
>I've never experienced this, nor have I heard of anything similar.
>Which datasource implementation are you using: SimpleDataSource, or
>DBCP?
>
>In either case I'd expect it to work.  Make sure though that you've
>properly ended your transaction within a finally block.  For example:
>
>try {
>   sqlMapClient.startTransaction();
>   //  ... do some work
>   sqlMapClient.commitTransaction();
>} finally {
>   sqlMapClient.endTransaction();
>}
>
>Cheers,
>Clinton
>  
>