WCF LoB Adapter (Adapter Pack 2.0) multiple connections from clien

[vijay_sx]

Using WCF LoB Adapter (Microsoft.Adapters.OracleDB 3.5.0.0 - Microsoft
BizTalk Adapter Pack 2.0) in combination with Oracle Data Provider for .NET
2.112.1
to connect to Oracle 11g.
Perfoming serialized call to 2 procedures from same package, within a
transaction, shows that there are 2 connections opened to database even if
connection pooling is disabled (useOracleConnectionPooling = "false") and
that package variables set in call to first packaged procedure is not
available in second packaged procedure call
Furtheron, the ODP.NET trace shows that
dbms_session.modify_package_state(dbms_session.reinitialize);
is called.

The earlier WCF LOB Adapter opened a single connection and there were no
calls to dbms_session.modify_package_state(dbms_session.reinitialize);
So a transaction with multiple calls still executed in a single session and
session variables were available in subsequent calls.

With the new WCF LoB Adapter, can the client be forced to use a single
connection without closing the connection until the client is closed.

[vijay_sx]

The OpenConnection method in Microsoft.Adapters.OracleDB.OracleDBConnection
makes an explicit call to
dbms_session.modify_package_state(dbms_session.reinitialize);

To workaround this behavior is there any way the client be assigned a
connection explicitly ?

[Nammy]

Hi,

we are facing exactly the same problem, did you get any answer? have you
found any solution?

Thank you in advance