Re: WebObjects and Oracle and Openbase
Re: WebObjects and Oracle and Openbase
- Subject: Re: WebObjects and Oracle and Openbase
- From: Owen McKerrow <email@hidden>
- Date: Wed, 8 Feb 2006 16:44:01 +1100
Hi Mark,
See below.....
On 08/02/2006, at 3:36 PM, Mark Morris wrote:
Hello Owen,
Over the years I've used much more Oracle than any other db with
WO, and I can't think of any gotchas. Primary key support is
handled via sequences, which EOModeler will create and even
initialize properly for you.
Could you please explain that a bit further ? Do you mean I still
don't need the EO_PRIMARY_KEY table ? I just set the primary key in
orcale and in the model and they sort themselves out so its always up
to date ?
Stored procedures and functions work. No extra framework is required.
I don't have any experience migrating OpenBase over. SQL*Loader is
the tool usually used to populate data from flat files. However,
there was a post in this group recently about a utility I've never
tried that is supposed to move data to and from databases, using
text as the intermediate form:
/System/Library/WebObjects/JavaApplications/javaeoutil.woa/javaeoutil
Good luck!
We were going to try the database transfer functionality of SQL4X
Manager ( http://www.dbsuite.de/?
action=product&actionid=sql4xmanagerj ) which supposedly not only
does data, but also tables/whole schemas as well between a different
database types. I'll keep the list updated on how that goes.
But if that fails, I will look into the Util you have suggested.
WebMaster, emlab
http://emlab.uow.edu.au
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - -
"As of tomorrow, employees will only be able to access the building
using individual security cards. Pictures will be taken next
Wednesday employees will receive their cards in two weeks."
- "Dilbert Quotes" Winner, Fred Dales, Microsoft Corp
_______________________________________________
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