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)

Key: NUCRDBMS-209
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
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 : "CLOB(1073741824)" is generated for DB2 (9.1) but can't be consumed by DB2 (9.1)

Created: 25/Jun/09 08:19 PM   Updated: 20/Oct/10 09:30 AM   Resolved: 13/Oct/10 11:09 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
jdbc-type="CLOB" generates "CLOB(1073741824)", however during runtime, DB2 (9.1) complains
    Error Code: -355 state: 42993
which means "too large".

Proposal:
CLOB(column/@length) if column/@length is specified
"CLOB" if column/@length is *not* specified

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

Andy Jefferson added a comment - 13/Oct/10 11:09 AM
SVN trunk uses the users column length if provided otherwise falls back to the JDBC driver info ... in this case will use CLOB(2147483647).