Java 从 Oracle Forms 6i 迁移到 Web 的最佳解决方案？

Best solution for migration from Oracle Forms 6i to the web?

提问by mwilliams

I work in an Oracle shop. There's a toolset that consists of roughly 1000 Oracle Forms (using the Forms builder from 6i, early 90's software) with Oracle 10g on the back end. It's serving roughly 500 unique people a month, with 200 concurrent connections at any given time during the work day.

我在 Oracle 商店工作。有一个工具集包含大约 1000 个 Oracle Forms（使用 6i 的 Forms builder，90 年代早期的软件），后端有 Oracle 10g。它每月为大约 500 个不同的人提供服务，在工作日的任何给定时间都有 200 个并发连接。

Obviously this is something that needs to be addressed to get rid of the Forms runtime and move to a web based solution. The tools need to be accessed from Windows, Linux, various UNIX's, VMS and Solaris.

显然，这是需要解决的问题，以摆脱 Forms 运行时并转向基于 Web 的解决方案。需要从 Windows、Linux、各种 UNIX、VMS 和 Solaris 访问这些工具。

What options out there exist that would be feasible to migrate to? Not only does it need to be feasible for migration but the development will need to be done by 8 or so engineers who support the tool set (and many of which who would prefer to stay put and not modernize this tool set).

存在哪些可行的迁移选项？它不仅需要对迁移可行，而且还需要由 8 名左右支持该工具集的工程师完成开发（其中许多人宁愿留在原地而不是对这个工具集进行现代化改造）。

Oracle offers a few solutions that convert Oracle Forms into a crappy Java Applet (it's a very terrible temporary solution).

Oracle 提供了一些将 Oracle Forms 转换为蹩脚的 Java Applet 的解决方案（这是一个非常糟糕的临时解决方案）。

My solution of choice has been migrating to Ruby on Rails (which I'm a big proponent of Rails) but this will involve a learning curve (which we'll hit with any solution) for other developers. Also, the other difficulty in this is converting some very complex forms to HTML forms.

我选择的解决方案是迁移到 Ruby on Rails（我是 Rails 的大力支持者），但这将涉及其他开发人员的学习曲线（我们将使用任何解决方案）。此外，这方面的另一个困难是将一些非常复杂的表单转换为 HTML 表单。

Has anyone tackled such a solution? Are there any packages offered by anyone outside of Oracle?

有没有人解决过这样的解决方案？Oracle 以外的任何人都提供任何软件包吗？

Any specific Java Web frameworks?

任何特定的 Java Web 框架？

Would GWT, jQuery UI, ExtJS or any other JavaScript UI frameworks offer the rich user experience needed?

GWT、jQuery UI、ExtJS 或任何其他 JavaScript UI 框架能否提供所需的丰富用户体验？

.NET is a consideration but a last resort (mostly because of license costs, there's no room in the budget in addition to what we're paying for Oracle licenses).

.NET 是一个考虑因素，但也是最后的手段（主要是因为许可证成本，除了我们为 Oracle 许可证支付的费用外，预算中没有空间）。

采纳答案by Tony Andrews

That's exactly what I am currently doing using...

这正是我目前正在使用的...

Oracle Application Express

甲骨文应用程序快捷方式

The learning curve is much smaller than most web-based alternatives for Forms developers, as all the code is in PL/SQL (unless you start getting fancy with Javascript, which you can). Also, in the latest release of Application Express (3.2), there is a tool to convert Forms applications to Apex.

对于 Forms 开发人员来说，学习曲线比大多数基于 Web 的替代方案要小得多，因为所有代码都在 PL/SQL 中（除非您开始喜欢 Javascript，否则您可以这样做）。此外，在最新版本的 Application Express (3.2) 中，有一个工具可以将 Forms 应用程序转换为 Apex。

It comes free with Oracle versions since 9.2.

从 9.2 开始，它随 Oracle 版本免费提供。

回答by David Aldridge

I'll +1 for Oracle Application Express -- I think that there are some significant advantages in your situation.

我会为 Oracle Application Express +1 - 我认为在您的情况下有一些显着的优势。

1. Free licensing
2. It may bean attractive option to the current staff, if they are Oracle bigots like me.
3. It's 100% web, and in 11g doesn't even require a web tier.

1. 免费许可
2. 如果他们是像我这样的 Oracle 偏执狂，这对当前员工来说可能是有吸引力的选择。
3. 它是 100% 的 Web，在 11g 中甚至不需要 Web 层。

回答by shadit

Oracle maintains a list of vendorswho all specialize in doing exactly what you need to do.

Oracle 维护着一个供应商列表，这些供应商都专门从事您需要做的事情。

This is a very common and popular topic due to the large installed base of Oracle Forms. If you do a simple Google searchthere are lots of accounts of making this transition.

由于 Oracle Forms 的安装基础很大，这是一个非常常见和流行的话题。如果你做一个简单的谷歌搜索，有很多关于进行这种转变的帐户。

In my personal experience, we had luckily structured our Oracle Forms applications to have nice PL/SQL APIs. It was simple to re-use all the existing PL/SQL in our transition to J2EE, which we did manually. It sounds like you have too many Forms to do that efficiently, though.

根据我的个人经验，我们幸运地构建了我们的 Oracle Forms 应用程序，使其具有良好的 PL/SQL API。在我们向 J2EE 的过渡过程中重用所有现有的 PL/SQL 很简单，这是我们手动完成的。不过，听起来您有太多的表单无法有效地做到这一点。

回答by shadit

Hi i have done a similar work using GWT/springs/ORMS combination, the results are fantastic ,how ever it also depends on the complexity of business process mine was a very very complex business process, what i did was segragate all the layers and treat each layer as a service , in the process i made an application which every one goes wow and at the same time is eligible for many certifications , but if you want to do it more faster and not change the front end u can use exodus cheers

嗨，我使用 GWT/springs/ORMS 组合做了类似的工作，结果非常棒，但它也取决于业务流程的复杂性，我的业务流程非常非常复杂，我所做的是分离所有层并处理每一层都作为服务，在这个过程中我做了一个应用程序，每个人都很棒，同时有资格获得许多认证，但是如果你想做得更快而不改变前端，你可以使用 exodus 欢呼

vasem

瓦塞姆

[email protected]

[email protected]

回答by Stew S

A really late answer, but relevant. The upcoming V3.2 release of Oracle Application Express adds an Oracle Forms migration tool, which you might find improves your productivity even further.

一个非常晚的答案，但相关。即将发布的 Oracle Application Express V3.2 版本添加了一个 Oracle Forms 迁移工具，您可能会发现它进一步提高了您的工作效率。

回答by Stew S

I have found that PITSS.CON, developed by PITSS ( http://www.pitssamerica.com) is the best out there Oracle Forms Migration. Instead of doing this manually, where you can spend up a few months with a couple hundred forms or a couple years with over a thousand, PITSS.CON, enables one to migrate from any 2.3 to 10g in a matter of days. Its unbelievable what this tool can do.

我发现由 PITSS ( http://www.pitssamerica.com)开发的 PITSS.CON是最好的 Oracle Forms Migration。与手动执行此操作不同，您可以花费几个月的时间处理几百个表单，或者花费几年的时间处理一千多个表单，PITSS.CON 使您可以在几天内从任何 2.3 迁移到 10g。令人难以置信的是，这个工具可以做什么。

回答by Stew S

Hi I work for PITSS (pitssamerica.com), and I want to elaborate on what gwoods1412 stated. You can migrate from any version of Oracle Forms 2.3, 3.0, 4.0, 4.5, 5.0, 6i, or 9i to 10g. The tool also migrates your Oracle Reports, and we have a solution to cure the issue with using the Reports parameter form. Oracel Forms and Reports 10g is a Web Based Solution, so you don't have to bite off the expense of a migration to another platform.

嗨，我为 PITSS (pitssamerica.com) 工作，我想详细说明 gwoods1412 所说的内容。您可以从任何版本的 Oracle Forms 2.3、3.0、4.0、4.5、5.0、6i 或 9i 迁移到 10g。该工具还会迁移您的 Oracle 报告，我们有一个解决方案来解决使用报告参数表单的问题。Oracel Forms and Reports 10g 是一个基于 Web 的解决方案，因此您不必支付迁移到另一个平台的费用。

APEX is free to use, but it isn't free to migrate to. And the migration tool only extracts the fields (items), it does not take the Business Logic. So you are not getting your real investment out of your forms, you are getting a query and field description.

APEX 可以免费使用，但不能免费迁移到。并且迁移工具只提取字段（项），不带业务逻辑。因此，您并没有从表单中获得真正的投资，而是获得了查询和字段描述。

If you use a tool like PITSS.con, you will be testing you application on the web in a few days. Your developers will be working on other projects, and all will be right in the world. Oh yeah, you can interoperate with APEX, ADF, Java, .NET, etc once you are in 10g too. That means new development can be done in a new toolset. You start a gradual methodical migration to a new technology. Pretty nice to not have a huge launch party in two years when you can have one this month.

如果您使用像 PITSS.con 这样的工具，几天后您将在网络上测试您的应用程序。您的开发人员将从事其他项目，一切都会好起来的。哦，是的，一旦进入 10g，您就可以与 APEX、ADF、Java、.NET 等进行互操作。这意味着可以在新的工具集中进行新的开发。您开始逐步有条不紊地迁移到新技术。很高兴在两年内没有举办大型发布会，而您可以在本月举办一场。

And APEX isn't really an enterprise solution. Here's a quote from David Peake who is Oracle APEX Product Manager:

APEX 并不是真正的企业解决方案。以下是 Oracle APEX 产品经理 David Peake 的话：

"One of my key goals is to not over sell APEX conversion capabilities and ensure that attendees understand that converting Forms requires significant investment and is not going to be easy, no matter what tool you are converting to."

“我的主要目标之一是不要过度销售 APEX 转换功能，并确保与会者了解转换 Forms 需要大量投资，而且无论您转换到什么工具都不容易。”

I stole that quote from Grant Ronald's (Oracle Fusion Middleware Product Manager ) blog which can viewed at Grant's Blog

我从 Grant Ronald（Oracle 融合中间件产品经理）的博客中窃取了这句话，可以在Grant 的博客上查看

回答by DanceDisaster

You should check out this site http://www.forms2net.com/it's Migration Tool of Oracle Forms to .Net. It's pretty good stuff!

您应该查看此站点http://www.forms2net.com/它是 Oracle Forms 到 .Net 的迁移工具。真是个好东西！

回答by Ethan

You really need to check out the Forms Conversion utility from TurboEnterprise. I do not use Oracle Forms but a friend of mine has used their software to covert Oracle Forms and he loves it. They also have a free version on their website too i think. www.turbo-enterprise.com

您确实需要查看 TurboEnterprise 的 Forms Conversion 实用程序。我不使用 Oracle Forms，但我的一个朋友使用他们的软件来隐藏 Oracle Forms，他很喜欢它。我认为他们的网站上也有免费版本。www.turbo-enterprise.com

回答by F A

Oracle Migration Assistant is free. It pretty much does exactly what PITSS does for the Migration. PITSS offers some neat things that can be used going forward, which will justify the cost. But if it's a Forms Migration you need, Migration Assistant does the same job.

Oracle 迁移助手是免费的。它几乎完全符合 PITSS 为迁移所做的工作。PITSS 提供了一些可以在未来使用的整洁的东西，这将证明成本是合理的。但如果是您需要的 Forms Migration，Migration Assistant 可以完成相同的工作。

But if you do purchase PITSS, you could easily write a script to rename a set of forms to something repeatable and write a log of what the names where. Load under names like 1.fmb, 2.fmb, etc. Perform the changes. Then rename them back using another log file that references the log file. Then repeat for another set of forms. Could save you thousands per 100 forms.

但是，如果您确实购买了 PITSS，您可以轻松编写一个脚本，将一组表单重命名为可重复的名称，并记录名称的位置。以 1.fmb、2.fmb 等名称加载。执行更改。然后使用另一个引用日志文件的日志文件将它们重命名。然后重复另一组表格。每 100 个表格可以为您节省数千美元。

And the reports migration is a waste of time. You will have to open each form anyway and reposition fields, especially on the parameter form. That's all you would have to do without the PITSS tool.

报告迁移是浪费时间。您无论如何都必须打开每个表单并重新定位字段，尤其是在参数表单上。如果没有 PITSS 工具，您只需要做这些。