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/
