Hi Everyone,
I'm new with Struts and Hibernate. I'm running the code in Windows
using MyEclipse,
running on Tomcat bundled with MyEclipse 6.0. Also, the table Book is
in an Oracle
8.i database (connects fine), Struts version 1.1, and Hibernate
version 3.1.
I got something working that gets data from a Book Oracle table in
Hibernate and I can see the data con the console since I display it
with System.out in the Struts Action. I printed the record counts and
title of the Book records:
Query Size = 7
The title is Struts Book
The title is Java Book
The title is Java2 Book
The title is EJB Book
The title is JBoss for Beginners
The title is Using MyEclipse for cooking
The title is EJB for spending your weekends
The application consist of 2 simple pages, one jsp with a link, the
other jsp that is supposed to display the bookList. The bookList is
where I'm getting an error since it doesn't display the values. I get
an error:
SEVERE: Servlet.service() for servlet action threw exception
javax.servlet.jsp.JspException: Cannot find bean in any scope
Hibernate seems to be working fine since I get the data.
The problem seems to be with the bookList.jsp page and Struts.
I tried removing the nested writes and just having a tr and td
displaying text that says there are booklist values. That text was
successfully displayed. So my problem is the logic that iterates
through the values to try to write them to the jsp.
Can anyone please help?
The code is show below. Thanks in advance. :)
Rudi
======================================================
BookListAction.java (here's where I run the query and populate the
books collection)
package com.mycompany.struts.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.text.html.HTMLDocument.Iterator;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.mycompany.Book;
import com.mycompany.struts.form.BookListForm;
import com.mycompany.hibernate.*;
import org.hibernate.*;
import org.hibernate.criterion.Projections;
import java.util.*;
public class BookListAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
BookListForm bookListForm = (BookListForm) form;
SessionFactory factory = null;
Session session = null;
Collection <Book> books = new ArrayList<Book>();
String author = null;
String title = null;
try {
factory = HibernateSessionFactory.getSessionFactory();
session = (Session) factory.openSession();
List<Book>bks = session.createQuery("from Book ").list();
System.out.println("Query Size = " + bks.size());
if (bks.isEmpty()) {
System.out.println("Could not get book using embedded
query");
} else {
for (int i = 0; i < bks.size(); i++) {
System.out.println("The title is " +
bks.get(i).getTitle());
}
}
bookListForm.reset(mapping, request);
bookListForm.setBooks(bks);
} finally {
session.close();
}
return mapping.findForward("showList");
}
}
======================================================
bookList.java (here's where I have the problem)
<%@ page language="java" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean"
prefix="bean"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html"
prefix="html"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic"
prefix="logic" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-nested"
prefix="nested" %>
<html>
<head>
<title>Show book list</title>
</head>
<body>
<table border="1">
<tbody>
<%-- set the header --%>
<tr>
<td>Author</td>
<td>Book name</td>
<td>Available</td>
<td> </td>
<td> </td>
</tr>
<%-- check if book exists and display message or iterate over books
--%>
<logic:empty name="bookListForm" property="books">
<tr>
<td colspan="5">No books available</td>
</tr>
</logic:empty>
<logic:notEmpty name="bookListForm">
<tr>
<td colspan="5">Not empty</td>
</tr>
<nested:iterate property="books">
<tr>
<%-- print out the book information --%>
<td><nested:write name="Book" property="author" /></td>
</td>
</tr>
</nested:iterate>
</logic:notEmpty>
<%-- end interate --%>
</tbody>
</table>
</body>
</html>
======================================================
Book.java
package com.mycompany.sirs;
public class Book implements java.io.Serializable {
private static final long serialVersionUID = 1L;
private long id;
private String title;
private String author;
private String available;
public Book() {}
public Book(long id, String title, String author, String available) {
this.id = id;
this.title = title;
this.author = author;
this.available = available;
}
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getAvailable() {
return available;
}
public void setAvailable(String available) {
this.available = available;
}
}
======================================================
BookListForm.java
package com.mycompany.struts.form;
import java.util.ArrayList;
import java.util.Collection;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import com.mycompany.Book;
public class BookListForm extends ActionForm {
private Collection books;
/**
* @return the books
*/
public Collection getBooks() {
return books;
}
/**
* @param books the books to set
*/
public void setBooks(Collection books) {
this.books = books;
}
public void reset(ActionMapping mapping, HttpServletRequest request)
{
books = new ArrayList();
}
}
======================================================
Book.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping
DTD//EN"
"http://hibernate.sf.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.mycompany.Book" table="ADMIN.Book">
<id name="id" column="id">
<generator class="native"/>
</id>
<property name="title" column="title"/>
<property name="author" column="author"/>
<property name="available" column="available"/>
</class>
</hibernate-mapping>
======================================================