Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error trapping with entity framework when using OS authentication

user13622305Jan 30 2012 — edited Jan 30 2012
Our environment is Microsoft Visual Studio 2010, .NET Framework 4.0, and Oracle Developer Tools for Visual Studio 11.2.0.3.0. We are attempting to build an application development framework using the newly released Oracle entity framework. User security in our production environment is through operating system authentication and individual users are granted capability through database roles. When using the Oracle Data Access Client we can capture Oracle errors, including authentication errors using the try/catch method. However, we have not been able to find a way to catch unhandled exceptions that are thrown when using the entity framework.

For example, the web application will throw the following when an named user has not been granted access to data object being retrieved by the entity framework object:
Server Error in '/' Application.
--------------------------------------------------------------------------------

ORA-1017: invalid username/password; logon denied
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Oracle.DataAccess.Client.OracleException: ORA-1017: invalid username/password; logon denied

Any suggestions on how to handle this situation would be greatly appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2012
Added on Jan 30 2012
1 comment
402 views