Re: WebObjects and Oracle and Openbase
Re: WebObjects and Oracle and Openbase
- Subject: Re: WebObjects and Oracle and Openbase
- From: Mark Morris <email@hidden>
- Date: Wed, 8 Feb 2006 08:21:43 -0600
Hi Owen,
As Shaun said in another post, you don't use the EO_PRIMARY_KEY
table, you use sequences. EOModeler will create them and even try to
check the highest current pk value and roll the sequence up to that
number.
I had forgotten to mention the stored procedure parameter issue
(mentioned in a different post). EOF seems to send the parameters in
alphabetical order, so I just got into the habit of naming them (in
EOModeler, not in the database) things like "a_firstName" and
"b_startDate" or whatever.
Regards,
Mark
On Feb 7, 2006, at 11:44 PM, Owen McKerrow wrote:
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.
_______________________________________________
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