Eclipse Community Forums: EMF "Technology" (Ecore Tools, EMFatic, etc)

Help

Home

Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » [Teneo] VARCHAR2 issue with Oracle

Show: Today's Messages :: Show Polls :: Message Navigator

[Teneo] VARCHAR2 issue with Oracle [message #1184583]

Wed, 13 November 2013 14:58

John M.

Messages: 198
Registered: July 2010

Senior Member

Hello,

I have a simple model, which should be used on MySQL and Oracle.
There is a column, which can contain text (max 4000 characters).

I have changed for MySQL the type to text with annotations. In this case we haven't any limitation of size (at the moment).
For Oracle the type text isn't enough. The Oracle10gDialect converts the field to a VARCHAR2 with 255 characters.
I have tried to use the length annotation, which results that the column becomes a LONG in Oracle.
When I remove the type text it works.

Is there no possibility to have both annotations to get it working for both databases?

Report message to a moderator