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).