Why I joined?

[CUNEYT]

Hi All,

 

We have an Oracle Forms application that we’ve been working on since 1996. Last year at OOW Grant Ronald said something like “If you are happy with Forms there is no reason to drop it unless you have a strong business case” and he adviced considering Forms Modernisation. Very good advice. Considering the amount of time and money invested in Forms we decided to keep using Forms till and maybe start a gradual migration till we run into a strong business case.

 

Well we ran into a strong business case right before the OOW 2010. Our biggest client came to us and said “We don’t want any business logic in the database anymore. Move the business logic to the middleware”. Wow, we were thinking of a gradual migration to ADF and we were worried obout financing the project and now we had a client who was willing to pay for it. Our happiness did not last long. Here comes our client’s second demand “ No PL/SQL in the database, even in DB table triggers!!! ”. The client already has Weblogic and OSB 10g. Wants us to deploy everything as web services but demands tha we get rid of all the PL/SQL and use Java. Why ? Because the client is big bank and all they had was DB2 and apperantly DB2 did not have triggers and SPs until recently.

 

I know that there is no silverbullet for this. Has anyone tried this before? Any suggestions ? Any benchmarks to help me change my client’s mind. I believe that moving all the business logic including the DB triggers to the middleware will drastically reduce the performance of our application.

 

In the meantime. I’ve realy enjoyed the correspondence in the group. I have to admit that I was very impressed with how strong JDeveloper has become and I really learned a lot at ADF sessions at OOW this year.

 

 

Regards, 

 

Cüneyt Taşlı 
Managing Partner

Geneks International Yazılım ve İletişim

Teknolojileri Ltd.Şti. 
Üst Denizbank Sitesi No:20 34467 Reşitpaşa 

Sarıyer, İstanbul - TURKEY

Tel:       +90 212  2772177 
Faks:    +90 212  2773494  
cun...@geneks.com.tr

www.geneks.com.tr

 

[Mark Robinson]

Hi Cüneyt,

I'm involved with a project where we are replacing a Forms front-end with ADF.  The Forms project has a significant amount of logic in packages, triggers and inside the Forms themselves.

What we've decided is to port the UI over to ADF first and generally leave the back-end alone as much as possible.  Once we have finished the UI port, we will look into redesigning the back-end.  For us, we decided to skip ADF BC and all that.  Instead we based our business logic on EJBs.  They're standard, portable and quite powerful.

I've heard that PL/SQL is faster, but the only actual measurement I have seen proved out that Java business logic is faster; this was a GIS application so YMMV. 

Mark

2010/10/9 CUNEYT <cun...@geneks.com.tr>

--
You received this message because you are subscribed to the ADF Enterprise Methodology Group (http://groups.google.com/group/adf-methodology). To unsubscribe send email to adf-methodolo...@googlegroups.com
 
All content to the ADF EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the ADF EMG with a link to the Google Group (http://groups.google.com/group/adf-methodology).

[Sten Vesterli]

Wow, that's an interesting situation!

I'm currently writing a book called "Enterprise Applications with
Oracle ADF", and I'll give you a quote from chapter 3:

"If you need to cut one log into planks, you can call a friend and get
out your two-man saw. But if you need to cut a hundred logs, you ask a
sawmill to do it.

If you need to process one data record, you can retrieve it from the
database, process it in the application server and store it back in
the database. But if you need to process a hundred, a thousand or a
million records, you ask the database to do it.

If your application calls for this kind of batch processing, your team
needs to include database programmers who can build stored procedures
in your database. If your application is based on an Oracle database,
the language of choice is PL/SQL."

I think you are right in thinking of a benchmark, but you should
probably create your own. I suggest taking an example PL/SQL procedure
processing a lot of records and re-developing it in Java. Then run
both from the application server - one Java program simply calling the
PL/SQL procedure and another Java program retrieving the records and
doing the processing. That should give you some hard numbers for
comparison.

Basing everything on web services instead of ADF business components
is going to be harder and more expensive, but he who pays the piper
calls the tune.

I hope you can at least convince your customer to leave the batch
processing in the database, because that's where it belongs.

Best regards and good luck,

Sten Vesterli
----------
Blog: www.vesterli.com Mail: st...@vesterli.com Twitter:
http://twitter.com/stenvesterli

>  <mailto:cun...@geneks.com.tr> cun...@geneks.com.tr
>
> www.geneks.com.tr