This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I Have a singleton class which handles all my database requests. It creates a static LightSpeedContext, much like your Getting Started Video. In each member method of this class, i create a unit of work within a using. After a few queries to the database, any query using the unitOfWork, I get a OracleException, ORA-03113: end-of-file on communication channel. I'm not sure if this is related, but before the exception is thrown, I do a Find() with a dynamicly created QueryExpression which is numerous ANDed Entity's. The Find() works correctly, but after the second time I execute the same code, the above exception is thrown.
What am I doing wrong? Thanks much!
|
|
|
|
|
Looking at the ORA-03113 documentation, ORA-03113 appears to be a fairly generic error: "this error can be very misleading and is also a catch-all error in the oracle software" (http://www.mydatabasesupport.com/ora-03113-end-of-file-on-communication-channel.html). But it seems it may be accompanied by more specific errors indicating why the database session has been killed. I am not sure if these addiional errors are available through the .NET Oracle client though. If you are using the ODP client then it is probably worth having a look at the Errors collection; otherwise you may need to see if there are any logs you can analyse. If none of this helps, please create a small console application which reproduces the problem and send it to us along with the SQL CREATE TABLE scripts and we will take a look. You can attach a zip file here using the Options tab, or email via the contact form (please strip out all binaries first). Thanks! |
|
|
|
