JEE CRUD Application

[Fridah Kamau]

I'm trying to save a record to the database, no success.

My Entity Class

  @Entity
@Table(name = "STUDENT")
@XmlRootElement

@NamedQueries({
    @NamedQuery(name = "Student.findAll", query = "SELECT s FROM Student s")
    , @NamedQuery(name = "Student.findByStudentid", query = "SELECT s FROM Student s WHERE s.studentid = :studentid")
    , @NamedQuery(name = "Student.findByFirstname", query = "SELECT s FROM Student s WHERE s.firstname = :firstname")
    , @NamedQuery(name = "Student.findByLastname", query = "SELECT s FROM Student s WHERE s.lastname = :lastname")
    , @NamedQuery(name = "Student.findByYearlevel", query = "SELECT s FROM Student s WHERE s.yearlevel = :yearlevel")})
public class Student implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
   @Basic(optional = false)
   @NotNull   
    @Column(name = "STUDENTID")
    private Integer studentid;
    
   // @Size(max = 30)
    @Column(name = "FIRSTNAME",length=30)
    private String firstname;
    
   //@Size(max = 30)
    @Column(name = "LASTNAME",length=30)
    private String lastname;
    
    @Column(name = "YEARLEVEL")
    private Integer yearlevel;

    public Student() {
    }

    public Student(Integer studentid) {
        this.studentid = studentid;
    }
 
    public Student(Integer studentid,String firstname,String lastname,int yearlevel) {
        this.studentid = studentid;
        this.firstname=firstname;
        this.lastname=lastname;
        this.yearlevel=yearlevel;
    }........

My Auto generated model classes: StudentFacade

 
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package models;

import entities.Student;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

/**
 *
 * @author user
 */
@Stateless
public class StudentFacade extends AbstractFacade<Student> implements StudentFacadeLocal {

    @PersistenceContext(unitName = "MySecondTestPU")
    private EntityManager em;

    @Override
    protected EntityManager getEntityManager() {
        return em;
    }

    public StudentFacade() {
        super(Student.class);
    }
    
}

Interface: StudentFacadeLocal

@Local
public interface StudentFacadeLocal {

    void create(Student student);

    void edit(Student student);

    void remove(Student student);

    Student find(Object id);

    List<Student> findAll();

    List<Student> findRange(int[] range);

    int count();
    
}

AbstractFacade

public abstract class AbstractFacade<T> {

    private Class<T> entityClass;

    public AbstractFacade(Class<T> entityClass) {
        this.entityClass = entityClass;
    }

    protected abstract EntityManager getEntityManager();

    public void create(T entity) {
        getEntityManager().persist(entity);
    }

    public void edit(T entity) {
        getEntityManager().merge(entity);
    }

    public void remove(T entity) {
        getEntityManager().remove(getEntityManager().merge(entity));
    }

    public T find(Object id) {
        return getEntityManager().find(entityClass, id);
    }

    public List<T> findAll() {
        javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();
        cq.select(cq.from(entityClass));
        return getEntityManager().createQuery(cq).getResultList();
    }

    public List<T> findRange(int[] range) {
        javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();
        cq.select(cq.from(entityClass));
        javax.persistence.Query q = getEntityManager().createQuery(cq);
        q.setMaxResults(range[1] - range[0] + 1);
        q.setFirstResult(range[0]);
        return q.getResultList();
    }

    public int count() {
        javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();
        javax.persistence.criteria.Root<T> rt = cq.from(entityClass);
        cq.select(getEntityManager().getCriteriaBuilder().count(rt));
        javax.persistence.Query q = getEntityManager().createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }
    
}

On Save, i get this error:

Warning:   StandardWrapperValve[StudentServlet]: Servlet.service() for servlet StudentServlet threw exception
javax.ejb.EJBException
at com.sun.ejb.containers.EJBContainerTransactionManager.processSystemException(EJBContainerTransactionManager.java:752)
at com.sun.ejb.containers.EJBContainerTransactionManager.completeNewTx(EJBContainerTransactionManager.java:702)
.......
t com.sun.proxy.$Proxy461.create(Unknown Source)
at controller.StudentServlet.processRequest(StudentServlet.java:63)
at controller.StudentServlet.doPost(StudentServlet.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)
.........
Caused by: java.lang.annotation.AnnotationFormatError: Duplicate annotation for class: interface javax.validation.constraints.NotNull: @javax.validation.constraints.NotNull(message={javax.validation.constraints.NotNull.message}, groups=[], payload=[])
at sun.reflect.annotation.TypeAnnotationParser.mapTypeAnnotations(TypeAnnotationParser.java:360)

[Ron McLeod]

What does StudentServlet look like, and what data is being pass to it?

[Fridah Kamau]

@Ron McLeod,
Thanks for offering your help. I have managed to correct the problem by creating a GlassFish object and having the correct configurations.

[Miler Muñoz]

Fridah Kamau wrote:@Ron McLeod,
Thanks for offering your help. I have managed to correct the problem by creating a GlassFish object and having the correct configurations.

good morning, how could you solve the problem? ... could you share the solution? ... I have the same problem, and still can't find the request.
thanks for your answer.