Home » Developer & Programmer » Forms » Is it wise to enclose Business Logic in a jar file in Forms10g Application
icon6.gif  Is it wise to enclose Business Logic in a jar file in Forms10g Application [message #229606] Mon, 09 April 2007 06:37 Go to next message
Messages: 5
Registered: April 2007
Location: Sri Lanka
Junior Member


We are going to design a new system for one of our group companies. They are in financial sector. What we are going to design and develop is a loans module. All the loan types, their characteristics and calculations differ from one another. They are very complex calculations which expect to return most accurate results. We have decided to use Oracle 10g Forms and Reports and will be deployed on Oracle Application Server.

There are several kinds of loans they are dealing with. Those are having different characteristics and we have an idea of designing loans part of the system with Java in object oriented way. We will enclose all calculations in java objects which will finally be bundled to a single jar file and stored in Oracle database. We will mainly develop the system with Oracle Forms and for Loans part, we will pass the values/parameters to jar file which is stored in the database, calculate figures and return those calculated values back to the form/store in the database. The rationale behind this is to keep the business logic in a separate jar file and later we will be able to use it effectively, when we want to convert our application to java/j2ee (may be with JDeveloper). If we will move to SOA in future, we will easily be able to use that jar file in our services to serve different kinds of applications.

We have expertise on Java/J2ee/Oracle Developer/AS and if any of you can advise on our new strategy (pros and cons of this idea), please reply. This is a mission critical application. Sometimes this may not be the best idea to enclose business logic in several java classes which bundled to a single jar file and to keep that jar file in Oracle database. That’s why your kind advice is very important for us.

Thanks and best regards,
Re: Is it wise to enclose Business Logic in a jar file in Forms10g Application [message #230097 is a reply to message #229606] Tue, 10 April 2007 20:43 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I am a strong advocate of database resident rules. If you were to store your information in tables then I would suggest having the rules in PL/SQL. As you have the rules in Java then storing the Java in the database is the 'way to go' as Java does number crunching faster than PL/SQL, although compiled PL/SQl is pretty fast.

Previous Topic: LOV AND When validate item
Next Topic: How to change the initial value of a radio group at runtime (Merged)
Goto Forum:

Current Time: Sun Aug 20 10:32:48 CDT 2017

Total time taken to generate the page: 0.10112 seconds