users@glassfish.java.net

Re: GlassFish v2.1 and Hibernate Persistence

From: <glassfish_at_javadesktop.org>
Date: Mon, 10 Aug 2009 00:47:17 PDT

At last i have achieved my purpose now hibernate is working but does not call stored procedures/functions; it does everything except this.... when i try to call stored procedures it throws exception ::::===>[b]Caused by: org.hibernate.HibernateException: Errors in named queries: KOMSU_BUL[/b]

this is my namedQuery:
[b]@NamedQuery(name = BDSabitler.komsuBul,
                query = "{? = call Komsu_Bul(?)}",
                hints = { @QueryHint(name = "org.hibernate.callable", value = "true") }) [/b]

this is where i call it:===>
[b]public List<KomsularEntityBean> getKomsular(int durakId) {
                // TODO Auto-generated method stub
                Query q = null;
                
                q = mgr.createNamedQuery(BDSabitler.komsuBul);
                q.setParameter(1, new Integer(durakId));
                
                return q.getResultList();
        }[/b]
[Message sent by forum member 'ilitheblack' (ilitheblack)]

http://forums.java.net/jive/thread.jspa?messageID=359667