One Model and two databses: MySql and Oracle
One Model and two databses: MySql and Oracle
- Subject: One Model and two databses: MySql and Oracle
- From: Dmitri Barosnikov <email@hidden>
- Date: Wed, 31 Mar 2010 10:51:40 +0200
Hi everyone,
using some model to save some text in db. text could be very large, so i
used "external type" LONGTEXT for mysql. Than some day gone to the
ORACLE, on some other server. The text from this column wasnt be able to
read anymore. So i switched the "external type" to CLOB for this server.
An this is a game i play every release now, t not forget to change
plists dependable on the databse i will use on this particular server.
i thought i could go though: EOModelGroup.defaultGroup().modelNamed("")
and find my models and than just change the external tpyes of those
trouble collumns to some type depending of the Db i use now, which i can
find out by looking into connection dictionary of that model in the
running time.
Before i do this iwanted to ask if any of you have same problems, and
have found some other solution to fix this? And why is ther Problem with
CLOB, LONGTEXT only and not for example with Integer, or DATETIME, which
have diff types under ORACLE and mysql too.
thanks in advance,
Dmitri Barosnikov
__________ Hinweis von ESET Smart Security, Signaturdatenbank-Version 4986 (20100330) __________
E-Mail wurde geprüft mit ESET Smart Security.
http://www.eset.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden