Ram Kurapati wrote:
> I am using mySQL for descriptors store and content store. I have an
> intresting point to post.
> I want to store content containing
> "{plus-color:"red";line-width:"0.02in";} ", works fine with a simple
> jdbc call.But with in slide i get the below error.
>
> java.sql.SQLException: Syntax error for escape sequence: unknown escape
> sequence
> 'plus-color:"red";
> line-width:"0.02in";'
> at
> org.gjt.mm.mysql.EscapeProcessor.processEscape(EscapeProcessor.java)
> at
> org.gjt.mm.mysql.EscapeProcessor.escapeSQL(EscapeProcessor.java)
> at org.gjt.mm.mysql.Statement.executeUpdate(Statement.java)
> at
> org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java)
>
> Any clues are greately helpful.
>
> Thanks in advance
> Rama
Very strange, looks like a mySQL bug.
"{ }" is the escape sequence used for stored procedures ex "{ call myProc }"
It seems that your content is also interpreted and that's not good.
Can you send more stack trace (until the first 2 lines of slide) just to
make sure...
What version of mySQL are you using?
How did you create the database ?
Did you have problems creating the database like Kiyoko has ?
Dirk
