JPA - How to persist new table without exception (SE) environment

[Jack Bush]

Hi All,

I got the following database exception when carrying out JPA persisting (JDK SE) record to STUDENT table which does not exist in the first place:

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'student'
Error Code: 1051
Below are the tutorial codes that generates the record in STUDENT:

@Entity
//@Table(name="STUDENT", catalog="EducationDB", schema="")
public class Student  implements Serializable {
    @Id
    private int id;
    private String name;
    private long score;

    // getters & setters
}

public class StudentService {
    protected EntityManager em;

    public StudentService(EntityManager em) {
        this.em = em;
    }

    public Student createStudent(int id, String name, long salary) {
        Student student = new Student(id);
        student.setName(name);
        student.setScore(score);
        em.persist(student);
        return student;
    }

    ..........

    public Collection<Student> findAllStudents() {
        Query query = em.createQuery("SELECT e FROM Student s");
        return (Collection<Student>) query.getResultList();
    }
}

public class StudentTest {

    public static void main(String[] args) {
        EntityManagerFactory emf =
                Persistence.createEntityManagerFactory("StudentService");
        EntityManager em = emf.createEntityManager();
        EmployeeService service = new EmployeeService(em);

        //  create and persist a student
        em.getTransaction().begin();
        Student student = service.createStudent(100, "Kelly Ryan", 95);
        em.getTransaction().commit();
        System.out.println("Persisted " + student);

        // close the EM and EMF when done
        em.close();
        emf.close();
    }
}

Table STUDENT did get generated despite the above exception. However, this exception will no longer show up for any additional persistences once STUDENT has been generated. The question is how to / what needs to be done to create automatically generate this table quitely in an empty database without getting the above exception?

I am running JDK1.6.0_17, Netbeans 6.9.1, GF3.1, MySQL 5.1 on Windows 7.

Thanks,

Jack

[James Sutherland]

Generating tables for a persistence unit is not standardized in JPA, so is provider specific.

For EclipseLink, you can enable table generation using the persistence.xml property,
<property name="eclipselink.ddl-generation" value="create-tables"/>

See,
http://wiki.eclipse.org/EclipseLink/Examples/JPA/DDL

[Jack Bush]

Yes, you are right James,

Thanks again,

Jack