ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc.Heim...@prolifics.de
Subject Re: MySQLSyntaxErrorException
Date Fri, 25 May 2007 06:38:28 GMT
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
marc.heimann@prolifics.de
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" <okancetin@gmail.com> 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,

Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message