Oracle Database Discussions

Hi guys,

Sorry that I am raising an already discussed and debated topic. But recently I got into a debate with my boss about DB versus java.

I am pl/sql programmer and an oracle user and have very limited knowledge in java and I am saying that everything that is related to data in DB should be done in DB, in SQL and PL/SQL. and let oracle to use any caching mechanism and any enhancement that it has. Data should stay close to DB.

His/the other version was:
- it is very expensive to 'add new hardware' to work with oracle DB. The license is very expensive and the decision was to move any processing out of the DB and put it in java applications servers. Load the result of any sql in java and do the processing there.
- Java has elegant mechanism to cache things. and you can put the result of an SQL in memory and can be used by entire application.(has oracle something similar except SGA....la cache)
- Procedures are helpful because you will not do roundtrips from java to DB. but if this is not the case, we will do everything in java.


Can you please help with this? Give me your opinion and any link/documentation that you have with other discussions.

Thanks a lot for your time.