Insert query works on phpMyAdmin but not with Java

Question

I have a problem with this query :

insert into PLAYER(PSEUDO, EMAIL, PASSWORD) values("Test","[email protected]",md5('pass'));

It works on phpMyAdmin, but in Eclipse it goes in the catch...

Can you tell me why ?

EDIT:

            // Si un textfield n'est pas renseignŽ (length=0), on affiche un
            // MessageDialgo...Sinon, on proc�de ˆ l'inscription (insert...)
            if (tfRegisterPseudo.getText().length() == 0
                    || tfRegisterEmail.getText().length() == 0
                    || tfRegisterPassword.getPassword().length == 0)
                JOptionPane.showMessageDialog(null,
                        "You forgot something...");
            else {
                query = "insert into PLAYER(PSEUDO, EMAIL, PASSWORD) "
                        + "values(\"" + tfRegisterPseudo.getText()
                        + "\",\"" + tfRegisterEmail.getText() 
                        + "\",md5('" + String.valueOf(tfRegisterPassword.getPassword()) + "'));";
                transmission.executeUpdate(query);
                JOptionPane.showMessageDialog(null,"Successfully registered !");
            }

            setContentPane(buildLogin());
            this.setVisible(true);

        } catch (Exception m) {
            // TODO Recuperer l'erreur de la BD et l'afficher
            System.out.println("An error occured.");
            JOptionPane.showMessageDialog(null,"An error occured.");
            System.out.println(query);
        }
    }

Can you share your java code?

Mureinik
– Mureinik

2014-02-13 14:16:40 +00:00
Commented Feb 13, 2014 at 14:16 — Mureinik
– Mureinik, Commented Feb 13, 2014 at 14:16
and the stack trace since it goes into the catch.

DanielBarbarian
– DanielBarbarian

2014-02-13 14:18:28 +00:00
Commented Feb 13, 2014 at 14:18 — DanielBarbarian
– DanielBarbarian, Commented Feb 13, 2014 at 14:18

Kurt Du Bois · Accepted Answer · 2014-02-13 14:26:12Z

2

In your code you use md5, which is a php-function. In java using the md5 hash algorithm will have to be called in a different manner.

answered Feb 13, 2014 at 14:26

Kurt Du Bois

7,6654 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert query works on phpMyAdmin but not with Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related