Robert,
I just checked in fixed code for the bugs that you submitted. Unfortunately
none of the JDBC tricks helped me to fix it. I had to change expression
translation mechanism to produce queries like that (for Oracle only and
only for CHAR columns):
SELECT t0.DATE_OF_BIRTH, t0.ARTIST_ID, t0.ARTIST_NAME FROM ARTIST t0 WHERE
TRIM(TRAILING FROM t0.ARTIST_NAME) = ? [params: 'artist1']
Could you confirm that this works for you. Then we can close the bugs.
Better ideas are appreciated. It is interesting that while running the same
query via "sqlplus" I don't have to use "TRIM" to get the correct results,
while JDBC behaves totally different.
Andrei
This archive was generated by hypermail 2.0.0 : Wed May 08 2002 - 12:32:14 EDT