JPA, Oracle and stored procedures

Thread view:

Curtis - 08 May 2007 18:57 GMT

Is it possible to call stored procedures while using the JPA? If so,
does anyone know where I could find documentation? My searches have
turned up very little thus far.

Thanks in advance!

Reply to this Message

Harry - 09 May 2007 04:53 GMT

What do you mean by calling stored proc in JPA? Just like using
CallableStatement when using JDBC?

Harry

> Is it possible to call stored procedures while using the JPA? If so,
> does anyone know where I could find documentation? My searches have
> turned up very little thus far.
>
> Thanks in advance!

Reply to this Message

sameerargade@gmail.com - 26 Jun 2007 07:30 GMT

> What do you mean by calling stored proc in JPA? Just like using
> CallableStatement when using JDBC?
[quoted text clipped - 6 lines]
>
> > Thanks in advance!

help me in this regard plz plz plz

Reply to this Message

steve - 26 Jun 2007 14:53 GMT

>> What do you mean by calling stored proc in JPA? Just like using
>> CallableStatement when using JDBC?
[quoted text clipped - 8 lines]
>
> help me in this regard plz plz plz

yes it is , it is , it is.

however
A callable statement is not a callable procedure.

When calling a procedure in oracle you have to be clear is it a stored
procedure of pl/sql or a java stored procedure, the passing of types is
different.

Steve

Reply to this Message

stefanomnn - 26 Jun 2007 10:56 GMT

Hi,
this could help you: http://faqs.javabeat.net/ejb/enterprise_java_beans_ejb_interview_questions_8.php

or,in your session bean, try using method createNativeQuery in class
EntityManager.

i hope i helped you.
Stefano

Reply to this Message

JPA, Oracle and stored procedures

Free Magazines