Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

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

Thanks again,

Jack
 
I found a beautiful pie. And a tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic