java - Postgres encryption is failing in hibernate -
i new postgresql. trying store data in postgres db in encrypted format. per postgres documentation should use pgcrypto. have implememted code in hibernate. if trying store data in plaintext format storing easily. when adding @columntransformer insertion failing below error message.
i have executed " create extension pgcrypto; "
thanks in advance.
18:07:46,814 info [stdout] (http-localhost/127.0.0.1:8080-1) hibernate: 18:07:46,814 info [stdout] (http-localhost/127.0.0.1:8080-1) insert 18:07:46,815 info [stdout] (http-localhost/127.0.0.1:8080-1) 18:07:46,815 info [stdout] (http-localhost/127.0.0.1:8080-1) book 18:07:46,815 info [stdout] (http-localhost/127.0.0.1:8080-1) (author, name, price, id) 18:07:46,815 info [stdout] (http-localhost/127.0.0.1:8080-1) values 18:07:46,815 info [stdout] (http-localhost/127.0.0.1:8080-1) (?, pgp_sym_decrypt(?, '*************'), ?, ?) 18:07:46,932 warn [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-localhost/127.0.0.1:8080-1) sql error: 0, sqlstate: 42883 18:07:46,933 error [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-localhost/127.0.0.1:8080-1) error: function pgp_sym_decrypt(character varying, unknown) not exist hint: no function matches given name , argument types. might need add explicit type casts. position: 56
Comments
Post a Comment