Issue Details (XML | Word | Printable)

Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Yang ZHONG
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

DB2 : column/@length should have been honored for CLOB

Created: 25/Jun/09 08:30 PM   Updated: 20/Oct/10 09:30 AM   Resolved: 13/Oct/10 11:15 AM
Component/s: Types
Affects Version/s: 1.1.3
Fix Version/s: 2.2.0.m2

File Attachments: 1. Zip Archive (2 kB)

Environment: Linux, Java 5, DB2

Datastore: IBM DB2
Severity: Production

 Description  « Hide
JDO specification 2.2 (page 223) has specified
"The length attribute declares" "the maximum number of characters in the datastore representation of String types"

<column name="string" jdbc-type="CLOB" length="1024"/>
generates "CLOB(1073741824)" which should have been "CLOB(1024)"

At the same time, it would be nice to honor column/@length for BLOB too such as
<column name="bytes" jdbc-type="BLOB" length="1024"/>


Yang ZHONG added a comment - 25/Jun/09 08:31 PM
Can't test against 1.1.4 due to NUCRDBMS-205

Yang ZHONG made changes - 25/Jun/09 08:31 PM
Field Original Value New Value
Attachment [ 10967 ]
Andy Jefferson added a comment - 10/Dec/09 10:13 AM
This is only for DB2; other datastores like Oracle don't allow precision on BLOB/CLOB

Andy Jefferson made changes - 10/Dec/09 10:13 AM
Summary column/@length should have been honored for CLOB DB2 : column/@length should have been honored for CLOB
Andy Jefferson added a comment - 13/Oct/10 11:15 AM
Was fixed as part of NUCRDBMS-209

Andy Jefferson made changes - 13/Oct/10 11:15 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.2.0.m2 [ 11023 ]
Resolution Duplicate [ 3 ]
Andy Jefferson made changes - 20/Oct/10 09:30 AM
Status Resolved [ 5 ] Closed [ 6 ]