password fields

[Ricardo Tercero Lozano <rt...@isoco.com>]

hello,

I'm working with OJB 0.98 and MySQL 4.07.

MySQL has field modifier functions for handling encrypted
text like MD5(), PASSWORD(), SHA1().

Is there any way to set this field modifiers in OJB to
automatically handle it when reading and inserting data?

(I mean, handle modifiers by database when doing queries,
not doing a MD5 for a password in Java and then set the
field to database).

thanks in advance,


--
------------------------------------------------------
Ricardo Tercero Lozano
iSOCO - Intelligent Software for the Networked Economy
e-mail: rtercero@isoco.com
Web: http://www.isoco.com
Francisca Delgado 11, 2nd floor
28108 Alcobendas
Madrid (Spain)
#T: +34 91 334 9750
    +34 91 334 9797 (Switchboard)
#F: +34 91 334 9799

Re: password fields

[Thomas Mahler <th...@web.de>]

Hi Ricardo,

Ricardo Tercero Lozano wrote:
> hello,
> 
> I'm working with OJB 0.98 and MySQL 4.07.
> 
> MySQL has field modifier functions for handling encrypted
> text like MD5(), PASSWORD(), SHA1().
> 
> Is there any way to set this field modifiers in OJB to
> automatically handle it when reading and inserting data?
> 
> (I mean, handle modifiers by database when doing queries,
> not doing a MD5 for a password in Java and then set the
> field to database).

Yes you can use any kind of functions in your queries. Please have a 
look the documentation in query.html.

cheers,
Thomas

> thanks in advance,
> 
> 
> --
> ------------------------------------------------------
> Ricardo Tercero Lozano
> iSOCO - Intelligent Software for the Networked Economy
> e-mail: rtercero@isoco.com
> Web: http://www.isoco.com
> Francisca Delgado 11, 2nd floor
> 28108 Alcobendas
> Madrid (Spain)
> #T: +34 91 334 9750
>     +34 91 334 9797 (Switchboard)
> #F: +34 91 334 9799
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: ojb-user-help@jakarta.apache.org
> 
>