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!

Sort Order: Ascending order - Click to sort in descending order
Yang ZHONG added a comment - 25/Jun/09 08:31 PM
Can't test against 1.1.4 due to NUCRDBMS-205

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 added a comment - 13/Oct/10 11:15 AM
Was fixed as part of NUCRDBMS-209