Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 369612 - [DB] Value 32672 is too large as default size of VARCHAR on Oracle
Summary: [DB] Value 32672 is too large as default size of VARCHAR on Oracle
Status: CLOSED DUPLICATE of bug 344233
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.db (show other bugs)
Version: 4.2   Edit
Hardware: PC Windows 7
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Stefan Winkler CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-24 19:53 EST by Ales Dolecek CLA
Modified: 2012-11-02 04:21 EDT (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ales Dolecek CLA 2012-01-24 19:53:51 EST 
Build Identifier: 4.0.1.v20110818-0735

I'm trying to use OracleSQLAdapter from bug 270428, but run into problem with 

org.eclipse.emf.cdo.server.db.mapping.AbstractTypeMapping#getDBLength(DBType type)

since the value used as default VARCHAR size 32672 is too large for Oracle VARCHAR datatype. Oracle allows max 4000 cahracters for VARCHAR.

I have run into this with the 'source' attribute of 'Annotation' class in package http://www.eclipse.org/emf/CDO/Etypes/4.0.0.

While lowering the default might be better it would be sufficient to annotate the attribute with CDO specific annotation to explicitli set maximum length of the attribute value.

The best would, however, be to implement delegation to adapter as stated in the TODO comment on the source line that sets the default.


Reproducible: Always

Steps to Reproduce:
Try to create schema in Oracle.
Comment 1 Erdal Karaca CLA 2012-01-25 02:23:18 EST 
duplicate of bug 344233
Comment 2 Eike Stepper CLA 2012-08-14 22:51:19 EDT 
Moving all open issues to 4.2. Open bugs can be ported to 4.1 maintenance after they've been fixed in master.
Comment 3 Erdal Karaca CLA 2012-11-02 04:13:20 EDT 
(In reply to comment #1)
> duplicate of bug 344233

Eke, this is a duplicate of the already fixed bug 344233
Comment 4 Eike Stepper CLA 2012-11-02 04:21:38 EDT 
Most likely. I can't test with Oracle so I rely on someone else to do and reopen bug 344233 in case of problems.

Good catch!

*** This bug has been marked as a duplicate of bug 344233 ***