Issue Details (XML | Word | Printable)

Key: NUCRDBMS-210
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Yang ZHONG
Votes: 0
Watchers: 0
Operations

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 LOB.zip (2 kB)

Environment: Linux, Java 5, DB2 9.1.0.2

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"/>

Thanks!

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 LOB.zip [ 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 ]