I am trying to create an application that will display list of books written by an author. For this I am using oracle 10g express edition database and Hibernate Framework.
The stacktrace displayed by browser is as follows...
type Exception report
message An exception occurred processing
JSP page /DisplayBooks.jsp at line 22
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /DisplayBooks.jsp at line 22
19: <%
20:
String aname=request.getParameter("author");
21: mypack.SearchHelper sh=new SearchHelper();
22: List booksCollection=sh.getBooks(aname);
23: for(Iterator itr=booksCollection.iterator();itr.hasNext();)
24: {
25: Books b=(Books)itr.next();
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
root cause
java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode
\-[IDENT] IdentNode: 'bookname' {originalText=bookname}
PROJECT DETAILS
========================
I have created 2 tables which are as follows...
AUTHORS table
===============
Name Null? Type
----------------------------------------- -------- --------------------
AUTHORID NOT NULL VARCHAR2(4)
AUTHORNAME VARCHAR2(30)
BOOKS table
===============
Name Null? Type
----------------------------------------- -------- ------------
BOOKID NOT NULL VARCHAR2(4)
BOOKNAME VARCHAR2(30)
AUTHORID VARCHAR2(4)
Data for AUTHORS table
========================
AUTH AUTHORNAME
---- -----------
A1 Arvind
A2 Bikas
Data for BOOKS table
======================
BOOK BOOKNAME AUTHORID
---- ------------------------------ -------------------
B1 C Programming A2
B2 C++ Programming A2
B3 C# Programming A2
B5 J2ME Programming A1
SearchBooks.jsp
===============
DisplayBooks.jsp
===============
hibernate.cfg.xml
hibernate.reveng.xml
Authors.java
========
Books.java
=======
Authors.hbm.xml
============
Books.hbm.xml
===========
NewHibernateUtil.java
==============
SearchHelper.java
============