RE: Stored procedures and J2EE

[The elephantwalker]

A bean is just a representation of data in a datastore with a collection of finder and business methods. You can use cmp's to access data which is already in a datastore.

 

A stateless session bean can be used to fire off your create procedures, and this slsb can be in your cmp create (or not, for that matter).

 

As for distributing your business logic between the datastore and middle tier...aren't you making your life more complex than it needs to be? There is absolutely no hit on performance if you pull out all of your business logic into a slsb or cmp...there's just no need to use store procedures any more.

 

If you are doing this to filter your output or because you need custom joins, etc. there are much easier ways to do this...such as using a custom finder method in orion (its a five minute job in the orion-ejb-jar.xml file) or a slsb.

 

regards,

 

the elephantwalker

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cristian Donciulescu
Sent: Thursday, September 06, 2001 1:41 AM
To: Orion-Interest
Subject: Stored procedures and J2EE

Is it possible (and recommended) to use stored procedures with the J2EE architecture? We would be interested in creating objects directly into the database, bypassing the create method of the enterprise bean. Is this possible when using CMP (Container Managed Persistence)? If not, in your opinion, which is best: using BMP and stored procedures or using CMP?

 

Example: We have an Oracle DB that uses packages associated to the business objects of the system. These packages contain the PL/SQL methods of the corresponding business objects.  Additionally every business object’s fields are stored as columns of a specific table. The constructor of a business object is also a method in the associated package. The inheritance relation between two objects is modeled by making the primary key of the child object’s table reference the primary key field of the parent object’s table. This reference means that the child inherits the fields of the parent. Thus, the constructor of a child object, which is passed all the parameters required for itself and its parent’s initialization, will call the constructor of its parent passing the appropriate parameters. The question is:

 

How could such constructors be used without conflicting with the create methods of the CMP entity beans?

---

Get your FREE download of MSN Explorer at http://explorer.msn.com