Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » fail to make table

Show: Today's Messages :: Show Polls :: Message Navigator

fail to make table [message #895200]

Thu, 12 July 2012 02:59

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)

Report message to a moderator

Re: fail to make table [message #895403 is a reply to message #895200]

Thu, 12 July 2012 17:25

Chris Delahunt

Messages: 1389
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

Report message to a moderator

Previous Topic:	EclipseLink + Foxpro
Next Topic:	EclipseLink/Moxy 2.4 - some objects not marshalled after correct unmarshalling of XML

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:38:09 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter