开发者

odp.net mixes up / caches clob column

开发者 https://www.devze.com 2023-02-09 23:17 出处:网络
I have an ASP.NET 4.0 application where I\'m using NHibernate 3.0 with ODP.NET (newest version) to access a Oracle Express 10g database. All is working fine except the CLOB column is getting mixed up

I have an ASP.NET 4.0 application where I'm using NHibernate 3.0 with ODP.NET (newest version) to access a Oracle Express 10g database. All is working fine except the CLOB column is getting mixed up in my objects.

Example:

Http request /product/1/:

All returned columns values are OK.

Http request /product/2/:

All returned columns values are OK, except the CLOB column. The returned CLOB column is from the previous loaded object.

The problem disappears when disabling connection pooling.

But I'd like to use connec开发者_如何学Pythontion pooling and it doesn't feels right as a solution. Is this a bug in the ODP.NET or are I'm missing some built-in "feature"?


I had a similar problem and setting "Statement Cache Purge=true" in the connectionstring solved it. But I admit it's a very strange case because it occurs only with clob.


May you could try to set the metadata pooling attribute to false, when declaring ODP's connection string. See doc: Supported Connection String Attributes

0

精彩评论

暂无评论...
验证码 换一张
取 消