The comma after candidate_surname make MySQL (as any other database) expect another column name. Remove it and the code should work fine
HTH Marc Heimann Software Engineer Prolifics Deutschland GmbH Notkestr. 3, D-22607 Hamburg phone +49 (0)40 890 667-70 fax +49 (0)40 890 667-99 [EMAIL PROTECTED] 2007 IBM Award Winner for Overall Technical Excellence SOA... Building Future Business Solutions Today Handelsregister: Hamburg, HRB 89903 Geschäftsführer: Ulrich Frotscher "Okan Çetin" <[EMAIL PROTECTED]> wrote on 25.05.2007 01:41:28: > Hello, > Candidate.xml: > > <insert id="insertCandidate" parameterClass="Candidate"> > insert into candidate ( > candidate_name, > candidate_surname, > ) > values ( > #candidate_name#, #candidate_surname# > ) > </insert> > > But it causes this error: > > com.ibatis.common.jdbc.exception.NestedSQLException: --- The error > occurred in ibatis/Candidate.xml. --- The error occurred while > applying a parameter map. --- Check the > insertCandidate-InlineParameterMap. --- Check the statement (update > failed). --- Cause: > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error > in your SQL syntax; check the manual that corresponds to your MySQL > server version for the right syntax to use near ') values ( 'sample', > 'sample' )' at line 1 > > What is the problem? > > Thanks,
<<image/gif>>
