[Opensource] Upgrading from 4.02 to 5.02: DBObject ... quoting issue

[Michael Rimov]

At 08:05 AM 6/19/2003 -0400, you wrote:

>I'm not sure it is simply a quoting problem... I temporarily removed the
>'text'
>field (it was a comments field that was neverused) and the quoting behaviour
>now seems fine. The error message suggested it was related to updating a LOB
>value via a character stream. I'll look into it some more.
>
>I will grab the 5.05 code base and see if that helps.

Vincent, what is your database?  The error message came up like that 
because some databases required 'text' fields to be stored in the database 
through a Prepared statement rather than straight SQL.  So JDBCExecutor 
created a dual personality... if text fields were detected, then a Prepared 
statement was executed.  If not, then standard SQL strings were executed.

Chances are you need to have the following line added to your configuration 
file as a JDBC attribute:


escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler"

                                                 -Mike