Google Answers Logo
View Question
 
Q: Deploying Oracle forms applications on web: How? 9iAS? Convert to Cold Fusion? ( No Answer,   1 Comment )
Question  
Subject: Deploying Oracle forms applications on web: How? 9iAS? Convert to Cold Fusion?
Category: Computers > Programming
Asked by: lefty216-ga
List Price: $10.00
Posted: 30 Oct 2002 11:20 PST
Expires: 29 Nov 2002 11:20 PST
Question ID: 93351
I have a lot of investment in database applications developed with
Oracle Developer with Oracle Forms and Reports 6i.  I want to deploy
these applications over the web while minimizing programming changes
and effort.

Right now we have three ways to do this: 

1. Deploy using the Oracle Web Application Server (we have 9iAS)...
but that requires the Oracle Java Initiator, which is slow to load,
and uses Java, and I think they're pretty ugly afterwards.  

2. Re-write the application with a Cold Fusion front end... this makes
them usable by a variety of browsers, no java, prettier, 508
compliant, etc., but the re-writing is very time consuming, especially
when there's a lot of validation smarts and parent-child relations
happening in the Oracle form.  These Oracle folks already know how to
do some much within forms... I hate to have them start from scratch
somewhere else.

3. Deploy the whole application using Citrix.  But that's a whole
differrent set of headaches to deal with, and the Citrix client often
requires installation, and I don't have confidence in its ability to
scale here at my operation.

These apps are not particularly database intensive, they mostly
collect and validate data, format it, report on it (Oracle Reports,
mostly) and the user base is from 50-250 total, with perhaps 1/3 of
those active at any given time.

I do have some Cold Fusion developers on staff, enough to maintain,
but not enough to rewrite everything we do.

Is there a better solution for me?  Like is there something that could
automatically convert the Oracle forms to Cold Fusion?  If not, how
should I deploy these applications?

Take your time answering.  I do expect some thought on which strategy
is best, or if I should adopt another one entirely, some reasons why I
should.

Thanks!
Answer  
There is no answer at this time.

Comments  
Subject: Re: Deploying Oracle forms applications on web: How? 9iAS? Convert to Cold Fus
From: sk33n4n-ga on 01 Nov 2002 17:41 PST
 
I personally would use Cold Fusion - It's simple to develop in, and
for verification, you could even put your validation rules into a
database and just write a simple cf page to check that DB when it
validates your fields.  You can not convert the forms from Oracle to
CF, but you could start by releasing what you have now to your users,
and slowly switch the forms over to ColdFusion.  I have a lot of
reports in BRIO that I'm having to move over one-by-one, and the users
end up liking the CF versions of my reports a lot more.
You could also have CF export some of the reports to Excel via XML or
csv if you just need straight data.
I've been using CF for 2 years now, developing and maintaining
databases for 5+ years, and I can say that I haven't found a better
dev. environment for web apps.
Consider doing a slow switchover; I feel this would be best for your
situation.
-Shaun

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy