Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 341242 - CLOB data not stored in partitioned table
Summary: CLOB data not stored in partitioned table
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: Sun Solaris
: P3 minor (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-29 10:47 EDT by mappers16 CLA
Modified: 2022-06-09 10:31 EDT (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description mappers16 CLA 2011-03-29 10:47:03 EDT
Build Identifier: Eclipselink Version 1.0.0.0_1.0

We have recently restructured our tables to range partitioning on 
created date (created_dt added to PK), and XML docs are no longer
being stored into a CLOB column. 

Platform:
Redhat Linux 2.6.18
Java 1.6_0_2
Oracle database 11.2.0.2
Eclipselink 1.0.0.0_1
jdbc lib -- ojdbc6.jar

The JPA logs show this sequence:

Execute query InsertObjectQuery(TestBean@c26efe Test Id, [79], Create Date[xxxxxxx], Document[<?xml version=........], JPA Lock[null])
INSERT INTO TEST_TABLE(TEST_ID,CREATED_DT,DOCUMENT,JPA_LOCK)VALUES(?,?,?,?) bind=>[79,2011-03-24 20:29:51, ,1]
SELECT DOCUMENT FROM TEST_TABLE WHERE ((TEST_ID = ?) AND (CREATED_DT = ?)) FOR UPDATE
bind=> [79, 2011-03-24 20:29:51]

This statement occurs next on successful insert of the data in a non-partitioned table, but is not present on partitioned table insert:
Writing CLOB value(size = 241 bytes) through the locator to the table field: DOCUMENT

We are using these annotations on the Entity

@Entity
......
@Lob
@Basic(fetch=FetchType.LAZY)
@Column(name="DOCUMENT")
protected String document_;


Reproducible: Always

Steps to Reproduce:
1. Insert an Entity into a table which contains a CLOB column
2.
3.
Comment 1 mappers16 CLA 2011-03-29 14:27:54 EDT
I received a comment from a post to Oracle OTN and
following the suggestions, removed the @Lob annotation
and problem is solved.
Comment 2 Tom Ware CLA 2011-04-06 08:31:39 EDT
Setting target and priority.  See the following page for the meanings of these fields:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines

Community: Please vote for this bug if it is important to you.  Votes are one of the main criteria we use to determine which bugs to fix next.
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:31:11 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink