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