Home » Developer & Programmer » Forms » Session Locks... Please help this is urgent... merged
Session Locks... Please help this is urgent... merged [message #405483] Thu, 28 May 2009 00:50 Go to next message
liezl
Messages: 1
Registered: May 2009
Location: Dubai
Junior Member

Hi,

I've created web application in ASP.NET and I'm connecting to one of our Oracle server which resides in other country. I only have read access to it. I can only do select statements.

After couple of months that the application was running, their database admin told me that my application was creating session locks in the database.

I only have 4 select statements that's connection to their oracle server. Below one of the query that I'm using.

IDataReader r = null;
try
{
using (OracleConnection conn = new OracleConnection(this.ConnectionString))
{
string _return;
conn.Open();
OracleCommand command = new OracleCommand("select site from mashreq_employees where employee_code='" + emplid + "'", conn);
r = this.ExecuteReader(command);
if (r.Read())
_return = r.ToString();
else
_return = "";
return _return;
}
}
finally
{
if (r != null)
r.Close();
}

My question is, Can I create Session Locks even if I'm only using SELECT STATEMENT?

They send me the screen shot of their Enterprise Manager but I cannot paste it here. The Lock Type was "TX".

Please help me...

Thanks,

Liezl
Re: Session Locks... Please help this is urgent... merged [message #405613 is a reply to message #405483] Thu, 28 May 2009 11:07 Go to previous message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
This might help:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:839412906735#6752246210462
Previous Topic: On Button Trigger If Tab Page = My page then New_form('e:\new.fmx')
Next Topic: How to create a Stacked Canvas in a TAB Canvas?
Goto Forum:
  


Current Time: Sun Dec 04 20:47:48 CST 2016

Total time taken to generate the page: 0.07412 seconds