Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AES_DECRYPT in sql not working?

843842Dec 25 2008 — edited Dec 25 2008

hi all ! I have this piece of code in my java servlet

SELECT idPaciente, Nombres, Apellidos, DNI_NIF, Sexo, Nacimiento, tlf, tlf2, email," +
                " Direccion, Ciudad, Provincia, CP, Canal, Prescriptor, Cobertura, Seguridad_Social, Alta," +
                " Condicion, Responsable, Nombremp, NIFemp, Direccionemp, FormaPago, AES_DECRYPT(Cuenta,'text_key')," +
                " Baja  FROM PACIENTE WHERE idPaciente=?

And its telling me that Error: Column 'Cuenta' not found.

If I test the same query filling the ? into values in mysql query browser it works, I dont know what Im missing, Im loading the correct table in the correct context. And the column exists...

Any help is appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 22 2009

Added on Dec 25 2008

#java-servlet

1 comment

186 views