On Thu, 20 Sep 2012, GEISINGER Marc - Contractor wrote:
>
> I think there is a bug in AbstracJdbc2Statement.replaceProcessing. When I
> am trying to execute the following sql command with a java.sql.Statement the
> data written to the database is not what it should be:
>
> INSERT INTO dev.stringtest (id, val) VALUES (1, $a$ {a}{f} {b} {f}$a$)
>
> The replaceProcessing method removes {f} and cuts the string.
Yes, this is a bug in the JDBC driver. The fact that it is a silent
data loss bug makes it more severe.
There is no reason it shouldn't work other than people not having time to
make the driver smart enough to handle dollar quotes in this context.
Kris Jurka