I am working with base WebSphere 7, which includes JPA 1.2.1, and am interacting with an Oracle 11.2 database. I have a table with an XMLType column in it that I am trying to persist and later retrieve from. I am doing my testing using JUnit 4, using ojdbc6.11.1.0.7.0.jar for my driver. My classes are being enhanced at loadtime using the javaagent.
I have tried 2 different methods to store and retrieve the xmltype column. My first class uses a simple String attribute, and looks like this (BasicEntity just contains versioning and user info): @Entity @Table(name="SERVICE_SNAPSHOTS") public class ServiceSnapshot extends BasicEntity { private static final long serialVersionUID = 5789621189247103676L; @Id @Column(name="SS_ID") @SequenceGenerator(name="id_generatorServiceSnapshot", sequenceName="SERVICE_SNAPSHOTS_SEQ", allocationSize=1) @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="id_generatorServiceSnapshot") private Long id; @Column(name="SS_SERVICE_CD") private String serviceCode; @Column(name="SS_OPERATION_CD") private String operationCode; @Column(name="SS_CONTENTS_XML") private String contentsXML; When I persist the objects, things appear to be stored in the database as expected. If I store and fetch the objects in the same method (so that the objects are in the entity manager), everything comes back fine. I can query the database via SQL and the results are returned. However, if I just fetch the objects, all of the attributes except the XML attribute are properly fetched. The XML attribute is null. If I log the SQL that's being run, I see the column in the SQL string, but the contentsXML is still null. My second uses a JAX-B enhanced object to replace the contentsXML attribute, and this attribute looks like this: @Persistent(fetch=FetchType.EAGER) @Strategy("org.apache.openjpa.jdbc.meta.strats.XMLValueHandler") @Column(name="ss_contents_xml") private DEServiceResults results; I get the same behavior with this class - the results attribute is null, even though the other attributes are not, and results is in the SQL query that gets logged. I can fetch the xml if I use a native query, so I don't think it's a driver issue. Am I setting up my xmltype incorrectly, is this an OpenJPA problem, or is this a bug with the IBM version? Thanks for any help. Don -- View this message in context: http://openjpa.208410.n2.nabble.com/Oracle-XMLType-fetch-problems-tp6208344p6208344.html Sent from the OpenJPA Users mailing list archive at Nabble.com.