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: Thu, 9 Feb 2006 08:50:06 +1100
Hi Guys,
Thanks for the responses. I don't plan on using any stored
procedures, I prefer to keep all the "smarts" inside the app.
Just to show you how clueless I really am when it comes to Oracle. I
don't even know what sequences are. I guess I had better go start
reading some intro to Oracle books :)
Owen
On 09/02/2006, at 1:21 AM, Mark Morris wrote:
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.
Owen McKerrow
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