Re: Where do I put the business logic ??

Hi

> We are developing a web application (MSIE with VisualInterdev97) against an
> Oracle8 databaseserver. We want to put as much validating, user control etc.
> as possible in the database, to make the web-client as thin as possible.
> This is our first project of this kind for us, and we wondered how easy it
> would be to handle the various messages Oracle8 produces under variyng
> circumstances. Will it be possible for us to catch lets say Oracle error
> messages and translate them into something useful ? I'm very afraid of
> exposing a web-user to typical Oracle error messages. We could handle this
> in the client(web)-code but we don't want to do that. We would like to use
> Oracle to what its been made for and keep the client as thin as possible.
>
> There is also a solution to use a 3-tier model where we create "business
> objects" as ActiveX dll's and let the run on the web-server (the middle tier
> in this case)

Exception handling will catch any error your stored procedure will throw,that is if you are using PL/SQL which is obviously what you want to do. in the exception handler you can right different code for various exceptions.

The active x solution will work only on micosoft browsers, which is ok if you working in an intranet environment.

You coul also use borlands Jbuilder which is tightly integrated with Oracle and it is fairly easy to do forms etc, although imo it is too low level for business programming.

Or you could use vanilla pl/sql , which would allow you to store eveything in the database and keep everything in one language, the only problem with this option is that the User interface is not as flexible as other more UI intensive languages.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 00:00:00 CEST