Issue Details (XML | Word | Printable)

Key: NUCRDBMS-211
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 : 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 LOB.zip (2 kB)

Environment: Linux, Java 5, DB2 9.1.0.2

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"

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

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.