aspose file tools*
The moose likes Object Relational Mapping and the fly likes failed to insert new record - AbstractFlushingEventListener Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "failed to insert new record - AbstractFlushingEventListener" Watch "failed to insert new record - AbstractFlushingEventListener" New topic
Author

failed to insert new record - AbstractFlushingEventListener

Arief Setiawan
Greenhorn

Joined: Sep 06, 2006
Posts: 12
Hi there,

i tried to insert new record in MySQL.
i have 2 simple table, CheckProc and CheckDbf
my mapping, domain code and DAO have been generated by HibernateTools

with a little modification, it running well when insert new record to CheckDbf

here is it the part of my code to insert CheckDbf record


and here my code to insert to CheckProc


it can read, but couldn't insert / update CheckProc
i got this error:



from the error message "You have an error in your SQL syntax;", it seems that i have error in my SQL syntax, but i never use insert/update query
i just use dao class that generated by HibernateTools
it work well for CheckDbf, but not for CheckProc

thank's for your help

regards,
AriefS
Arief Setiawan
Greenhorn

Joined: Sep 06, 2006
Posts: 12
got it!!

i have to rename the "InOut" field to some other name

solve this problem with this reference :
http://www.myeclipseide.com/PNphpBB2-printview-t-21470-start-0.html
he used "Interval" field name.

is "In" in field name is cause this problem?


[ November 19, 2008: Message edited by: Arief Setiawan ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: failed to insert new record - AbstractFlushingEventListener