D Sheth

Greenhorn

+ Follow

2 Posts 1 Threads 0 Cows

since May 22, 2006

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Total given

Likes

Total received

Received in last 30 days

Total given

Given in last 30 days

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by D Sheth

Getting HibernateException: Errors in named queries

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 ]

17 years ago

Object Relational Mapping

html:select and html:options

Hi,

I have done the exactly what you provided. I think I am missing something though.

I am getting an error - [ServletException in:/jsp/searchBySystem.jsp] Cannot retrieve definition for form bean null'

Form is:
public final class SearchBySystemForm extends ActionForm {

private ArrayList systems;
private int systemId;

public int getSystemId() {
return systemId;
}

public ArrayList getSystems() {
return systems;
}

public void setSystemId(int i) {
systemId = i;
}

public void setSystems(ArrayList list) {
systems = list;
}

}

My Bean is:
public class System implements java.io.Serializable {
private int systemId;
private String systemName;
/**
* @return
*/
public int getSystemId() {
return systemId;
}

/**
* @return
*/
public String getSystemName() {
return systemName;
}

/**
* @param i
*/
public void setSystemId(int i) {
systemId = i;
}

/**
* @param string
*/
public void setSystemName(String string) {
systemName = string;
}

}

My Action Class is:
public class SearchBySystemAction extends Action {

public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws Exception {

String forward = "error";

ArrayList systemList = new ArrayList();
SearchBySystemForm systemForm;
systemForm = new SearchBySystemForm();

System system = new System();
system.setSystemId(1);
system.setSystemName("MARS");
systemList.add(system);

system = new System();
system.setSystemId(2);
system.setSystemName("JUPITER");
systemList.add(system);

systemForm.setSystems(systemList);

request.getSession().setAttribute("SYSTEMFORM",systemForm);
forward = "showSystemList";

return (mapping.findForward(forward));

}

My jsp is:
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>

<html>
<title>System List</title>
</head>
<body>
<html:errors/>
<html:form action="/searchBySystem">
<table>
<tr>
<td>System:</td>
<td>
<html:select name="SYSTEMFORM" property="systemId">
<html

ptionsCollection property="systemList" value="systemId" label="systemName"/>
</html:select>
</td>
<td><html:submit>Ok</html:submit></td>
<td><html:cancel>Cancel</html:cancel></td>
</tr>

</table>
</html:form>
</body>
</html>

17 years ago

Struts