Skip to main content



      Home
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 Go to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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:
  


Current Time: Tue Jul 08 12:02:38 EDT 2025

Powered by FUDForum. Page generated in 0.07457 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top