SHA output different for Java and for MySQL

[Stuart Rogers]

Greetings all,

This code

package door.model;

import java.io.*;
import java.util.*;
import java.lang.reflect.*;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.text.DecimalFormat;
import java.net.*;
import java.sql.*;

import org.apache.commons.codec.binary.*;     // need to grab this from apache commons codec

import java.io.UnsupportedEncodingException;
import java.security.*;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

public class TestSha {

    /**
     * @param args
     */
    public static void main(String[] args) {
        
        String clearText, encodedText, hexEncodedText;
        MessageDigest md;
        byte[] clearTextAsBytes, encodedTextAsBytes;
        Hex smoke = new Hex("UTF-8");
        
        clearText = "testmetest";
        try {
            System.out.println("clearText:" + clearText);
            
            clearTextAsBytes = clearText.getBytes("UTF-8");   // use UTF-8 so java jibes with mysql
            md = MessageDigest.getInstance( "SHA" );
            md.reset();
            md.update( clearTextAsBytes );
            encodedTextAsBytes = md.digest( clearTextAsBytes);

            // Hex           
            hexEncodedText = Hex.encodeHexString( md.digest() );
            System.out.println("HexEncoded: " + hexEncodedText);
            
        } catch (UnsupportedEncodingException e) {
            System.out.println("EEKS");
        } catch (NoSuchAlgorithmException e) {
            System.out.println("ACHS");
        }

    }

}

yields

clearText:testmetest
HexEncoded: da39a3ee5e6b4b0d3255bfef95601890afd80709

but in MySQL 5.0.51a

select SHA('testmetest');

yields

SHA("testmetest")
-----------------------------------------------
3c8c9c27ee3679165ec2eb3b857c1a4cf42b55aa

what do I need to do to get my Java code's result to match what MySQL generates?


TIA,

Still-learning Steve

[Wouter Oet]

You're doing an update and a digest with the same value. So you're adding it twice. Just remove the update.

[Stuart Rogers]

D-oH! Serves me right for trying to code at 02:45 . Yes you are absolutely correct.

CASE CLOSED

Thanks!

Still-learning-and-sleepy Steve