abdul mobeen

Hi,

     I am trying to create CRUD for Book Entity. But getting this error.:



HTTP Status 500 - Request processing failed; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: book is not mapped [from book].

Here the code :

package com.lms.entity; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="book") public class Book { @Id @GeneratedValue @Column(name="id") private int id; @Column(name="name") private String name; @Column(name="price") private int price; @Column(name="author") private String author; public Book() { super(); // TODO Auto-generated constructor stub } public Book(int id, String name, int price, String author) { this.name = name; this.price = price; this.author = author; } /** * @return the id */ public int getId() { return id; } /** * @param id the id to set */ public void setId(int id) { this.id = id; } /** * @return the name */ public String getName() { return name; } /** * @param name the name to set */ public void setName(String name) { this.name = name; } /** * @return the price */ public int getPrice() { return price; } /** * @param price the price to set */ public void setPrice(int price) { this.price = price; } /** * @return the author */ public String getAuthor() { return author; } /** * @param author the author to set */ public void setAuthor(String author) { this.author = author; } /* (non-Javadoc) * @see java.lang.Object#toString() */ @Override public String toString() { return "Book [id=" + id + ", name=" + name + ", price=" + price + ", author=" + author + "]"; } }


package com.lms.dao; import java.util.List; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.query.Query; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import org.springframework.transaction.annotation.Transactional; import com.lms.entity.Book; @Repository @Transactional public class BookDAOImpl implements BookDAO { @Autowired SessionFactory sessionFactory; @Override public List<Book> getBooks() { // get the current hibernate session Session currentSession = sessionFactory.getCurrentSession(); // create a query Query<Book> theQuery = currentSession.createQuery("from book", Book.class); // get the result list List<Book> books = theQuery.getResultList(); return books; } }


servlet config file.

<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean"> <property name="dataSource" ref="myDataSource" /> <property name="packagesToScan" value="com.lms.entity" /> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean>

Hi,
   Can anybody tell me the difference between :
ModelMap map,
@ModelAttribute(value="employee")
@PathVariable("employeeId")

And which one to use when.

Thanks in advance.

I have created a simple Spring Demo to learn spring. I created two objects of class Asian from spring container. I set of value of first object to Ali and second to Usman but when I print them the value of both of the objects is usman. I didn't expect that. Please can anybody tell me whats the problem . Below is the code:



public interface Person { public String Walk(); public String Talk(); }
--------------------------------------

@Component public class License { private Integer number = 212123123; @Override public String toString() { number++; return "License [number=" + number + "]"; } // setters, getters }
--------------------------------
@Component public class Asian implements Person { @Autowired @Value("") public String pname; public Integer page = 0; private License license; @Autowired public void setLicense(License license) { this.license = license; } public License getLicense(){ return this.license; } @Override public String Walk() { // TODO Auto-generated method stub return new String("Asian : I can Walk faster."); } public String getPname() { return pname; } public void myName() { System.out.println("My name is : " + this.getPname()); } public Integer getPage() { return page; } public void setPage(Integer page) { this.page = page; } public void setPname(String name){ this.pname = name; } @Override public String Talk() { // TODO Auto-generated method stub return new String("I can Talk calmly."); } }
--------------------------------------

public class Run { public static void main(String[] args) { // load the spring configuration file ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext( "applicationContextAnnotations.xml"); // retrieve bean from spring container Asian ali = context.getBean("asian", Asian.class); // retrieve bean from spring container Asian usman = context.getBean("asian", Asian.class); // call methods on the bean ali.setPname("Ali"); usman.setPname("Usman"); List<Asian> asians = new ArrayList<Asian>(); ali.myName(); usman.myName(); asians.add(ali); asians.add(usman); asians.forEach(ele -> System.out.printf("%s - %n" , ele.pname)); }

Output is below :

My name is : Usman
My name is : Usman
Usman -
Usman -
---------------------------------------
I think out put should be like



My name is : Ali
My name is : Usman
Ali -
Usman -


Please help.