Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 369612

Summary:	[DB] Value 32672 is too large as default size of VARCHAR on Oracle
Product:	[Modeling] EMF	Reporter:	Ales Dolecek <ales_d>
Component:	cdo.db	Assignee:	Stefan Winkler <sw2312+bugs>
Status:	CLOSED DUPLICATE	QA Contact:
Severity:	normal
Priority:	P3	CC:	erdal.karaca.de, stepper
Version:	4.2
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Whiteboard:

Description Ales Dolecek

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

2012-01-25 02:23:18 EST

duplicate of bug 344233

Comment 2 Eike Stepper

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

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

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 ***