tags:

views:

79

answers:

1

I am getting the following exception:

org.springframework.orm.hibernate3.HibernateSystemException: Named query not known:

Entity class header:

@Entity
@NamedNativeQuery( callable = true, name = "_Foo_SP", query = "call _Foo()", readOnly = true, resultClass = Foo.class )
public class Foo {
   //...properties omitted for brevity
}

In the hibernate.cfg.xml:

    <mapping
        class="com.company.test.Foo" />

And in a test class:

private static HibernateTemplate HIBERNATE_TEMPLATE;

public static void main( final String[] args ) {
    HIBERNATE_TEMPLATE =
        new HibernateTemplate( new AnnotationConfiguration().addAnnotatedClass( Foo.class ).configure().buildSessionFactory() );
    new HibernateTest().test();
}

public void test() {
    List findByNamedQuery = HIBERNATE_TEMPLATE.findByNamedQuery( "_Foo_SP" );
    for( Object object : findByNamedQuery ) {
        System.out.println( object );
        System.out.println( object.getClass().getName() );
    }
}

I had this working without annotations (eg: with the mapping in a mapping file) but it seems more intuitive to simply use the JPA annotations to declare mappings - but I can't seem to get it to work.

What am I doing wrong here? Is what I'm trying to do even possible? It seems I'm not the only one to encounter this, see: here.

I'm using hibernate 3.5.6-FINAL FWIW.

TIA