Disable JDBC object wrapping in GlassFish

As outlined in my previous blog entry, if you run CMSDK 9.0.4.6 on middleware such as Oracle WebLogic Sever or Oracle GlassFish, you need to disable the JDBC object wrapping first. Otherwise you might be seeing this exception during the startup of a CMSDK Node in GlassFish:

...
oracle.ifs.core.agents.InboundQueueListenerAgent [39] WARNING: Error while processing incoming message.
oracle.ifs.common.IfsException: IFS-13001: Unable to dequeue message
java.lang.ClassCastException: com.sun.gjc.spi.jdbc40.ConnectionWrapper40 cannot be cast to oracle.jdbc.OracleConnection
    at
oracle.ifs.server.S_Queue.dequeue(S_Queue.java:342)
...

How to Disable JDBC Object Wrapping in GlassFish

It is required to disable JDBC object wrapping when using a data source for CMSDK 9.0.4.6. These instructions are for GlassFish 3.1.1 or above, as we don’t support earlier versions of GlassFish with CMSDK.

To disable wrapping of JDBC objects using the Administration Console:

  1. In the Domain Structure tree, expand Resources, then expand JDBC.
  2. Select JDBC Connection Pool in the tree structure.
  3. On the Summary of JDBC Connection Pool page, click the connection pool name that your data source is based on.
  4. Select the Advanced: Edit JDBC Connection Pool Advanced Attributes tab.
  5. In Wrap JDBC Objects, deselect the checkbox to disable wrapping.
  6. Click Save.

    This change does not take effect immediately—it requires that the data source be redeployed or the server be restarted.

In Oracle GlassFish Server this property can also be modified in the domain.xml file or via asadmin command.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

My name is Frank Closheim. I lead Development for CMSDK at Oracle and want to share the latest news, best practices, examples and product updates about CMSDK with the Blogsphere.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today