Migrating to SAP Web AS - HibernateException: Errors in named queries

[Former Member]

Hi folks!

We are migrating our web application to SAP Web AS (Netweaver CE SR5) but we are having some problems with hibernate: org.hibernate.HibernateException: Errors in named queries (see the stack below).

It´s important to point out that this same application runs fine in Tomcat 5.5

I followed the instructions in the following weblog but the problem continues:

I also have read the following posts:

I don´t know if our application-service.xml file is correctly configured (I used an example found in the SDN) so I will paste it below:

(SessionFactoryImpl.java:364)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1291)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:816)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:734)

at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1333)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1299)

... 159 more

[Former Member]

Hi all!

I´ve found the problem in my case.

As stated in the links below, the application.xml version should refer to the Java 1.5:

(look for the Vladimir Pavlov´s post on Jun 2, 2007 6:01 PM in the second page)

In my case, I was using the Java 1.3 version.

Now the problem is not happening anymore.

My application.xml now looks as follows:

<?xml version="1.0" encoding="UTF-8"?>

<application xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="5" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/application_5.xsd">

Regards.

Ballock.

[Former Member]

Below is one of the named queries SAP Web AS is complaining of:

As you can see, it´s a very simple named query.

[Former Member]

Guys, just for the record, these are the jars we´ve included in the EAR root lib dir:

antlr-2.7.6.jar

asm-1.5.3.jar

cglib-2.1.3.jar

All the jakarta commons available in our application including commons-collections-3.2.jar and commons-logging-1.1.jar

dom4j-1.6.1.jar

ehcache-1.4.1.jar

hibernate-3.2.5.jar

jaxen-1.1-beta-9.jar

jta-1.0.1.jar

log4j-1.2.9.jar

xerces-2.9.1.jar

Please, help!

Regards,

Ballock.