Re: after network drop i get ora-03114 not connected to oracle
- From: "Miha Markic [MVP C#]" <miha at rthand com>
- Date: Mon, 22 Jan 2007 14:22:46 +0100
Hi Geir,
I guess this is a connection pool feature. Try clearing connection pool and re-create connection when this happens (you would have to recreate it anyway).
Both SqlConnection and OracleConnection have static ClearPool method while OleDbConnection seems missing it (try with ReleaseObjectPool instead).
Why don't you use Oracle managed provider in first place?
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Geir Sanne" <GeirSanne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A9029AAB-7132-46BD-9666-B28981121D08@xxxxxxxxxxxxxxxx
hi!!!
im calling a stored procedure in oracle every time i get a message on a
serialport.
using (OleDbConnection conn = new
OleDbConnection(connectionString))
{
OleDbCommand cmd = new OleDbCommand(".....", conn);
conn.Open();
cmd.CommandTimeout = 10;
cmd.ExecuteNonQuery();
}
this works fine and when network drops/fails i get a timeout.
the problem occurs when the network is back up.
the conn.open() runs fine, but when cmd.ExecuteNonQuery(); i get ora-03114
not connected to oracle. this error i get until i restart my program.
is this a ado.net problem or a oracle problem ?
.
- Follow-Ups:
- Re: after network drop i get ora-03114 not connected to oracle
- From: Geir Sanne
- Re: after network drop i get ora-03114 not connected to oracle
- Prev by Date: DateTime Filter Expression
- Next by Date: Re: after network drop i get ora-03114 not connected to oracle
- Previous by thread: DateTime Filter Expression
- Next by thread: Re: after network drop i get ora-03114 not connected to oracle
- Index(es):
Relevant Pages
|
