Getting HibernateException: Errors in named queries

[D Sheth]

Hi all:

I am working on a Struts 1.2.9/Hibernate 3.1.3 Application on Weblogic 8.1.5. I am trying to use Named Queries, but running into an exception mentioned above.

Code is:

    
[B]hibernate.cfg.xml[/B] 
 
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
<session-factory>
 
<property name="connection.url">
jdbc  :o  racle:thin:@//localhost:1521/PERSNL
</property>
<property name="connection.username">scott</property>
<property name="connection.password">tiger</property>
<property name="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="show_sql">true</property>
 
<mapping resource="/com/test/hibernate/mapping/system.hbm.xml" />
</session-factory>
</hibernate-configuration>
 
[B]system.hbm.xml[/B] 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
<class name="com.test.hibernate.dao.SystemDAO"
table="SYSTEM" mutable="false">
<cache usage="read-only" />
<id name="systemId" type="long" column="SYSTEM_KEY">
<generator class="assigned" />
</id>
 
<property name="systemName">
<column name="SYSTEM_NAME" />
</property>
</class>
 
<query name="AllSystems">
<![CDATA[from SystemDAO systemDAO]]>
</query>
 
</hibernate-mapping>
 
[B]SystemDAO[/B]
 
package com.test.hibernate.dao;
 
public class SystemDAO implements java.io.Serializable {
  private long systemId;
  private String systemName;
  
public long getSystemId() {
return systemId;
}
 
public String getSystemName() {
return systemName;
}
 
public void setSystemId(long i) {
systemId = i;
}
 
public void setSystemName(String string) {
systemName = string;
}
 
}
 
[B]HibernateUtil[/B] 
public class HibernateUtil {
Session session = null;
 
public List findAll(String queryName, Map params) throws Exception {
 
Session session = null;
 
try {
session = HibernateSessionFactory.currentSession();
Query query = session.getNamedQuery(queryName);
for (Iterator i = params.entrySet().iterator(); i.hasNext()  ;)   {
Map.Entry entry = (Map.Entry) i.next();
//assume first that incoming arguement is Key, 
try {
String s[] = (String[]) entry.getValue();
String str = new String(s[0]);
query.setParameter((String) entry.getKey(), new Long(str));
} catch (ClassCastException e) {
query.setParameter((String) entry.getKey(), (String) entry.getValue());
}
 
}
 
return query.list();
} catch (Exception e) {
e.printStackTrace();
throw new Exception(e);
} finally {
if (session != null) {
HibernateSessionFactory.closeSession(session);
}
}
}
 
}
 
[B]HibernateSessionFactory[/B] 
public class HibernateSessionFactory {
 
    public static Session currentSession() throws HibernateException {
 
        Session session = null;
        if (sessionFactory == null) {
            try {
                cfg.configure();
                sessionFactory = cfg.buildSessionFactory();
            }
            catch (Exception e) {
                System.err.println("%%%% Error Creating SessionFactory %%%%");
                e.printStackTrace();
            }
        }
        session = sessionFactory.openSession();
 
        return session;
    }
 
    public static void closeSession(Session session) throws HibernateException {
 
        if (session != null) {
            session.close();
        }
    }
 
 
    private HibernateSessionFactory() {
    }
 
}
 

This, when executed throws following exception:

 
%%%% Error Creating SessionFactory %%%%
org.hibernate.HibernateException: Errors in named queries: AllSystems
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:339)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
at com.test.hibernate.util.HibernateSessionFactory.currentSession(HibernateSessionFactory.java:44)
at com.test.hibernate.util.HibernateUtil.findAll(HibernateUtil.java:26)
at com.test.delegate.SystemListDelegate.find(SystemListDelegate.java:33)
at com.test.action.SystemListAction.execute(SystemListAction.java:18)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
 

I have been trying to resolve it for a while. But cannot find way out. Any help will be appreciated.

[ June 30, 2006: Message edited by: D Sheth ]

[ June 30, 2006: Message edited by: D Sheth ]

[ June 30, 2006: Message edited by: D Sheth ]
[ June 30, 2006: Message edited by: D Sheth ]

[Mark Spritzler]

Tough to figure out. But I have a couple of questions.

1. Are you trying to pass parameter to the query, because the named query that you have does not take parameters.

2. Your "dao" object isn't a dao, it is a DTO at the current state or if you add behavior then it could become a BO or Business Object.

3. Whereas in your HibernateUtil you call to run a query which is a method you would find in a "dao" Data Access Object.

Thanks

Mark

[Scott Johnson]

Is there any other (chained) exception being logged that might have more details?

I would try two things:

1. Fully qualify the class name in the query ("com.test.hibernate.dao.SystemDAO").

2. Turn up logging for org.hibernate.* and see if that provides more details.

[a ramazany]

also add class tag to your hbm file

<hibernate-mapping>
<class name="aip.law.orm.hntest.SpHntest">
<id name="id" type="java.lang.Integer">
<column name="ID" />
</id>
<property name="caption" type="java.lang.String">
<column name="Caption" length="60" not-null="true" />
</property>
<loader query-ref="testingProc" />
</class>
<sql-query name="testingProc" callable="true" >
<return alias="SpHntest" class="aip.law.orm.hntest.SpHntest">
<return-property name="id" column="ID"/>
<return-property name="caption" column="Caption"/>
</return>
{call sphntest()}

</sql-query>
</hibernate-mapping>

[Mark Spritzler]

"a ramazany",
Welcome to the JavaRanch.

We're a friendly group, but we do require members to have valid display names.

Display names must be two words: your first name, a space, then your last name. Fictitious names are not allowed.

Please edit your profile and correct your display name since accounts with invalid display names get deleted.

[Mark Spritzler]

"D Sheth",
Welcome to the JavaRanch.

We're a friendly group, but we do require members to have valid display names.

Display names must be two words: your first name, a space, then your last name. Fictitious names are not allowed.

Please edit your profile and correct your display name since accounts with invalid display names get deleted.

[Maruti Nori]

Follow the below link:

http://www.hibernate.org/250.html#A25