ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Okan Çetin" <okance...@gmail.com>
Subject Re: MySQLSyntaxErrorException
Date Fri, 25 May 2007 07:49:53 GMT
Ahhhh,
Thanks, and sorry.

On 25/05/07, Marc.Heimann@prolifics.de <Marc.Heimann@prolifics.de> 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*
> **marc.heimann@prolifics.de* <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,
>
>


-- 
~
otomatik oluşturuldu:
http://ocetin.net/log
http://linux.beykent.edu.tr
Mime
View raw message