It's dependent on the transaction isolation level set on your
connection.  There are many variables involved - what is your
environment (POOLED, UNPOOLED, JNDI, etc.)?

Jeff Butler


On Wed, Apr 14, 2010 at 9:38 AM, Ejaz X Mohammed
<ejaz.moham...@jpmorgan.com> wrote:
> Hello,
>
>
>
> I have an application running on Sybase. DBAs tell me that it is generating
> too many locks … I know that all I'm doing is SELECT.
>
>
>
> I'm not sure how SELECT can create locks in database.
>
>
>
> Any suggestions ?
>
>
>
> Thanks
>
> Ejaz
>
> This email is confidential and subject to important disclaimers and
> conditions 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.jpmorgan.com/pages/disclosures/email.

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

Reply via email to