Databases
StackOverflow2013
Postsdbo
POHibernate error reading data from database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHibernate error reading data from database
    primarykey
    data
    text
    <p>I have created an application using Spring MVC 3, Hibernate and Ext Js 4. The problem is that when I start the application the data is not readed from the database.</p> <p>BookController.java:</p> <pre><code>@Controller public class BookController { private BookService bookService; @RequestMapping(value="/books/view.action") public @ResponseBody Map&lt;String,? extends Object&gt; view(@RequestParam int start, @RequestParam int limit) throws Exception { try{ List&lt;Book&gt; books = bookService.getBookList(start,limit); int total = bookService.getTotalBooks(); return ExtJSReturn.mapOK(books, total); } catch (Exception e) { return ExtJSReturn.mapError("Error retrieving books from database."); } } </code></pre> <p>BookService.java:</p> <pre><code>@Service public class BookService { private BookDAO bookDAO; /** * Get all books * @return */ @Transactional(readOnly=true) public List&lt;Book&gt; getBookList(int start, int limit){ return bookDAO.getBooks(start, limit); } public int getTotalBooks(){ return bookDAO.getTotalBooks(); } </code></pre> <p>BookDAO.java:</p> <pre><code> @SuppressWarnings("unchecked") public List&lt;Book&gt; getBooks(int start, int limit) { DetachedCriteria criteria = DetachedCriteria.forClass(Book.class); return hibernateTemplate.findByCriteria(criteria, start, limit); } public int getTotalBooks(){ return DataAccessUtils.intResult(hibernateTemplate.find("SELECT COUNT(*) FROM books")); } </code></pre> <p>Book.java:</p> <pre><code>@JsonAutoDetect @Entity @Table(name="books") public class Book { @Id @GeneratedValue @Column(name="id") private int id; @Column(name="title", nullable=false) private String title; @Column(name="author", nullable=false) private String author; @Column(name="publisher", nullable=false) private String publisher; @Column(name="isbn", nullable=false) private String isbn; @Column(name="pages", nullable=false) private int pages; @Column(name="category", nullable=false) private String category; @Column(name="qty", nullable=false) private int qty; /** * @return the title */ public String getTitle() { return title; } /** * @param title the title to set */ public void setTitle(String title) { this.title = title; } /** * @return the author */ public String getAuthor() { return author; } /** * @param author the author to set */ public void setAuthor(String author) { this.author = author; } /** * @return the publisher */ public String getPublisher() { return publisher; } /** * @param publisher the publisher to set */ public void setPublisher(String publisher) { this.publisher = publisher; } /** * @return the isbn */ public String getIsbn() { return isbn; } /** * @param isbn the isbn to set */ public void setIsbn(String isbn) { this.isbn = isbn; } /** * @return the pages */ public int getPages() { return pages; } /** * @param pages the pages to set */ public void setPages(int pages) { this.pages = pages; } /** * @return the category */ public String getCategory() { return category; } /** * @param category the category to set */ public void setCategory(String category) { this.category = category; } /** * @return the qty */ public int getQty() { return qty; } /** * @param qty the qty to set */ public void setQty(int qty) { this.qty = qty; } /** * @return the id */ public int getId() { return id; } /** * @param id the id to set */ public void setId(int id) { this.id = id; } } </code></pre> <p>ExtJsReturn.java:</p> <pre><code>@Component public class ExtJSReturn { /** * Generates modelMap to return in the modelAndView * @param books * @return */ public static Map&lt;String,Object&gt; mapOK(List&lt;Book&gt; books){ Map&lt;String,Object&gt; modelMap = new HashMap&lt;String,Object&gt;(3); modelMap.put("total", books.size()); modelMap.put("data", books); modelMap.put("success", true); return modelMap; } /** * Generates modelMap to return in the modelAndView * @param books * @return */ public static Map&lt;String,Object&gt; mapOK(List&lt;Book&gt; books, int total){ Map&lt;String,Object&gt; modelMap = new HashMap&lt;String,Object&gt;(3); modelMap.put("total", total); modelMap.put("data", books); modelMap.put("success", true); return modelMap; } /** * Generates modelMap to return in the modelAndView in case * of exception * @param msg message * @return */ public static Map&lt;String,Object&gt; mapError(String msg){ Map&lt;String,Object&gt; modelMap = new HashMap&lt;String,Object&gt;(2); modelMap.put("message", msg); modelMap.put("success", false); return modelMap; } } </code></pre> <p>The error is raised from the controller: Error retrieving books from database. Do you have any ideea what can be the problem? See here the Console output: <a href="http://pastebin.com/jMQKS31P" rel="nofollow noreferrer">http://pastebin.com/jMQKS31P</a></p> <p><strong>FIXED!!!</strong></p> <p><a href="https://stackoverflow.com/a/14447201/1564840">https://stackoverflow.com/a/14447201/1564840</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USPascut
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COGeneral exception handlers are no-no(I think *now* you know why :D) Could you at least call e.printStackTrace() and add what it prints(edit the question).
      singulars
      1. POHibernate error reading data from database
      1. USBoris Treukhov
    2. COfound it: org.springframework.orm.hibernate3.HibernateQueryException: books is not mapped [SELECT COUNT(*) FROM books]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: books is not mapped [SELECT COUNT(*) FROM books] :D, noy i'll try to fix it..
      singulars
      1. POHibernate error reading data from database
      1. USPascut
    3. COYou can find good answers here: http://stackoverflow.com/a/14447201/1564840
      singulars
      1. POHibernate error reading data from database
      1. USPascut
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload