Ahhhh, Thanks, and sorry. On 25/05/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
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 [image: Prolifics - Enterprise Solution Division - IBM Business Partner]* Prolifics Deutschland GmbH* Notkestr. 3, D-22607 Hamburg phone +49 (0)40 890 667-70 fax +49 (0)40 890 667-99* [EMAIL PROTECTED] <[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,
-- ~ otomatik oluşturuldu: http://ocetin.net/log http://linux.beykent.edu.tr
<<inline: image/gif>>
