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

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

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

Wed, 13 November 2013 09:58

Eclipse User

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?

Re: [Teneo] VARCHAR2 issue with Oracle [message #1184710 is a reply to message #1184583]

Wed, 13 November 2013 11:39

Eclipse User

The solution is very simple, just use following annotation:

@Column(length=4000)

MySQL allows varchar to 65.535 characters.

Previous Topic:	[EMFStore]EMFStore can be used in the WEB project?
Next Topic:	[Texo] NullPointerException generating Ecore from XSD

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 07 23:02:55 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter