Are there any plans to support RAC in Direct Mode or is there some technical limitation on the Oracle side that prevents this? We love using Direct Mode, but use RAC heavily and so we are usually prevented from doing so.
Bryan Hinton
________
Vapir No2
Search found 24 matches
- Thu 17 Feb 2011 20:58
- Forum: dotConnect for Oracle
- Topic: Support for RAC in Direct Mode
- Replies: 1
- Views: 921
- Mon 23 Nov 2009 23:35
- Forum: Entity Framework support
- Topic: TransactionScope not working with a simple use case -bug?
- Replies: 9
- Views: 4445
Resolved
I downloaded the latest build and confirmed that I am no longer seeing the problem - thanks!!!
________
________
- Thu 29 Oct 2009 15:44
- Forum: Entity Framework support
- Topic: TransactionScope not working with a simple use case -bug?
- Replies: 9
- Views: 4445
- Thu 29 Oct 2009 15:30
- Forum: Entity Framework support
- Topic: TransactionScope not working with a simple use case -bug?
- Replies: 9
- Views: 4445
What version of Oracle Client are you using?
I commented out the event handler (it was just writing a debug statement) and still have the problem - are you using Oracle 10g or 11g? I am hearing from the other developers on my team that the behavior is different with 11g (I am seeing it on 10g). To repro I simply call a the Required method and then call the No transaction method.
Bryan
________
Bryan
________
- Fri 23 Oct 2009 17:52
- Forum: Entity Framework support
- Topic: TransactionScope not working with a simple use case -bug?
- Replies: 9
- Views: 4445
Using the latest release
I am experiencing this with the latest release of DevArt (October 19th) and I am using Oracle 10g
________
________
- Fri 23 Oct 2009 17:50
- Forum: Entity Framework support
- Topic: TransactionScope not working with a simple use case -bug?
- Replies: 9
- Views: 4445
TransactionScope not working with a simple use case -bug?
I have a very simple use case that is not working and I believe that it should. Either I am understanding something fundamentally wrong with TransactionScope (I have followed all the examples exactly) or this is a bug.
My model is a simple person table with one column FIRSTNAME. Below are two methods - one that using a Required TransactionScope and one that uses no TransactionScope. I can call each method by itself repeatedly, but as soon as I call the Required one and then call the No Transaction one I get an error
Devart.Data.Oracle.an.b(int A_0 = -1)
Devart.Data.Oracle.at.c(int A_0 = -1)
Devart.Data.Oracle.at.a(bool A_0 = false)
Devart.Data.Oracle.OracleInternalConnection.Commit()
Devart.Data.Oracle.OracleTransaction.Commit()
System.Data.EntityClient.EntityTransaction.Commit()
System.Data.Objects.ObjectContext.SaveChanges(System.Data.Objects.SaveOptions options = {unknown})
I only added the call to explicitly open and close the connection when I saw a forum post about this possibly helping - the behavior of the code is the same without the explicit connection open/close.
Any help/explanation would be appreciated
Bryan
________
My model is a simple person table with one column FIRSTNAME. Below are two methods - one that using a Required TransactionScope and one that uses no TransactionScope. I can call each method by itself repeatedly, but as soon as I call the Required one and then call the No Transaction one I get an error
when trying to call SaveChanges in the DoNoTransaction. The Stack trace is thisORA-24776: cannot start a new transaction
Devart.Data.Oracle.an.b(int A_0 = -1)
Devart.Data.Oracle.at.c(int A_0 = -1)
Devart.Data.Oracle.at.a(bool A_0 = false)
Devart.Data.Oracle.OracleInternalConnection.Commit()
Devart.Data.Oracle.OracleTransaction.Commit()
System.Data.EntityClient.EntityTransaction.Commit()
System.Data.Objects.ObjectContext.SaveChanges(System.Data.Objects.SaveOptions options = {unknown})
Code: Select all
public void DoRequiredScope()
{
try
{
TransactionOptions transOptions = new TransactionOptions();
transOptions.IsolationLevel = IsolationLevel.ReadCommitted;
transOptions.Timeout = new TimeSpan(0, 0, 30);
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, transOptions))
{
Debug.WriteLine("Current Transaction is " + Transaction.Current.TransactionInformation.LocalIdentifier);
Transaction.Current.TransactionCompleted += Current_TransactionCompleted;
using (Entities entities = new Entities())
{
entities.Connection.Open();
PERSON app = entities.PERSON.First();
app.FIRSTNAME = "A Change w/txn";
Console.WriteLine(app.FIRSTNAME);
entities.SaveChanges();
entities.Connection.Close();
}
ts.Complete();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
//throw;
}
}
public void DoNoTransaction()
{
try
{
using (Entities entities = new Entities())
{
entities.Connection.Open();
PERSON app = entities.PERSON.First();
app.FIRSTNAME = "A Change w/o txn";
Console.WriteLine(app.FIRSTNAME);
entities.SaveChanges();
entities.Connection.Close();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
Debug.WriteLine(ex.StackTrace);
}
}
Any help/explanation would be appreciated
Bryan
________
- Fri 26 Jun 2009 23:39
- Forum: Entity Developer
- Topic: Setting Generate property on an EntityAssociation to false
- Replies: 1
- Views: 2646
Setting Generate property on an EntityAssociation to false
I am trying to set one side of an association to not generate the navigation property. For example if I have products and categories - a product has a category and a category has a list of products associated with it. I want to get rid of the property that allows you to go from a category to the list of products. Entity Developer fails to honor my setting of the property. It continues to generate the navigation property even after I have set the Generate property to false and when I open it back up it has set the Generate Property back to true!
________
CHEVROLET CORVETTE C1 SPECIFICATIONS
________
CHEVROLET CORVETTE C1 SPECIFICATIONS
- Fri 26 Jun 2009 23:10
- Forum: Entity Framework support
- Topic: Hate having to uninstall to install the patched version
- Replies: 1
- Views: 2259
Hate having to uninstall to install the patched version
Please can you update your installation so that I don't have to uninstall the software to patch it?
________
M130 ENGINE
________
M130 ENGINE
- Fri 26 Jun 2009 22:50
- Forum: Entity Framework support
- Topic: Pushing the Entity Framework connection string to config
- Replies: 1
- Views: 2525
Pushing the Entity Framework connection string to config
When Entity Developer code gens it puts the connection string into the generated class rather than into a configuration file and it doesn't put the res://*/ in front of the csdl, msl, and ssdl files so that when trying to use it (say from a Console app accessing the model in a data access layer dll) it can't find the files. I can manually add the res://*/ in and that will work until the model gets code generated and then my changes get blown away - this makes for a lot of rework updating those files or writing manual code to create the context. It is such a hassle that it reduces the usability of Entity Developer especially on an ongoing basis with existing models.
________
________
- Fri 26 Jun 2009 22:44
- Forum: Entity Framework support
- Topic: Namespace property in Entity Developer
- Replies: 1
- Views: 2250
Namespace property in Entity Developer
When I try to set the Namespace property to a value that I want (like Samples.Test.Data) in Entity Developer. I get an invalid value property popup. It seems like that field doesn't like periods which is odd since many/most namespace values love to have periods in them. If I manually set it in the generated designer.cs file the designer will reset the value back to something without periods when I reopen the edml file.
________
Hawaii Medical Marijuana
________
Hawaii Medical Marijuana
- Mon 27 Apr 2009 16:32
- Forum: dotConnect for Oracle
- Topic: Oracle Error 01453 When Using Entity Framework
- Replies: 3
- Views: 2899
Any Update on this
we are seeing the same problem and wondered if a solution to this had been found as it describes our situation exactly
________
Built Tough Series
________
Built Tough Series
- Wed 04 Feb 2009 19:34
- Forum: Entity Framework support
- Topic: Mapping Stored procedures that return entities
- Replies: 2
- Views: 2859
Thanks Andrey - that worked - this would be good to document (somewhere other than this forum) so that it is more discoverable
________
Elwood engel
________
Elwood engel
- Tue 03 Feb 2009 22:53
- Forum: Entity Framework support
- Topic: Mapping Stored procedures that return entities
- Replies: 2
- Views: 2859
Mapping Stored procedures that return entities
How do I map a stored procedure that is has an out ref cursor as the only parameter which simply selects from a table and returns the result as a function import? I am simply trying to figure out how to do something simple like that and there doesn't seem to be any samples or anything directing what needs to happen to make it work. Am I missing the guidance? Also when I add the stored procedure to my model it imports the out parameter as a mode=In even though it is clearly an out parameter - hopefully I don't have to manually modify the SSDL for every SP
________
Strawberry Cough
________
Strawberry Cough
- Tue 27 Jan 2009 20:32
- Forum: Entity Framework support
- Topic: absolute champion
- Replies: 5
- Views: 3514
absolute champion
artificially fatigue the muscle, deplete muscle energy stores, and produce non-progressive overload just to becomes much drier with age and Bring easy-to-heat meals. When you prepare dinner at home, make
adapt to the environment you find yourself in. At certain times and in certain "What Is In "Deer Antler Plus"?" back injuries are related to underdeveloped and weak adbominals
ulation screening for complex psychiatric EGF receptor homolog (DER) gene is allelic to activity, degradation of LEA proteins, pro
are specific to the particular damage. Ref-1 that the rate of cleavage may regulate HIV Proteolysis then occurs subsequent to the
________
Honda Chf50
adapt to the environment you find yourself in. At certain times and in certain "What Is In "Deer Antler Plus"?" back injuries are related to underdeveloped and weak adbominals
ulation screening for complex psychiatric EGF receptor homolog (DER) gene is allelic to activity, degradation of LEA proteins, pro
are specific to the particular damage. Ref-1 that the rate of cleavage may regulate HIV Proteolysis then occurs subsequent to the
________
Honda Chf50
- Tue 27 Jan 2009 20:18
- Forum: Entity Framework support
- Topic: trayless cd/dvd roms?
- Replies: 2
- Views: 2923
More Information on the issue
Thanks Andrey - I have found more information on the issue. I now know why Entity Framework was doing things differently for SQL than for Oracle. The data type for the key in Oracle was a decimal (because we were using number in the db) while for SQL it was an int. The type we were projecting into had the key value as an int and so with SQL it didn't have to worry about the cast, but Oracle did and for some reason that was causing an dbapplyexpression to be generated in the query tree.
Once I changed the data type of the key field in the type I was projecting into to decimal the outer apply went away and I got the same sql generated for Oracle that SQL was generating.
________
MERCURY COLONY PARK PICTURE
Once I changed the data type of the key field in the type I was projecting into to decimal the outer apply went away and I got the same sql generated for Oracle that SQL was generating.
________
MERCURY COLONY PARK PICTURE