Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #183

Re: JPA Calling an Oracle

Show all headers | View raw

  To: comp.lang.java.databases
Thu, 12 Jun 2008 09:54:34 -0500, /Jason King/:
> Owen Jacobson wrote:
>
>> If there's any support for it at all, it'll be a JPA-vendor-specific 
>> feature.  The JPA provider for JBoss 4 is Hibernate; as far as I'm 
>> aware, there's no general purpose support for stored procedure calls, 
>> only some special-case support for a few specific forms.  Check the 
>> hibernate docs for details:
>>   <http://www.hibernate.org/hib_docs/reference/en/html/querysql.html#sp_query>
>>
>> 16.2.2.1 has some specific notes for Oracle sprocs.
>
> If you can rewrite the pl/sql side as a function that might get you out 
> of hell.

Thank you both Owen and Jason for your suggestions.  I've followed 
the Hibernate documentation and obtained a JDBC connection through 
|session.connection()| preparing a CallableStatement which works, 
but I'll most probably write an additional PL/SQL function (I can't 
modify the existing one) to "normalize" the result, later.

-- 
Stanimir

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: JPA Calling an Oracle "Stanimir Stamenkov" <stanimir.stamenkov@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000

csiph-web