This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Jack Bush
Ranch Hand
Posts: 235
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:



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
Ranch Hand
Posts: 553
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 235
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, you are right James,

Thanks again,

Jack
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic