Hi,
H2 supports SHA256 natively, I would use it instead of MD5:
http://h2database.com/html/functions.html#hash
Regards,
Thomas
On Saturday, April 14, 2012, Christian MICHON wrote:
> On Friday, April 13, 2012 9:51:52 PM UTC+2, Christian MICHON wrote:
>>
>> Hi,
>>
>> I need to detect repetitions and updates in (relatively) small H2 tables.
>>
>> As such, I currently implemented using ruby and an external ORM a md5sum
>> calculation of all the keys concatenated into a string following their
>> natural order, which is stored back into a specific key.
>>
>> This involves a lot of communication with the H2 server, and I wish to
>> have it done natively (using java itself).
>> (...)
>>
>>
> After many experiments, I finally cracked it.
>
> Sharing it here, in case someone else finds this useful one day...
>
> CREATE ALIAS MD5 FOR
> "org.apache.commons.codec.digest.DigestUtils.md5Hex(java.lang.String)";
> CREATE TABLE TEST(ID IDENTITY, NAME VARCHAR(255), MD5 VARCHAR(32) AS
> MD5(NAME));
> INSERT INTO TEST (NAME) VALUES('The quick brown fox jumps over the lazy
> dog');
> SELECT * FROM TEST ORDER BY ID;
>
> Really powerful tool this H2 db... Congratulations again...
>
> Christian
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/UV44utlLiAYJ.
> To post to this group, send email to
> [email protected]<javascript:_e({}, 'cvml',
> '[email protected]');>
> .
> To unsubscribe from this group, send email to
> [email protected] <javascript:_e({}, 'cvml',
> 'h2-database%[email protected]');>.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
