Re: WebObjects and Oracle and Openbase
Re: WebObjects and Oracle and Openbase
- Subject: Re: WebObjects and Oracle and Openbase
- From: wojingo <email@hidden>
- Date: Wed, 08 Feb 2006 16:04:48 +1030
Hi,
I have been using oracle with WO since 1999 and the only issue I can
think of is with the ordering of arguments for stored procedures being
wacked (not sure if this was just an Oracle problem or not). The company
I used to work for had a few apps that used stored procedures instead of
EOF(not pleasant IMO) and one of the guys wrote some code to
automatically fix the problem during a build. All of the apps were using
oracle 8.
I dont remember the full details but I think a couple of guys i worked
with are lurking on the list, they might be able to shed some light on
this... I can probably find out what the problems were and the
workaround if it comes to the crunch.
If your not using stored procs then there is nothing I can think of that
will cause you any grief. Everything seems to 'just work'(tm).
Of course YMMV.
regards,
- shaun
Jerry W. Walker wrote:
Hi, Mark and Owen,
Mark is referring to javaeoutil which was described in a message to
this list from Joseph Leo Moreno ( email@hidden ) on February 4,
2006 6:25:29 PM EST.
It's a great, if not well documented, utility.
You might also check this message:
http://lists.apple.com/archives/Webobjects-dev/2003/Nov/ msg00621.html
Regards,
Jerry
On Feb 7, 2006, at 11: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. 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:
40gmail.com
This email sent to email@hidden
--
__ Jerry W. Walker,
WebObjects Developer/Instructor for High Performance Industrial
Strength Internet Enabled Systems
email@hidden
203 278-4085 office
_______________________________________________
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
_______________________________________________
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