Hi, I tried out a small routine: 1. I have a table called "tbl_user" in my db (I tried out both on Oracle and MySQL). 2. I have a column for "login_name" and "password" in the same. 3. I store an encrypted password in "password". By encrypted I mean a string that has been converted to an array of bytes using the MD5 algorithm and the array of bytes converted back to a string. Naturally the resultant string has quite a few special characters. 4. When I try to query on this table to check for the equality of a user-password pair, I don't get a match. I do get a correct match when I run the same routine using JDBC connections. 5. Not only that, but when I try to access any row that has a byte array converted to a string, OJB reports a problem saying "Invalid Column Name". This happens for both the DBs I have experimented with. Is this a known bug in OJB? Or is this not a bug at all? I am puzzled because JDBC handles byte-arrays-converted-to-strings quite well by means of prepared statements etc. Has anyone faced this problem before? Regards, Sayontan.
