| Session Locks... Please help this is urgent... merged [message #405483] |
Thu, 28 May 2009 00:50  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
