Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of ejaz.mohammed@jpmorgan.com
 designates 159.53.110.137 as permitted sender)
From: Ejaz X Mohammed <ejaz.mohammed@jpmorgan.com>
To: "user-java@ibatis.apache.org" <user-java@ibatis.apache.org>
Date: Wed, 14 Apr 2010 12:43:07 -0400
Subject: RE: Locks
Thread-Topic: Locks
Thread-Index: Acrb8KNIVxPpvVBZTTWfySPC2qKY3gAAH1FA
Message-ID: 
 <053E796F9A2C134D8F64530C1B7BE73F058D302B2F@EMASC203VS01.exchad.jpmchase.net>
References: 
 <053E796F9A2C134D8F64530C1B7BE73F058D3028C2@EMASC203VS01.exchad.jpmchase.net>
	 <u2yc593b8751004140744p6fda32eevb47287741d878100@mail.gmail.com>
	 <053E796F9A2C134D8F64530C1B7BE73F058D3028FF@EMASC203VS01.exchad.jpmchase.net>
 <q2kc593b8751004140935y7a0048e3z7a83595a9e8faf1c@mail.gmail.com>
In-Reply-To: <q2kc593b8751004140935y7a0048e3z7a83595a9e8faf1c@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

I changed the code to use plain jdbc instead of ibatis =2E=2E=2E as I said =
I'm doing just SELECT =2E=2E=2E I started no tranasaction =2E=2E now I don'=
t see any locks, perf seems to be better too =2E=2E=2E=0D=0A=0D=0AIf we sta=
rt a transaction, sybase takes locks =2E=2E=2E read lock for SELECT =2E=2E=
=2E =0D=0A=0D=0ACan we avoid starting TX during select in ibatis?=0D=0A=0D=
=0AEjaz=0D=0A=0D=0A=0D=0A-----Original Message-----=0D=0AFrom: Jeff Butler =
[mailto:jeffgbutler@gmail=2Ecom] =0D=0ASent: Wednesday, April 14, 2010 11:3=
6 AM=0D=0ATo: user-java@ibatis=2Eapache=2Eorg=0D=0ASubject: Re: Locks=0D=0A=
=0D=0AI assume you're using SIMPLE datasource=2E  With that data source, th=
e=0D=0Aisolation level is set as a driver default=2E  I just did a quick te=
st=0D=0Awith HSQLDB and the default seems to be TRANSACTION_READ_COMMITTED =
- a=0D=0Amiddle of the road isolation level=2E  Maybe there is some setting=
 on=0D=0Athe Sybase driver that will allow you to change the default isolat=
ion=0D=0Alevel?=0D=0A=0D=0AAlternatively, you can do it in code like this:=
=0D=0A=0D=0Atry {=0D=0A  sqlMapClient=2EstartTransaction(Connection=2ETRANS=
ACTION_READ_UNCOMMITTED);=0D=0A=0D=0A  -- do some work=0D=0A} finally {=0D=
=0A  sqlMapClient=2EendTransaction();=0D=0A}=0D=0A=0D=0AIf you are using so=
me other datasource (like JNDI), then you'll need=0D=0Ato look to that data=
source for information about changing the=0D=0Aisolation level=2E=0D=0A=0D=
=0AJeff Butler=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0AOn Wed, Apr 14, 2010 at 9=
:51 AM, Ejaz X Mohammed=0D=0A<ejaz=2Emohammed@jpmorgan=2Ecom> wrote:=0D=0A>=
 These are my settings =2E=2E=2E=0D=0A>=0D=0A> =A0 =A0<!--=0D=0A> =A0 =A0Th=
ese settings control SqlMap configuration details, primarily to do with tra=
nsaction=0D=0A> =A0 =A0management=2E They are all optional (see the Develop=
er Guide for more)=2E=0D=0A> =A0 =A0-->=0D=0A> =A0 =A0<settings=0D=0A> =A0 =
=A0 =A0 =A0 =A0 =A0cacheModelsEnabled=3D"true"=0D=0A> =A0 =A0 =A0 =A0 =A0 =
=A0enhancementEnabled=3D"true"=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0lazyLoadingEna=
bled=3D"true"=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0maxRequests=3D"32"=0D=0A> =A0 =
=A0 =A0 =A0 =A0 =A0maxSessions=3D"10"=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0maxTran=
sactions=3D"5"=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0useStatementNamespaces=3D"true=
"=0D=0A> =A0 =A0 =A0 =A0/>=0D=0A>=0D=0A> =A0 =A0<!--=0D=0A> =A0 =A0Configur=
e a datasource to use with this SQL Map using SimpleDataSource=2E=0D=0A> =
=A0 =A0Notice the use of the properties from the above resource=0D=0A> =A0 =
=A0-->=0D=0A> =A0 =A0<transactionManager type=3D"JDBC" >=0D=0A> =A0 =A0 =A0=
 =A0<dataSource type=3D"=2E=2E=2E=2E">=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0<prope=
rty name=3D"JDBC=2EDriver" value=3D"${jdbc=2Edriver}"/>=0D=0A> =A0 =A0 =A0 =
=A0 =A0 =A0<property name=3D"JDBC=2EConnectionURL" value=3D"${jdbc=2Eurl}"/=
>=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"JDBC=2EUsername" value=3D=
"${jdbc=2Euser}"/>=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0<property name=3D"JDBC=2EP=
assword" value=3D"${jdbc=2Epassword}"/>=0D=0A> =A0 =A0 =A0 =A0 =A0 =A0<prop=
erty name=3D"JDBC=2EDefaultAutoCommit" value=3D"true"/>=0D=0A> =A0 =A0 =A0 =
=A0</dataSource>=0D=0A> =A0 =A0</transactionManager>=0D=0A>=0D=0A>=0D=0A>=
=0D=0A>=0D=0A> -----Original Message-----=0D=0A> From: Jeff Butler [mailto:=
jeffgbutler@gmail=2Ecom]=0D=0A> Sent: Wednesday, April 14, 2010 9:44 AM=0D=
=0A> To: user-java@ibatis=2Eapache=2Eorg=0D=0A> Subject: Re: Locks=0D=0A>=
=0D=0A> It's dependent on the transaction isolation level set on your=0D=0A=
> connection=2E =A0There are many variables involved - what is your=0D=0A> =
environment (POOLED, UNPOOLED, JNDI, etc=2E)?=0D=0A>=0D=0A> Jeff Butler=0D=
=0A>=0D=0A>=0D=0A> On Wed, Apr 14, 2010 at 9:38 AM, Ejaz X Mohammed=0D=0A> =
<ejaz=2Emohammed@jpmorgan=2Ecom> wrote:=0D=0A>> Hello,=0D=0A>>=0D=0A>>=0D=
=0A>>=0D=0A>> I have an application running on Sybase=2E DBAs tell me that =
it is generating=0D=0A>> too many locks =2E=2E=2E I know that all I'm doing=
 is SELECT=2E=0D=0A>>=0D=0A>>=0D=0A>>=0D=0A>> I'm not sure how SELECT can c=
reate locks in database=2E=0D=0A>>=0D=0A>>=0D=0A>>=0D=0A>> Any suggestions =
?=0D=0A>>=0D=0A>>=0D=0A>>=0D=0A>> Thanks=0D=0A>>=0D=0A>> Ejaz=0D=0A>>=0D=0A=
>> This email is confidential and subject to important disclaimers and=0D=
=0A>> conditions including on offers for the purchase or sale of securities=
,=0D=0A>> accuracy and completeness of information, viruses, confidentialit=
y, legal=0D=0A>> privilege, and legal entity disclaimers, available at=0D=
=0A>> http://www=2Ejpmorgan=2Ecom/pages/disclosures/email=2E=0D=0A>=0D=0A> =
---------------------------------------------------------------------=0D=0A=
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis=2Eapache=2Eorg=0D=0A=
> For additional commands, e-mail: user-java-help@ibatis=2Eapache=2Eorg=0D=
=0A> <p><span STYLE=3D"color :#000000;background-color :#FFFFFF">=0D=0A> Th=
is email is confidential and subject to important disclaimers and condition=
s including on offers for the purchase or sale of securities, accuracy and =
completeness of information, viruses, confidentiality, legal privilege, and=
 legal entity disclaimers, available at http://www=2Ejpmorgan=2Ecom/pages/d=
isclosures/email=2E=0D=0A> </span></p>=0D=0A>=0D=0A> ----------------------=
-----------------------------------------------=0D=0A> To unsubscribe, e-ma=
il: user-java-unsubscribe@ibatis=2Eapache=2Eorg=0D=0A> For additional comma=
nds, e-mail: user-java-help@ibatis=2Eapache=2Eorg=0D=0A>=0D=0A>=0D=0A=0D=0A=
---------------------------------------------------------------------=0D=0A=
To unsubscribe, e-mail: user-java-unsubscribe@ibatis=2Eapache=2Eorg=0D=0AFo=
r additional commands, e-mail: user-java-help@ibatis=2Eapache=2Eorg=0D=0A=
=0D=0AThis email is confidential and subject to important disclaimers and=
=0Aconditions including on offers for the purchase or sale of=0Asecurities,=
 accuracy and completeness of information, viruses,=0Aconfidentiality, lega=
l privilege, and legal entity disclaimers,=0Aavailable at http://www=2Ejpmo=
rgan=2Ecom/pages/disclosures/email=2E  

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org