Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » fail to make table
fail to make table [message #895200] Thu, 12 July 2012 02:59 Go to next message
Jorge Ryan is currently offline Jorge Ryan
Messages: 5
Registered: June 2012
Junior Member
hello,

I just made a small webpages that enter data into database.
I have specified that in persistence.xml to drop-create-tables. however, if there is no table, it will generate exception.
if I coded create-tables, ALSO no table in database, it would be fine. Everything runs smooth. is it a known issue?

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Error Code: 942
Call: INSERT INTO BOOK (ID, DESCRIPTION, ILLUSTRATIONS, ISBN, NBOFPAGE, PRICE, TITLE) VALUES (?, ?, ?, ?, ?, ?, ?)
bind => [7 parameters bound]
Query: InsertObjectQuery(com.apress.javaee6.chapter10.Book@11a48bb4)
Re: fail to make table [message #895403 is a reply to message #895200] Thu, 12 July 2012 17:25 Go to previous message
Chris Delahunt is currently offline Chris Delahunt
Messages: 1019
Registered: July 2009
Senior Member
Looks like you have set "drop-create-tables" when it should be "drop-and-create-tables" - incorrect values are ignored. Please feel free to file an enhancement to have validation added for the "eclipselink.ddl-generation" property and vote for it.

Best Regards,
Chris
Previous Topic:EclipseLink + Foxpro
Next Topic:EclipseLink/Moxy 2.4 - some objects not marshalled after correct unmarshalling of XML
Goto Forum:
  


Current Time: Wed Sep 17 07:37:13 GMT 2014

Powered by FUDForum. Page generated in 0.01646 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software