Green field architecture.

I am involved in designing the architecture for a green field web application. Oracle 11g on the back end, tomcat at the front. No fully fledged apps server in the middle tier. I can't see why the business logic can't be handled by pl/sql in the database, with the functionality exposed to tomcat via stored procedures. It makes sense to me to do the business logic in the database (very close to the data) rather than to drag data back and forth between the apps server and the database. I have investigated all the custom context stuff for dealing with these lightweight database users comming in via connection pools and it all seems to work a treat.

The Oracle database is so rich in functionality for using web services, messaging etc that I am really struggling to see the point of a J2EE Apps server. Of course portability is one argument, though in my experiance just because your app is completely written in java, doesn't make it portable. Plus we will be really trying to take advantage of oracle specifc functionality, so wont be wanting to port from there anyway.

Before I went too much further I thought I would run this idea past those on this group, to see if I have missed any obvious problems with this architecture.

Any comments gratefully recieved.

Ralph Received on Tue Jan 12 2010 - 09:27:39 CST