Disable Wrap Data Types

Just  a moment ago I stumbled on a blog entry of Eric Elsinga about the wrapping of datatypes in Weblogic Datasources, related to the DB-Adapter.

Weblogic wraps objects returned by the database-driver to provide functionality related to debugging, connection utilization tracking and transparent transaction support.
However for some native database objects like BLOBS, CLOBS, ARRAYS etc. this wrapping can affect the performance significantly. When this wrapping is disabled, the application (in our case the DB-Adapter) can work directly on the native objects provided by the Database driver.
To disable the object wrapping do the following:

1. In the Domain Structure tree, expand Services, then select Data Sources.
2. On the Summary of Data Sources page, click the data source name.
3. Select the Configuration: Connection Pool tab.
4. Scroll down and click Advanced to show the advanced connection pool options.
5. In Wrap Data Types, deselect the checkbox to disable wrapping.
6. Click Save.

Of course on a production-mode server you need to Lock&Edit upfront and Activate Changes afterwards.
See also:

• Administration Console Online Help: Disable wrapping of data type objects
• Fusion Middleware Configuring and Managing JDBC Data Sources for Oracle WebLogic Server: Using Unwrapped Data Type Objects