Search found 4 matches
- Tue 29 Dec 2009 14:08
- Forum: dotConnect for Oracle
- Topic: Connection Pooling Sometimes Results in Exaustion of Cursors
- Replies: 2
- Views: 1944
- Tue 22 Dec 2009 21:19
- Forum: dotConnect for Oracle
- Topic: Connection Pooling Sometimes Results in Exaustion of Cursors
- Replies: 2
- Views: 1944
Connection Pooling Sometimes Results in Exaustion of Cursors
I have some tables sitting in a schema on a 10.2 oracle database. I am using dotConnect for Oracle 5.35.57. I have an EDMX created from the Entity Framework Wizard on top of which is layered an ADO.NET Data Services service. I have a two interrelated tables with which I can reliably reproduce the problem (although I have no doubt it will happen with other tables as well). When I perform a number of selects, inserts, and deletes against the tables, the cursors associated with the web service's session on the database increases until it hits 300, after which an ORA-01000: maximum open cursors exceeded is returned. The web service will not service any additional calls until an iisreset is performed. When the service is recycled, the cursors are freed. If the "ConnectionPooling=false" option is used in the connection string this does not happen. Of course, it is a big performance hit so I would prefer to get this resolved.
I have tried to reproduce this in miniature so that I could post a link to a solution wherein this occurs but I have not been successful so far. I continue to make the sample solution more complex in an attempt to get it to fail as the full-sized production application is. I cannot send the production solution for legal reasons. Any ideas on how to reproduce this or provide more information on how I might replicate the problem or debug this problem are welcome.
I have tried to reproduce this in miniature so that I could post a link to a solution wherein this occurs but I have not been successful so far. I continue to make the sample solution more complex in an attempt to get it to fail as the full-sized production application is. I cannot send the production solution for legal reasons. Any ideas on how to reproduce this or provide more information on how I might replicate the problem or debug this problem are welcome.
- Fri 02 Oct 2009 13:06
- Forum: Entity Framework support
- Topic: Changing the underlying schema name without recompilation
- Replies: 2
- Views: 2811
- Thu 01 Oct 2009 20:41
- Forum: Entity Framework support
- Topic: Changing the underlying schema name without recompilation
- Replies: 2
- Views: 2811
Changing the underlying schema name without recompilation
I am using dotConnect for Oracle 5.25.44 to connect to an Oracle 10g instance. I am using the EDM Wizard to generate a conceptual model of the database which is then used by ADO.NET Data Services to expose a RESTful web service. I cannot dictate to the customer what the schema owner will be named in their production environment. I also can not install visual studio on their production network and recompile to a new connection and schema.
Now, the connection string is a configuration element in the web.config file, but the Schema name appears to be embedded in the ssdl file generated as part of the compilation. How do I make this a configuration parameter and recompile for production use?
Now, the connection string is a configuration element in the web.config file, but the Schema name appears to be embedded in the ssdl file generated as part of the compilation. How do I make this a configuration parameter and recompile for production use?