ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Okan Çetin" <okance...@gmail.com>
Subject MySQLSyntaxErrorException
Date Thu, 24 May 2007 23:41:28 GMT
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
View raw message