Exception while sql insertion query

MathewManu / MovieMon

A Rest based java web application that manages all the information about user’s movies

0 stars 0 forks source link

Exception while sql insertion query #8

Closed anushyakkutty closed 8 years ago

anushyakkutty commented 8 years ago

Exception while running queryINSERT INTO MOVIE (FILENAME, FILELOCATION, TITLE, Y EAR, IMDBRATING, IMDBID, GENRE) VALUES ( 'Theres.Something.About.Mary.EXTENDED. CUT.1998.720p.BrRip.x264.YIFY.mp4','c:\Anushya\movies_manu\aug_20\Theres Somethi ng About Mary EXTENDED (1998)\Theres.Something.About.Mary.EXTENDED.CUT.1998.720p .BrRip.x264.YIFY.mp4','There's Something About Mary','1998','7.1','tt0129387','C omedy, Romance' ); Exception : unexpected token: S required: ) ERROR: insert error

MathewManu commented 8 years ago

i don't have this file.. can you check if this file is getting inserted properly after preparestatement fix ?

MathewManu commented 8 years ago

@anushyakkutty Please verify this..

MathewManu commented 8 years ago

not facing any issues.