Current position:  Home > Default > Stored procedure, EJB, JPA, and JavaServer Faces

Stored procedure, EJB, JPA, and JavaServer Faces

Time:October 11
Advertisement
Hi!
I am currently working on a Web application using EJB, JPA, and JavaServer Faces. A part of the
business logic is already stored in the database as stored procedures, so we need to call those
procedures (instead of named queries) through a EJB and represent the data on the web tier.
Where can I find an extensive tutorial using this technology? There is no such tutorial in the Oracle Learning Library.
Maybe somebody can provide a link and/or example.
Thanks in advance for your help!
Advertisement
Hi,
http://download.oracle.com/docs/cd/B10464_05/web.904/b10313/queries.htm#1135305
For more help, see the TopLink / JPA forum
TopLink/JPA
Frank

How can I get the printed message of stored procedure in JPA

2015-10-11

Hi, I'm using JPA to invoke stored procedure in database, a segment of the sproc is like below: if @create_type != 'a1' and @create_type != 'a'      begin      print 'create type must be either ''a1'' if you pass in A1 ID, or ''a'' if you pass in Use

How to passing array as parameter to oracle stored procedure from JPA

-0001-11-30

Hi All, I need to call a stored proc in Oracle that accepts an array as input parameter. Pls let me know how should i call it from my JPA. Is this even possible without using JDBC directly? i keep getting the ff error: wrong number or types of argume

Adf ejb jpa persistance problem

2015-10-11

Hi everyone, I`m a newbie to adf technology. I was trying Build a Web Application with JDeveloper 11g Using EJB, JPA, and JavaServer Faces tutorial ([http://www.oracle.com/technology/obe/obe11jdev/11/ejb/ejb.html]) I have a problem when I try to run

JDBC performance calling stored procedures

2015-10-11

Hi, We have an java application which makes calls to PL/SQL stored procedures. We have one 'database server' component which handles all the database interaction, and other components which connect to it using CORBA. The problem is that with everythi

Can JPA invoke a stored procedure with a cursor type output parameter?

2015-10-11

i use JPA ,i hope get a result set by a stored procedure , how to solve it ?thank you!i try to do,but i get a ClassCastException below is the sesion ejb : @PersistenceContext(unitName = "Model") private EntityManager em; ((oracle.toplink.ejb.cmp

EJB 3.0 Persistence API and Stored Procedures

2015-10-11

Does the EJB 3.0 Persistence API in any way prescribe or facilitate the use of Stored Procedure calls? Given the recent popularity of using (database) server APIs consisting of Stored Procedures that are addressed by ORM frameworks for performing the

Calling stored procedure from EJB in JSever

2015-10-11

I have some trouble to call stored procedure from EJB deployed to JServer on Oracle8i (815). I have been able to sucessfully test the stored procedure using thin client JDBC driver. But when I user the default connection in JServer, the stored proced

EJB from stored procedure lookup problem

2015-10-11

We are running a test case with in an EJB deployed to Oracle 8.1.6, accessing it from a Java stored procedure. It works okay if the stored procedure is called a limited number of times from a single client (client is non-Java). However, for performan

Calling EJB from Java Stored Procedures

2015-10-11

Hi, I am trying to call an Enterprise Java Bean from stored procedure. This stored procedure calls a java program. As long as it is a simple java program it works fine and loadjava.exe does not give any problem (neither compile-time nor run-time). It

Using Stored Procedures with TopLink / JPA : Success explanation

-0001-11-30

For those who have to use Stored Procedures in TopLink this is my success history : To call an Stored Procedure from the persistence, we have to use the direct JDBC connection because my TopLink version ( Essentials 10g ) ? to date ( 10g ) does not h

Can I call a stored procedure from EJB?

-0001-11-30

Hi, Can I call a regular (non-Java) stored procedure from an enterprise Java bean? Transaction is managed by the ejb application server. Thank you for your response. CThi, i saw your question in the forum....have you got a response since mars because

Calling an EJB deployed in OC4J from a Java Stored Procedure

-0001-11-30

Hi all, Well, I've been trying to figure this out for a bit now and haven't come up with a solution. I have a Java Stored Procedure in a 9i database and would like to call an EJB deployed in the OC4J Container but DO NOT want to load the various Orio

How to call EJB deployed on OC4J from java stored procedure?

-0001-11-30

Hello, I'd like to call EJB from java stored procedure. My example works fine from command line, but the problem seems to be with deployment of this code into database. Especialy I'm wondering how to reference jars like oc4jclient.jar, ejb.jar, ... f

Stored Procedure calling from EJB

-0001-11-30

Can i call a stored procedure from a EJB. First time attempt. IF some details available will help me a lotYou may just use JDBC to call a stored procedure from a BMP bean. Below is a section from the "Oracle JDBC Developer's Guide and Reference"

EJBs and Stored Procedures

-0001-11-30

Hello! I want to bind an EJB (probably an BMP entity bean) to the result of a stored procedure. Can this be done? Are there any examples? thxYou would be after the JDBC CallableStatement interface which is part of JDBC 2.0 Most of the EJB books have

EJB Entity beans ,JDBC Stored procedures

-0001-11-30

Hi , I am new to EJB and i have some general questions ---Every table in an existing database is an entity bean for my application? --- how do i define the queries in the entity bean ? (With PreparedStatement ?) ---The persistent fields,the ejbmethod

Stored procedure in Ejb 3

-0001-11-30

Hello friends I am working a project .my objective is to call stored procedure in the ejb session bean class.but each time i am getting same following problem Project : javax.ejb.EJBException: EJB Exception: ; nested exception is: +     Exception [Ec

Calling JPA from a Java Stored Procedure

-0001-11-30

Is it possible to call JPA from a java stored procedure? If so, does anyone have example? How do you setup the persistence.xml? How does the peformance compare with straight JDBC in a java stored procedure? Thanks for any help! JohnnyHi Johnny: Basic

How to execute a stored procedure using Nqcmd

-0001-11-30

hi everyone, I am having a stored procedure in Database which i want to execute it from nqcmd. Could anyone pls let me know how to execute it. RegardsEJB3 JPA does not define stored procedure execution. There is a native query in JPA, but this is mai