Howdy. I'm having some issues with the SQL generated when selecting with a where clause keying off a VARBINARY field (though I'm able to insert into such fields just fine).
919 [main] DEBUG org.apache.torque.util.BasePeer - SELECT AUTH_DATA.AUTH_ID, AUTH_DATA.CID_SSN_HASH, AUTH_DATA.CID_HASH FROM AUTH_DATA WHERE (AUTH_DATA.CID_HASH=[B@a61164) 938 [main] ERROR ElectionRunner - org.apache.torque.TorqueException: ERROR: parser: parse error at or near "[" Right now I'm feeding a byte[] into the criteria to select by. Is there some other type I should be using? I'm using a 3/17/2002 CVS build of torque; this happened in my last build (about a week old) as well. I'm using postgresql v7.2. The generated SQL is (correctly, I take it) using bytea for the VARBINARY fields. Any hints/suggestions/whatever? Thanks!
msg06847/pgp00000.pgp
Description: PGP signature
