Re: Pb in inserting html code using long varchar type and derby into a table

[Vic Ricker <vi...@ricker.us>]

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/