• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: WebObjects and Oracle and Openbase
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: WebObjects and Oracle and Openbase


  • Subject: Re: WebObjects and Oracle and Openbase
  • From: Mark Morris <email@hidden>
  • Date: Tue, 7 Feb 2006 22:36:16 -0600

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. 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!

Regards,
Mark

On Feb 7, 2006, at 9:36 PM, Owen McKerrow wrote:

Hi All,

I've been working with WebObjects for over 5 years now and so far all of my projects I have been lucky enough to just have used OpenBase at the back end. However for my current project we have to use a Oracle DB. In fact we need to take an existing OpenBase DB over to it.

Having only ever briefly dabbled with Oracle in a database course way back in Uni I was wonder if there are any tips people could give me when working with WO and Oracle.
I think Im going to find out just how much OpenBase has been holding my hand and helping me along without me knowing it for all these years. For example do I need to start using EO_PRIMARY_KEY table or is there an equivalent to the OpenBasePrimaryKey.framework out there for Oracle ?


And if any one has any tips/experience they would like to share in shifting an OpenBase DB over to an Oracle one I would love to hear that as well.

Thanks very much

Owen McKerrow
WebMaster, emlab
http://emlab.uow.edu.au
_______________________________________________
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


  • Follow-Ups:
    • Re: WebObjects and Oracle and Openbase
      • From: Owen McKerrow <email@hidden>
    • Re: WebObjects and Oracle and Openbase
      • From: "Jerry W. Walker" <email@hidden>
References: 
 >WebObjects and Oracle and Openbase (From: Owen McKerrow <email@hidden>)

  • Prev by Date: Re: Many-to-Many inside same Entity
  • Next by Date: Re: WebObjects and Oracle and Openbase
  • Previous by thread: WebObjects and Oracle and Openbase
  • Next by thread: Re: WebObjects and Oracle and Openbase
  • Index(es):
    • Date
    • Thread