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 : sql-type="CLOB" & sql-type="BLOB" aren't exactly honored towards DB2

Created: 25/Jun/09 09:53 PM   Updated: 20/Oct/10 09:30 AM   Resolved: 13/Oct/10 11:13 AM
Component/s: Types
Affects Version/s: 1.1.3
Fix Version/s: None

File Attachments: 1. Zip Archive (2 kB)

Environment: Linux, Java 5, DB2

Datastore: IBM DB2
Severity: Production

 Description  « Hide
SchemaTool 1.1.3 still generates "CLOB(1073741824)" although sql-type="CLOB"
and "BLOB(1073741824)" although sql-type="BLOB"

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

Yang ZHONG made changes - 25/Jun/09 09:54 PM
Field Original Value New Value
Attachment [ 10968 ]
Andy Jefferson made changes - 10/Dec/09 11:14 AM
Summary sql-type="CLOB" & sql-type="BLOB" aren't exactly honored towards DB2 DB2 : sql-type="CLOB" & sql-type="BLOB" aren't exactly honored towards DB2
Andy Jefferson added a comment - 13/Oct/10 11:13 AM
Same as NUCRDBMS-208, i.e you seem to think that the sql-type will include the length/precision/scale yet that is not DataNucleus interpretation of the spec - DN just takes it as the SQL *type*. As per NUCRDBMS-209, if you specify "sql-type" of "CLOB", it now creates CLOB(2147483647) which is valid.

Andy Jefferson made changes - 13/Oct/10 11:13 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Duplicate [ 3 ]
Andy Jefferson made changes - 20/Oct/10 09:30 AM
Status Resolved [ 5 ] Closed [ 6 ]