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!

Pooling and metada

user7955879Dec 20 2018 — edited Dec 21 2018

Hello,

I'm using the Oracle.ManagedDataAccess.dll version 4.121.2.0 DLL and I'm developing in C # (VS2015).

I have an internal error in my application when modifying the structure of a table. I found that the problem came from pooling. If I understand correctly, at the first access of the table by my application, ODP.NTe memorizes the structure of the table. So when I change the structure of the table and I do a new SELECT (without leaving my application) there is an error because the structure of the table in memory is not refreshed.

The solution I found is to add "Metadata Pooling = false" to the connection string.

Would you tell me if a newer version of ODP.NET (12.2 ou 18.3) could prevent me from disabling pooling (to avoid losing performance)?

thanks

DT

This post has been answered by Alex Keh-Oracle on Dec 20 2018
Jump to Answer
Comments
Post Details
Added on Dec 20 2018
1 comment
760 views