db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vic Ricker <...@ricker.us>
Subject Re: Pb in inserting html code using long varchar type and derby into a table
Date Fri, 01 Sep 2006 12:52:07 GMT
It sounds like you might have an unescaped apostrophe inside the string
that you are inserting.  Are you not using a prepared statement?

cedric ALLIET 2 wrote:
> Hello
>
> Using derby, I'm trying to insert  a html code into an attribute with
> type long varchar   INSERT INTO Result VALUES(DEFAULT, '...');
>  and I get the following error message
>
> ERROR 42X01: Syntax error: Encountered "s" at line 3, column 339.
>      at
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>      at
> org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown
> Source)
>      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown
> Source)
>      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>      at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
>      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>
> I don't understand why I get  this error message?
>
> Thanks
>
> Regards
>

-- 
Vic Ricker
http://www.ricker.us/


Mime
View raw message