*
The moose likes JDBC and the fly likes DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption" Watch "DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption" New topic
Author

DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption

peter cooke
Ranch Hand

Joined: Mar 16, 2004
Posts: 314
Over the years I have had two projects that would enrypt/decrypt values for specific columns in a DBMS table from a Java class. Once on oracle, and once on DB2. So I know it can be done.

I have just spent about 40 minutes searching the internet for an example of a java jdbc class that uses DBMS_OBFUSCATION_TOOLKIT.DES3[en/de]crypt.


I recall call something about a prepareCall command but that is about it.




similar example of what trying to accomplish.

given a table called APP_USER that contains login id, password, social security number.

insert into APP_USER (u_id, login_id,password, ssn) values (GENERATED_PK,'mylogin', dbms_obfuscation_toolkit.DES3Encrypt (unenrypted_input_string => v_password, key_string => v_key), encrypt ssn);


select dbms_obfuscation_toolkit.DES3decrypt(input_string => app_user.password, key_string => key) from app_user where login = ?
)


Anyone know of URL references for what I am trying to do


CIAO Peter M. Cooke
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60739
    
  65

Please do not post the same question more than once.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
Don't get me started about those stupid light bulbs.
 
subject: DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption
 
Similar Threads
Middlegen and Hibernate
DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption
how to capture form varibales in JSP and form a html link?
Urrgent Pls Advice as soon as possible
Simple form-based authentication using JAAS