DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
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 ]