0 Replies Latest reply on Oct 28, 2014 11:50 PM by Thomas Milde

    Database Table not found

    Thomas Milde Newbie

      Hey there,

      I'm just starting to learn programming with Java EE7

      and I have a problem with the database connection.

      I have installed Wildfly 8.1.0 Final and JBoss Tools Plugin for Eclipse,

      Eclipse Mars on Windows 7 64 Bit.


      If I do a GET Request I get the following error:

      04:29:42,575 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-6) SQL Error: 42102, SQLState: 42S02

      04:29:42,590 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-6) Tabelle "CHICKEN" nicht gefunden

      Table "CHICKEN" not found; SQL statement:

      select chicken0_.id as id1_0_, chicken0_.age as age2_0_, chicken0_.name as name3_0_ from Chicken chicken0_ [42102-173]

      04:29:42,590 ERROR [org.jboss.as.ejb3.invocation] (default task-6) JBAS014134: EJB Invocation failed on component ChickenService for method public java.util.List com.erebos.firsteeapp.business.chickens.boundary.ChickenService.getAllChickens(): javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement


      If I do a POST Request I get the following error:

      04:31:55,724 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-7) SQL Error: 90036, SQLState: 90036

      04:31:55,724 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-7) Sequenz "HIBERNATE_SEQUENCE" nicht gefunden

      Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:

      call next value for hibernate_sequence [90036-173]

      04:31:55,724 ERROR [org.jboss.as.ejb3.invocation] (default task-7) JBAS014134: EJB Invocation failed on component ChickenService for method public void com.erebos.firsteeapp.business.chickens.boundary.ChickenService.save(com.erebos.firsteeapp.business.chickens.entity.Chicken): javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement


      The request delegetions seem to work, the errors occur when the requests are processed by the EntityManager.



      My persistence.xml looks like this:

      <?xml version="1.0" encoding="UTF-8"?>

      <persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"





        <persistence-unit name="prod" transaction-type="JTA">


        <property name="java.persistence.schema-generation.database.action" value="DROP-AND-CREATE"/>





      And thats how the Chicken Entity looks like:




      @NamedQuery(name="all",query="SELECT c FROM Chicken c")

      public class Chicken {



        private long id;

        private String name;

        private int age;


        public Chicken(String name, int age) {

        this.name = name;

        this.age = age;




        public Chicken() {




      The Chicken Table was not found,

      so I guess the database works,

      hence it wouldn't know if there is a table or not,

      but most likely throw an error that the db doesn't work.

      I guess the table is not being created automatically

      by JPA or the EntityManager and that causes the error.

      But maybe I'm totally wrong.


      I have no idea how to fix this, thats why I'm asking you for help.

      If you require more information, I'm willing to give it to you.


      Thanks for your help.