Re: Convert EO Model from Oracle to Derby at runtime
Re: Convert EO Model from Oracle to Derby at runtime
- Subject: Re: Convert EO Model from Oracle to Derby at runtime
- From: Chuck Hill <email@hidden>
- Date: Wed, 9 Jul 2008 15:19:05 -0700
On Jul 9, 2008, at 12:32 PM, JR Ruggentaler wrote:
No, no prototypes are used.
Well, they are designed to solve the problem that you have at hand.
You will want to convert the model to use them.
All the entities are EOGenericRecords and are modified quarterly+.
We are trying speed access to this data but we don't want to cache
these entities due to the amount of data.
The entities being EOGenericRecords does not affect whether they are
cached or not. It just means that you can't have any custom logic in
a Java class.
Chuck
On Jul 9, 2008, at 2:24 PM, Chuck Hill wrote:
Are you using prototypes in your model?
On Jul 9, 2008, at 12:17 PM, JR Ruggentaler wrote:
I have a EO model that I want to move some entities at runtime
from an Oracle database to a local Derby database. I created a new
model at run time and added the entities to the new model and
removed the same entities from the other model. Then I tried using:
EOSchemaGeneration
.createTableStatementsForEntityGroup(localModel.entities());
to generate the Derby create statements but that fails at:
EOSQLExpression.columnTypeStringForAttribute();
the external types from the Oracle model are different from Derby.
For example Derby doesn't recognize NUMBER and VARCHAR2. Is there
some way to convert a model written for one RDBMS (Oracle) to
another RDBMS (Derby)? I can manually iterate the attributes and
change the attribute external type (EOAttribute.setExternalType())
but I am hoping EOF or some one on this list has a more elegant
way of switching RDBMS on the fly in code.
P.S. I am using WO 5.4
JR
_______________________________________________
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
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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