EJB using Stored Procedure?

[ramana kittu]

Hi All,

Any body know the ejb with stored procedue calling,

I have a ejb application, i need to implement stored procedure and use it in ejb, with weblogic server.

please help me out from this problem.

Thanks in advance.

[Jimmy Clark]

Study the Data Access Object object-oriented design pattern.

[ramana kittu]

could you please tell me that websites for related that stored procedure callin with EJB.

Thanks,
Ramanakittu

[Jimmy Clark]

Everything about developing software is not on a "web site" waiting for you to find it with a ?oogle search.

If you learn about how to implement the Data Access Object design pattern and know how to program Enterprise JavaBeans, then you should not have any problem with executing a stored procedure from an Enterprise JavaBean.

Below is a guide to help you find what you are looking for.

...
// EJB management and life-cycle methods 
...
public int executeMyStoredProcedure(int x) throws javax.ejb.EJBException {     
     DatabaseDAO y = new DatabaseDAO();
     return y.executeMyStoredProcedure(x);
 
}

[ramana kittu]

thanks alot clark,

My Application was alreay developed by somone,

the architecture is like struts-->ejbSessionBeans(Remotely)-->ejbEntityBeans(locally calling from sessionbeans ).

the above architecture is giving performance issue because there are looping business logic from session to entitybeans, so network tropic is arrived,

now i have to change my architecture for some part(2 or 3 sessionbeans) where the looping concept is came. the architecture is would be struts--->sessionbeans---->
PL/SQL Stored Procedure(Replace with Entity Beans),

1) so we need to write pl/sql stored procedure code(is required any configuration in ejb-jar.xml or else?)

2)how to access that pl/sql code in our SessionBeans?

3)how to do all thease configurations?

could you please tell me with example code if any body knows?

Thanks in advance,
RamanaKittu

[Phani Raju]

There are multiple ways of accomplishing this, below I list couple:

Using plain JDBC: You can write the jdbc code for calling the stored procedure using callable statements.

Using some ORM framework like Hibernate, IBatis etc. which allow the result of SP call to be mapped to a data object (a Java pojo class).

[Jimmy Clark]

2)how to access that pl/sql code in our SessionBeans?

See my code example above. This method would be in your Session EJB.

[ramana kittu]

Thanks a lot clark,

[Sarma Lolla]

This is how I am executing a stored procedure... you have to use Native query

private final static String my_query= "BEGIN my_pkg.my_proc(); commit; END;";

try{
Query query = em.createNativeQuery(my_query);
query.executeUpdate();
}
catch (Exception e){
e.printStackTrace();
}